We are evaluating Looker against Tableau and PowerBI today for a new enterprise deployment, so what are the major performance differences when querying billions of rows in Snowflake?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
We are evaluating Looker against Tableau and PowerBI today for a new enterprise deployment, so what are the major performance differences when querying billions of rows in Snowflake?
4 real searches · 1 real-search pass
Looker Tableau Power BI Snowflake performance query pushdown live connection extract DirectQuery billion rows official documentationGoogle ↗
OBSERVED
Looker query performance caching aggregate awareness Snowflake official docsGoogle ↗
OBSERVED
Tableau Snowflake live connection extract performance official docsGoogle ↗
OBSERVED
Power BI Snowflake DirectQuery Import composite model performance official docsGoogle ↗
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 4 queries…
Searches and sources
ChatGPT4 real searches · gpt-6
Looker Tableau Power BI Snowflake performance query pushdown live connection extract DirectQuery billion rows official documentation Google ↗
Looker query performance caching aggregate awareness Snowflake official docs Google ↗
Tableau Snowflake live connection extract performance official docs Google ↗
Power BI Snowflake DirectQuery Import composite model performance official docs Google ↗
- Using the Explore query tracker and Performance panel to monitor query performance | Looker | Google Cloud Documentation · docs.cloud.google.com
- Optimize Looker performance | Google Cloud Documentation · docs.cloud.google.com
- Composite model guidance in Power BI Desktop - Power BI · learn.microsoft.com
- DirectQuery in Power BI: When to Use, Limitations, Alternatives - Power BI · learn.microsoft.com
- Use DirectQuery in Power BI Desktop - Power BI · learn.microsoft.com
- Working with Materialized Views · docs.snowflake.com
- Pushdown Optimization and Data Visibility · docs.snowflake.com
Queries
4 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
Looker Tableau Power BI Snowflake performance query pushdown live connection extract DirectQuery billion rows official documentation OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
Looker query performance caching aggregate awareness Snowflake official docs OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
Tableau Snowflake live connection extract performance official docs OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
Power BI Snowflake DirectQuery Import composite model performance official docs OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 |