Real ChatGPT answer · index seedVidxTli6bsocompleteB2B software · data and analytics platformsinformational
Looker query performance has degraded significantly since we upgraded our underlying BigQuery dataset, so what caching strategies can I implement this afternoon to speed things up?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
Looker query performance has degraded significantly since we upgraded our underlying BigQuery dataset, so what caching strategies can I implement this afternoon to speed things up?
2 real searches · 1 real-search pass
official Looker documentation query caching persist_for datagroups persistent derived tables BigQuery materialized views BI Engine result cache performanceGoogle ↗
OBSERVED
site:cloud.google.com/looker/docs caching queries datagroups persist_with persist_for Explore query cache BigQuery BI Engine materialized views smart tuningGoogle ↗
OBSERVED
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
Classifying 2 queries…
Searches and sources
ChatGPT2 real searches · gpt-6
official Looker documentation query caching persist_for datagroups persistent derived tables BigQuery materialized views BI Engine result cache performance Google ↗
site:cloud.google.com/looker/docs caching queries datagroups persist_with persist_for Explore query cache BigQuery BI Engine materialized views smart tuning Google ↗
- Looker caching with BigQuery · 14503840.fs1.hubspotusercontent-na1.net
- M5_Derived_Tables · storage.googleapis.com
- Looker aggregate awareness · cloud.google.com
- Optimize Looker performance | Google Cloud Documentation · docs.cloud.google.com
- Derived tables in Looker | Google Cloud Documentation · docs.cloud.google.com
- Google: Optimize Looker performance · cloud.google.com
- Google: BigQuery BI Engine · cloud.google.com
- Google: Looker derived tables · cloud.google.com
Queries
2 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
official Looker documentation query caching persist_for datagroups persistent derived tables BigQuery materialized views BI Engine result cache performance OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
site:cloud.google.com/looker/docs caching queries datagroups persist_with persist_for Explore query cache BigQuery BI Engine materialized views smart tuning OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 |