Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Wildcards in Dataform sqlx files?

I'm trying to figure out the best way to reference multiple tables with the same schema across multiple datasets in, for example, definitions and includes files.

For example, I have a project that has different datasets for each client. And inside those datasets they have FBADS_AD_* sharded tables. My goal would be to dynamically reference all applicable tables and create report-ready views for each table.

Any help would be much appreciated!

0 4 1,536
4 REPLIES 4