There is a way to execute the entire SQL workflow, explained here. But, there is a way to execute only certain .sqlx files (not the entire SQL workflow) of the dataform repository? I want to execute some tables every 3h, others every 6h, but is that possible?
Hi, its possible. you have to add tags https://cloud.google.com/dataform/docs/tags
One tag could be every_3h and the other one every_6h. You can make up several tags and enter them per file and you can use each tag according to any rules.
Nice! Thanks for hoping onto this thread @psandmann and helping out!