Sources
Current schema: v3
Produced by: source freshness
This file contains information about sources with freshness checks. Today, dbt Cloud uses this file to power its Source Freshness visualization.
Top-level keys
metadata
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 tosources
in the manifestmax_loaded_at
: Max value ofloaded_at_field
timestamp in the source table when queried.snapshotted_at
: Current timestamp when querying.max_loaded_at_time_ago_in_s
: Interval betweenmax_loaded_at
andsnapshotted_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 onmax_loaded_at_time_ago_in_s
+criteria
, reported on the CLI. One ofpass
,warn
, orerror
if the query succeeds,runtime error
if 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).execution_time
: Total time spent checking freshness for this sourcetiming
: Array that breaks down execution time into steps (compile
+execute
)
0