How do I disable the elementary upload of data to the elementary data model via vars

To disable Elementary from uploading data into its tables, set the relevant

vars

in your

dbt_project.yml

. You can turn off all uploads, or only specific parts. Disable all uploads (metadata + run/test results + invocations):

vars:
  disable_dbt_artifacts_autoupload: true   # metadata tables: dbt_models, dbt_tests, dbt_sources, etc.
  disable_run_results: true               # dbt_run_results, model_run_results, etc.
  disable_tests_results: true             # elementary_test_results
  disable_dbt_invocation_autoupload: true # dbt_invocations and related

With these set to

true

, the on‑run‑end hooks will still execute but should not write to the Elementary tables. [On-run-end hooks; Disable hooks vars] If you want to control this per environment (e.g., only upload in prod), you can make them conditional:

vars:
  disable_dbt_artifacts_autoupload: "{{ target.name != 'prod' }}"
  disable_run_results: "{{ target.name != 'prod' }}"
  disable_tests_results: "{{ target.name != 'prod' }}"
  disable_dbt_invocation_autoupload: "{{ target.name != 'prod' }}"

[Env-based control; Reduce on-run-end time] 👍 0 button 👎 0 button ℹ️ Tip: Mention @elementary.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Via cli command

You can disable Elementary uploads via CLI by passing the same vars with

--vars

(these override

dbt_project.yml

for that run). Disable all uploads for a single run:

dbt run \
  --vars '{
    "disable_dbt_artifacts_autoupload": true,
    "disable_run_results": true,
    "disable_tests_results": true,
    "disable_dbt_invocation_autoupload": true
  }'

This pattern is documented for disabling on‑run‑end hooks via CLI vars. [On-run-end hooks; Slack example] You can also only disable artifacts (keep results) like:

dbt run --vars '{"disable_dbt_artifacts_autoupload": true}'

👍 0 button 👎 0 button ℹ️ Tip: Mention @elementary.ai in the thread for follow-ups or DM the app for 1-to-1 help.

@kapa.ai so this works? dbt test --vars '{disable_run_results: True, disable_test_results: True, disable_dbt_artifacts_autoupload: True, disable_dbt_invocation_autoupload: True}'

Almost — two small fixes: 1. Use JSON-style syntax (double quotes, lowercase booleans). 2. The var is

disable_tests_results

(plural), not

disable_test_results

. So the recommended command is:

dbt test --vars '{
  "disable_run_results": true,
  "disable_tests_results": true,
  "disable_dbt_artifacts_autoupload": true,
  "disable_dbt_invocation_autoupload": true
}'

Passing these via

--vars

is explicitly supported and overrides

dbt_project.yml

for that run. [On-run-end hooks; CLI override example] 👍 0 button 👎 0 button ℹ️ Tip: Mention @elementary.ai in the thread for follow-ups or DM the app for 1-to-1 help.