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
-
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