dbt_project.yml

name: 'sushi'
version: '1.0.0'
config-version: 2
profile: 'sushi'

model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]

target-path: "target"  # directory which will store compiled SQL files
clean-targets:         # directories to be removed by `dbt clean`
  - "target"
  - "dbt_packages"

# Configuring models
# Full documentation: https://docs.getdbt.com/docs/configuring-models

models:
  sushi:
    +materialized: table
    +pre-hook:
      - '{{ log("pre-hook") }}'
    +post-hook:
      - '{{ log("post-hook") }}'

seeds:
  sushi:
    +pre-hook:
      - '{{ log("pre-hook") }}'
    +post-hook:
      - '{{ log("post-hook") }}'

sources:
  +quoting:
    identifier: false

vars:
  top_waiters:limit: 10
  'top_waiters:revenue': "revenue"

  # The following are only used for testing purposes
  customers:boo: ["a", "b"]

  yet_another_var: 1
  dynamic_test_var: 3

  customers:
    some_var: ["foo", "bar"]
    'customers:bla': false
    'customers:customer_id': "customer_id"

  nested_vars:
    some_nested_var: 2

  list_var:
    - name: 'item1'
      value: 1
    - name: 'item2'
      value: 2


on-run-start:
  - 'CREATE TABLE IF NOT EXISTS analytic_stats (physical_table VARCHAR, evaluation_time VARCHAR);'
  - 'CREATE TABLE IF NOT EXISTS to_be_executed_last (col VARCHAR);'
  - SELECT {{ var("yet_another_var") }} AS var, '{{ source("raw", "items").identifier }}' AS src, '{{ ref("waiters").identifier }}' AS ref;
  - "{{ log_value('on-run-start') }}"
on-run-end:
  - '{{ create_tables(schemas) }}'
  - 'DROP TABLE to_be_executed_last;'
  - '{{ graph_usage() }}'