Jaime Raldua Veuthey

02/15/2023, 4:58 PM
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!

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?

Jaime Raldua Veuthey

02/17/2023, 4:51 PM
Thanks! I will check it out!