Hi, this might be a stupid question, but is it possible to schedule queries created with dbt inside Bigquery?
We are looking to have views, ... created into Bigquery and would like to know if I can schedule when they run inside a flow. Atm we have them as scheduled queries that run at specific times.
Thanks!
s
Sean Williams
02/16/2023, 3:32 PM
If I understand your question correctly, you could definitely use dbt to create views in Bigquery and schedule them with Prefect. Have you seen prefect-dbt?
Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.