Replies: 1 comment
-
|
figured out how to do this, run_started_at is a jinja variable available in dbt. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
dbt_artifacts upload_results writes the run_started_at into the logging table. I am thinking of using that time for Snowflake time travel, so in the dbt project run, all source tables will be queried at a consistent time.
example in a model file would be
where get_dbt_run_time() is a macro to get the latest run_started_at from invocations table for the project_name, provided the invocation entry is created before any model runs
Beta Was this translation helpful? Give feedback.
All reactions