dbt_project.yml

# Name your project! Project names should contain only lowercase characters
# and underscores. A good package name should reflect your organization's
# name or the intended use of these models
name: 'balancer'
version: '1.0.0'

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

# SSL certificate validation is disabled by default. It is legacy behavior which will be changed in future releases.
# It is strongly advised to enable `require_certificate_validation` flag or explicitly set `cert` configuration to `True` for security reasons.
#You may receive an error after that if your SSL setup is incorrect.
flags:
  require_certificate_validation: true

# These configurations specify where dbt should look for different types of files.
# The `model-paths` config, for example, states that models in this project can be
# found in the "models/" directory. You probably won't need to change these!
model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]

clean-targets:         # directories to be removed by `dbt clean`
  - "target"
  - "dbt_packages"

models:
  dbt_template:
    # Config indicated by + and applies to all files under models/templates/
    +materialized: view       # fallback default, materialized should be overriden in model specific configs
    +view_security: invoker   # required security setting for views
    +post-hook:
      - sql: "{{ optimize_table(this, model.config.materialized) }}"
        transaction: true
      - sql: "{{ vacuum_table(this, model.config.materialized) }}"
        transaction: true