I keep having an issue w/ OSS where the elementary...
# community-support
c
I keep having an issue w/ OSS where the elementary tables keep getting truncated for some reason. Like I run source freshness and in the logs I see:
Copy code
16: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:
Copy code
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