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!