Clay Johns
08/12/2026, 9:37 PM16:27:10.775302 [debug] [Dummy-1 ]: SQL status: SUCCESS 96 in 1.107 seconds
16:27:10.782603 [debug] [Dummy-1 ]: Elementary: Measured durations for context - upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS]:
16:27:10.785511 [debug] [Dummy-1 ]: Elementary: upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS].artifacts_flatten: 0:00:00.033175 (1 runs)
16:27:10.788204 [debug] [Dummy-1 ]: Elementary: upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS].insert_rows.get_columns_in_relation: 0:00:00.090482 (1 runs)
16:27:10.790742 [debug] [Dummy-1 ]: Elementary: upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS].insert_rows.get_insert_rows_queries.base_query_calc: 0:00:00.008085 (1 runs)
16:27:10.793319 [debug] [Dummy-1 ]: Elementary: upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS].insert_rows.get_insert_rows_queries.render_row_to_sql: 0:00:01.577595 (96 runs)
16:27:10.795835 [debug] [Dummy-1 ]: Elementary: upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS].insert_rows.get_insert_rows_queries: 0:00:01.633232 (1 runs)
16:27:10.798535 [debug] [Dummy-1 ]: Elementary: upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS].insert_rows.run_insert_rows_query: 0:00:01.131391 (1 runs)
16:27:10.801206 [debug] [Dummy-1 ]: Elementary: upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS].insert_rows.commit: 0:00:00.001003 (1 runs)
16:27:10.803650 [debug] [Dummy-1 ]: Elementary: upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS].insert_rows: 0:00:02.863358 (1 runs)
16:27:10.806335 [debug] [Dummy-1 ]: Elementary: upload_artifacts_to_table[DBT_SOURCE_FRESHNESS_RESULTS]: 0:00:02.900628 (1 runs)
16:27:10.823213 [debug] [Dummy-1 ]: Elementary: Uploading dbt invocation.
16:27:10.902747 [debug] [Dummy-1 ]: Using snowflake connection "master"
But there aren't any rows in the table DBT_SOURCE_FRESHNESS_RESULTS
Any idea what I am doing wrong?
command - source freshness --target prod
Excerpts from the dbt_project.yml:
flags:
source_freshness_run_project_hooks: true
models:
elementary:
+schema: 'ELEMENTARY'
+full_refresh: "{{ var('elementary_full_refresh', false) }}"
disable_dbt_artifacts_autoupload: "{{ target.name == 'dev' }}"
disable_run_results: false
disable_tests_results: false
disable_dbt_invocation_autoupload: false
elementary_full_refresh: false