bit_dbt/dbt_project.yml at main · bandsintown/bit_dbt · 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
72
73
74
name: 'bandsintown'
version: '1.0.0'
config-version: 2

# This setting configures which "profile" dbt uses for this project.
profile: 'bandsintown'

# These configurations specify where dbt should look for different types of files.
model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]

clean-targets:
  - "target"
  - "dbt_packages"
  - "logs"

# Require explicit project references in sources and models
require-dbt-version: [">=1.7.0", "<2.0.0"]

# Global model configurations
models:
  bandsintown:
    staging:
      +materialized: view
      +tags: ["staging"]
    intermediate:
      +materialized: view
      +tags: ["intermediate"]
    marts:
      +materialized: table
      +tags: ["marts"]
      +format: parquet
      +write_compression: snappy
      core:
        +schema: analytics
      feature_events:
        +schema: bit_dbt_feature_events
# Documentation
vars:
  # Timezone for timestamp conversions
  timezone: 'America/Los_Angeles'

  # Default start date for incremental models
  default_start_date: '2024-01-01'

# Test configurations
tests:
  +store_failures: true
  +schema: dbt_test_failures

# Seeds configuration
seeds:
  bandsintown:
    +schema: bit_dbt_feature_events
    +quote_columns: false
    came_from_traffic_source:
      +column_types:
        came_from: integer
        traffic_source_category: varchar
    venue_capacity_tiers:
      +column_types:
        venue_capacity_min: integer
        venue_capacity_max: integer
        venue_size_bucket: varchar
        tier_price: double
    artist_size_buckets:
      +column_types:
        tracker_count_min: integer
        tracker_count_max: integer
        artist_size_bucket: varchar