Search code examples
google-cloud-platformgoogle-bigquerydbt

Running dbt vs scheduled queries on bigquery

I am trying to see if there are any benefits to running dbt on bigquery as oppose to scheduled queries. Hence, what are the benefits?

Solution

  • If DBT runs a simple query, there is no real advantages. But in that case, I won't use Schedule queries, but Cloud Workflows, or Cloud Scheduler that invoque a BigQuery API call (jobs API, with a query job).

    However, if you build a complex query, DBT can help you to create and maintain it, even to create temporary working table to get the final table.

    But at the end of the day, DBT is simply a SQL query generator and you can schedule the output with the service that you prefer.