CATEGORIES / WAREHOUSES AND LAKEHOUSES

Warehouses and lakehouses software: how much control do you have?

Compare SQL access, table exports and retained change feeds.

3 category vendor reviewsPermute reference includedProvider documentation, not live tenant tests

Where the reviewed products stand

Compare documented control across the named products and routes. Open a review for its plan, region and agreement (this is a selected sample).

Warehouses and lakehouses: customer control map

0–10 on both axes · Higher and further right means more documented control

Data access and portability on the horizontal axis; build and act on the vertical axis. Exact scores and review links follow in the table. Dashed lines mark 5, not a grade threshold.BUILD WITH LIMITSMORE CUSTOMER CONTROLMORE DEPENDENCEPORTABLE, LESS EXTENSIBLE00551010Data access & portability →Build & act →Google BigQuery: 9.3 / 6.3BIDatabricks*: 8.0 / 7.2DASnowflake*: 8.3 / 7.6SNPermute*: 8.0 / 7.1P
Exact scores & review links (4)
Vendor positions
VendorData access & portabilityBuild & act
Google BigQuery ↗9.36.3
Databricks ↗8.0*7.2*
Snowflake ↗8.3*7.6*
Permute ↗Publisher self-assessment8.0*7.1*

Axes average three dimensions each: access, third-party access and exit horizontally; action, continuity and business logic vertically. Fixed 0–10 scale, midlines at 5 (overall grades use separate weights). * Some evidence is unresolved. Marker colors identify companies, not score bands. How to read the map ↗

Permute is included as a reference (it owns this site and is a publisher self-assessment). Its score is excluded from sample averages. Read the Permute review ↗

Table queries, outbound change capture and ingestion into a warehouse are separate routes. Retention, configured tables and row identity bound recovery.

Compare the six dimensions

Comparing 2 of 4 vendors
Overall control
Data access
Third-party accessibility
External action
Continuity
Data exit
Business logic and customization
Product scopes, dates & reviews

Google BigQuery

Warehouses and lakehouses · Checked 2026-10-12

BigQuery / customer-managed Google Cloud project, GoogleSQL and export jobs. This is data infrastructure, not a bundled business application.

Read findings and sources ↗

Databricks

Warehouses and lakehouses · Checked 2026-10-16

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Read findings and sources ↗
Customer controlGoogle BigQuery ↗Databricks ↗Snowflake ↗Permute ↗
CategoryWarehouses and lakehousesWarehouses and lakehousesWarehouses and lakehousesDatabases and data platforms
Overall control
Data access
Third-party accessibility
External action
Continuity
Data exit
Business logic and customization
Assessment scopeBigQuery / customer-managed Google Cloud project, GoogleSQL and export jobs. This is data infrastructure, not a bundled business application.Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.Permute hosted workspaces / scoped REST and TypeScript SDK access to connected query sources, file datasets, managed database records, operation code and custom apps. Signed enterprise contracts and upstream vendor rights remain separate; no live tenant migration or reliability test was performed.
Assessment checked2026-10-122026-10-162026-10-162026-10-12
Read the findingsDetailed review ↗Detailed review ↗Detailed review ↗Detailed review ↗

Scores are out of 10. * Incomplete evidence discounts verified capabilities (unknown answers stay unknown). Planned migration drives data exit. Scoring method ↗

Who can connect?

Credentials and approval by connection method

Yes No- Unknown

A check means the column applies to that route (customer credentials can still require provider approval). Report exports use the customer account without separate API credentials. Open a connection method for its authentication, requirements and last review date.

What each review covers

Google BigQuery ↗

BigQuery exposes SQL and export jobs directly. IAM grants control access, while query processing, storage and destination charges determine the practical cost of moving data.

BigQuery / customer-managed Google Cloud project, GoogleSQL and export jobs. This is data infrastructure, not a bundled business application.

Read the findings and sources ↗

Databricks ↗

Databricks exposes governed SQL and retained Delta table changes. Change data feed begins after enablement and is not a permanent audit archive; consumers must manage table keys, retained versions and checkpoints.

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Read the findings and sources ↗

Snowflake ↗

Snowflake exposes SQL table access and customer-consumable stream offsets. Standard streams can capture deletes, but they can become stale if table history is not consumed within its retention policy.

Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.

Read the findings and sources ↗

Permute ↗

Scoped APIs expose SQL reads, managed records and customer-authored operation code. Customer-built apps are supported, while complete workspace recovery, outbound CDC and minimum-plan access terms remain unresolved.

Permute hosted workspaces / scoped REST and TypeScript SDK access to connected query sources, file datasets, managed database records, operation code and custom apps. Signed enterprise contracts and upstream vendor rights remain separate; no live tenant migration or reliability test was performed.

Read the findings and sources ↗

Browse all categories ↗