dbt_leaner_query/dbt_project.yml at main · grafana/dbt_leaner_query · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
name: 'leaner_query'
version: '1.0.0'
config-version: 2

profile: 'leaner_query'

require-dbt-version: [">=1.3.0", "<2.0.0"]

target-path: "target"
clean-targets:
    - "target"
    - "dbt_packages"

models:
  leaner_query:
    +schema: leaner_query
    +tags:
      - leaner_query

    marts:
      materialized: table

    reports:
      materialized: table

    staging:
      materialized: view

    intermediate:
      +materialized: table

    utils:
      materialized: ephemeral


vars:
  leaner_query_priority_threat_level_weight: .65
  leaner_query_priority_importance_level_weight: .35
  leaner_query_weight_threat__service_account_egress: 0.35
  leaner_query_weight_threat__cost_to_query: 0.30
  leaner_query_weight_threat__cost_to_build: 0.25
  leaner_query_weight_threat__daily_errors: 0.10
  leaner_query_weight_importance__service_account_queries: 0.2
  leaner_query_weight_importance__dbt_queries: 0.2
  leaner_query_weight_importance__egress_use: 0.35
  leaner_query_weight_importance__user_breadth: 0.25

  leaner_query_require_partition_by_reports: true
  leaner_query_enable_reports: true
  leaner_query_enable_dev_limits: true

  leaner_query_dev_limit_days: 30
  leaner_query_dev_target_name: ['dev']

  #Client types
  leaner_query_importance_query_score_1: ['Web console']
  leaner_query_importance_query_score_2: ['Connected Sheet - User Initiated', 'Connected Sheet - Scheduled', 'Scheduled Query']
  leaner_query_importance_query_score_3: []
  leaner_query_importance_query_score_4: []

  leaner_query_prod_dataset_names: []
  leaner_query_stage_dataset_names: []

  leaner_query_custom_clients: []

  # principal emails used for egress
  leaner_query_custom_egress_emails: []

  leaner_query_bq_on_demand_pricing: 6.225
  leaner_query_bq_slot_pricing: {'standard': 0.04, 'enterprise': 0.06, 'enterprise_plus' : 0.10}
  leaner_query_bq_pricing_schedule: on_demand