I am trying to ingest a BigQuery table (from GA) into Azure Synapse but the table is partitioned and every day a new partition is added to it. The table names are like this:
analytics_36523423.events_20230207
analytics_36523423.events_20230208
analytics_36523423.events_20230209
How can I set it up to automatically copy data from new tables?
