In My Project we have divided BigQuery table into multiple shard tables to limit on scanning the data. How can we use these tables in tableau to hit right shared table. Also we have multiple BigQuery tables which are divided into shared tables in same Data model and all are confirmed to day dimension. How can we make sure that query hitting all relevant shared tables based on user selection(Month/Quarter).
You can use the table id and limit the result set too.
check the below threads.
hope it helps you.