You can optimize the performance of reports based on BigQuery data by using the following techniques. These techniques can help your visualizations render more quickly while minimizing BigQuery costs.
Improve performance with the BigQuery Storage Read API
For queries that use paginated results, enabling the BigQuery Storage Read API can lead to improved query times. Data Studio automatically uses the Storage Read API when doing so improves query runtimes.
To enable the BigQuery Storage Read API, grant the following permissions to your BigQuery user who is connected to Data Studio:
bigquery.readsessions.createbigquery.readsessions.getData
Accelerate reports with BigQuery BI Engine
BigQuery BI Engine is a fast, high-concurrency, in-memory analysis service built into BigQuery. By configuring BI Engine with Data Studio, your visualizations render in sub-second time while reducing query concurrency costs (Learn more about the BigQuery BI Engine).
Requirements to use BI Engine with Data Studio
To accelerate your Data Studio reports by using BI Engine, verify the following prerequisites:
- Data storage: You store reporting data in standard BigQuery tables or views.
- Billing project: You designate a valid BigQuery billing project that has active Google Cloud billing enabled.
- API enablement: You enable the BigQuery API (
bigquery.googleapis.com) in your project. - Capacity reservation: You have configured an active BI Engine capacity reservation (
SIZE_IN_GB) for the project where queries execute.
For detailed performance benchmarks and table optimization guides for BI Engine, see Analyze BigQuery data with Data Studio.