Monitor and analyze the SQL queries that Data Studio sends to your BigQuery data sources. You can inspect generated SQL, optimize report performance, and track billing costs.
View SQL issued to BigQuery
You can inspect the exact SQL queries that are generated by Data Studio directly inside the BigQuery Query History console.
Analyze Data Studio queries with job labels
Every query that is sent from Data Studio to BigQuery includes the job label requestor:looker_studio. Google Cloud administrators can filter billing reports by using this label to track exact costs and query volume from Data Studio (Learn more about viewing job labels).
BigQuery chart execution dialog
If your data source uses owner credentials and you hold owner permissions on the underlying BigQuery project, Data Studio displays a BigQuery icon inside the upper-right corner of any chart that is powered by the connector. Hover over the chart and click the icon to open the Powered by BigQuery dialog, which shows:
- The exact SQL query used by the chart
- The raw data returned by the query
- A step-by-step breakdown of query timing
- Diagnostics including runtimes, bytes billed, and slot usage