Google BigQuery has neat functionality that allows users to schedule queries in standard SQL, DDL or DML statements. Additionally, you can set them to run on a recurring basis. This can be great for light transformations; however, if more comprehensive transformation and automated regression testing is needed dbt (data build tool) is an affordable solution. [...]
About Red Pill Analytics
Red Pill Analytics combines the best elements of cloud, agile development-as-a-service, and continuous delivery to form a unique analytics services company. We continuously evaluate, modernize, and automate to deliver a more valuable, less expensive model.
- Coming from your Friendly Neighborhood Snowflake Data Hero
- Dynamic Looker Visualization based on Dimensional Hierarchies
- Bored in Quarantine? Our Events are now Free Webinars!
- Oracle Analytics Desktop Doesn’t Connect To Snowflake?!?!
- How DBT was used to convert from Google BigQuery Scheduled Queries