Here is an example of my dbt project yaml file and I have a pre-hook to set the query tag on all the models using a macro. Is there a way to set a pre-hook for all the models in the dbt CLI, or how would i go about doing this?
I am raising this issue because I want to apply this pre-hook to a bunch of dbt projects that I work with (20+) at a single time.
# 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: 'data_foundation'
version: '1.2.0'
config-version: 2
# This setting configures which "profile" dbt uses for this project.
profile: 'default'
# 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"]
target-path: "target" # directory which will store compiled SQL files
clean-targets: # directories to be removed by `dbt clean`
- "target"
- "dbt_packages"
models:
+pre-hook: "{{ standard_package.set_query_tag() }}"
data_foundation:
# Config indicated by + and applies to all files under models/example/
example:
+schema: STG
+materialized: view
Appreciate any suggestions!