- Run the following commands from the current directory
python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt
export DBT_PROFILES_DIR=${PWD}/profiles
-
Update
profiles/profiles.ymlwith your own E2 Dogfood catalog, schema, and PAT -
Run
dbt run --select query_tags_demoto materialize the output table -
Go to E2 Dogfood and query
system.query.historyto find statements executed by the dbt run. For example:SELECT * FROM system.query.history WHERE client_application LIKE '%Dbt%' AND query_tags IS NOT NULL