dbt source snapshot-freshness
elapsed_time: Total invocation time in seconds.
results: Array of freshness-check execution details.
Each entry in
results is a dictionary with the following keys:
unique_id: Unique source node identifier, which map results to
sourcesin the manifest
max_loaded_at: Max value of
loaded_at_fieldtimestamp in the source table when queried.
snapshotted_at: Current timestamp when querying.
max_loaded_at_time_ago_in_s: Interval between
snapshotted_at, calculated in python to handle timezone complexity.
criteria: The freshness threshold(s) for this source, defined in the project.
status: The freshness status of this source, based on
criteria, reported on the CLI. One of
errorif the query succeeds,
runtime errorif the query fails.
adapter_response: Dictionary of information returned from the database, which varies by adapter. Not populated by source freshness checks, as of v0.19.0; we plan to fix in a future release (dbt#2580).