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.