Question
How to set an upper limit for data processing in Tableau when connected with BigQuery.
Last Modified Date: 08 Jul 2022
Environment
- Tableau Desktop
- Google BigQuery
Answer
The ability to set a limit on data processing in Tableau Desktop is currently not built in the product yet.But there are two workarounds that may limit the amount of data processing in Google BigQuery:
1. Use custom SQL to get only the columns you need.
When connecting to BigQuery, instead of retrieving all columns from the data source, you can retrieve only the columns you need for your analysis.
This will reduce the amount of data processing on the BigQuery side.
For more details about custom SQL, please refer to the following online help.
Connect to a Custom SQL Query
2. Create an Extract.
Extract allows you to store and manipulate data locally to avoid pulling the data from BigQuery every time.
For more information about data extraction, please refer to the following online help.
Extract Your Data
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials