Why is our Looker query performance suddenly so terrible after migrating to Snowflake and what specific indexing or PDT changes fix this issue immediately?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
Why is our Looker query performance suddenly so terrible after migrating to Snowflake and what specific indexing or PDT changes fix this issue immediately?
2 real searches · 1 real-search pass
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
Looker Snowflake performance optimization persistent derived tables clustering micro-partition pruning official documentation Google ↗
Snowflake query performance search optimization service clustering keys materialized views official documentation Google ↗
- Derived tables in Looker | Google Cloud Documentation · docs.cloud.google.com
- Optimizing storage for performance · docs.snowflake.com
- Optimizing query performance · docs.snowflake.com
- Clustering Keys & Clustered Tables · docs.snowflake.com
- Micro-partitions & Data Clustering · docs.snowflake.com
- Derived tables in Looker | Google Cloud Documentation · docs.cloud.google.com
- Optimize Looker performance | Google Cloud Documentation · docs.cloud.google.com
- Working with Materialized Views · docs.snowflake.com
Queries
2 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
Looker Snowflake performance optimization persistent derived tables clustering micro-partition pruning official documentation OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
Snowflake query performance search optimization service clustering keys materialized views official documentation OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 |