Forum Discussion
Scheduling a Dymanic Table for data refresh
Hi ,
My Team is building a dashboard that sources data from bigquery , the challenge is that Big Query table is a dynamic entity which is names as my_events_07/16/2019 and tomorrow my report should pick data from my_events_07/17/2019. How can I schedule a data refresh where the table name changes based on date?
Regards,
Mohammad
1 Reply
is it not possible to create a table name that is going to remain static? ie copy the table with the date name to a table that doesn't change name? Anonymous i personally dont know the answer, but i would think potentially you could create a parameter and calculated what the table name is going to be. Is this a imported data model?
