# Delta Lake vs Google BigQuery

| Attribute | Delta Lake | Google BigQuery |
|---|---|---|
| **vioscaleAI score** | 61 (58% (medium)) | 61.1 (40% (low)) |
| activity.commits_last_30d | 100 | - |
| adoption.dependent_repos | 152 | - |
| adoption.github_stars | 9,042 | - |
| adoption.package_downloads_weekly | 6,751,062 | - |
| content.faq | `[{"answer":"An open-source storage framework enabling lakehouse architecture with support for multiple compute engines including Spark, Flink, Trino, Snowflake, BigQuery, and others. It is indexed under Data Warehouse Software.","source":"https://delta.io","question":"What is Delta Lake?","confidence":0.6},{"answer":"Delta Lake is open source, so it can be self-hosted and used at no licence cost. It is released under the Apache-2.0 licence. Pricing changes often, so verify at source before relying on it.","source":"https://delta.io","question":"Is Delta Lake free to use?","confidence":0.6},{"answer":"Yes. Delta Lake can be deployed cloud / SaaS, on-premise and self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://delta.io","question":"Can Delta Lake be self-hosted?","confidence":0.6},{"answer":"We have confirmed 29 integrations for Delta Lake, including Apache Spark, Apache Flink, Apache Hive, Apache Pulsar, Apache Druid, ClickHouse, Trino and PrestoDB, plus 21 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://delta.io","question":"What does Delta Lake integrate with?","confidence":0.6},{"answer":"Yes. Delta Lake is published under the Apache-2.0 licence, a permissive licence that generally allows commercial use and modification. Licence terms can change between releases, so verify against the repository for the version you intend to use.","source":"https://github.com/delta-io/delta","question":"Is Delta Lake open source?","confidence":0.99}]` | `[{"answer":"A fully managed, serverless cloud analytics engine that combines data storage, real-time processing, and integrated machine learning capabilities in a unified platform. It is indexed under Data Warehouse Software.","source":"https://cloud.google.com/bigquery","question":"What is Google BigQuery?","confidence":0.6},{"answer":"Google BigQuery offers a free tier, so you can start without paying. Pricing changes often, so verify at source before relying on it.","source":"https://cloud.google.com/dotnet/docs/reference/Google.Cloud.Channel.V1/1.7.0/Google.Cloud.Channel.V1.ListChannelPartnerRepricingConfigsResponse","question":"Is Google BigQuery free?","confidence":0.6},{"answer":"We have confirmed browser-based access to Google BigQuery. That is the extent of what we could verify from public sources, so it may well offer desktop or mobile clients we have not indexed.","source":"https://cloud.google.com/dotnet/docs/reference/Google.Cloud.Channel.V1/1.7.0/Google.Cloud.Channel.V1.ListChannelPartnerRepricingConfigsResponse","question":"What platforms does Google BigQuery support?","confidence":0.6},{"answer":"We have only confirmed a cloud / SaaS deployment for Google BigQuery, so it appears to be vendor-hosted. If a self-hosted option exists we have not found it documented publicly.","source":"https://cloud.google.com/bigquery","question":"Can Google BigQuery be self-hosted?","confidence":0.6},{"answer":"We have confirmed 5 integrations for Google BigQuery, including Gemini Enterprise Agent Platform, Data Engineering Agent, Data Science Agent, Conversational Analytics Agent and Dataflow. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://cloud.google.com/bigquery","question":"What does Google BigQuery integrate with?","confidence":0.6}]` |
| deployment.options | `{"self_hosted":true}` | `{"cloud":true}` |
| description.long | A storage framework enabling lakehouse architectures—unified platforms combining data warehouse and data lake capabilities—that works with multiple query engines and can be deployed on any cloud, on-premises, or locally. | A cloud-based data platform that automates the complete data lifecycle from ingestion through AI analysis, enabling organizations to analyze data and derive AI-driven insights at scale. |
| features.capabilities | `{"deployment":"self","architecture":"separated","data_sharing":true,"license_class":"permissive","table_formats":"Delta, Iceberg, Hudi","semi_structured":"first_class","federation_query":true,"streaming_ingest":true}` | `{"in_db_ml":true,"deployment":"managed","sql_dialect":"vendor","architecture":"serverless","data_sharing":true,"compute_model":"serverless","license_class":"proprietary","semi_structured":"first_class","federation_query":true,"streaming_ingest":true}` |
| integrations.count | 15 | 2 |
| integrations.list | `[{"name":"Apache Spark"},{"name":"Apache Flink"},{"name":"Apache Hive"},{"name":"Apache Pulsar"},{"name":"Apache Druid"},{"name":"ClickHouse"},{"name":"Trino"},{"name":"PrestoDB"},{"name":"StarRocks"},{"name":"RisingWave"},{"name":"Dagster"},{"name":"Hopsworks"},{"name":"MLflow"},{"name":"Kafka"},{"name":"AWS Athena"},{"name":"AWS EMR"},{"name":"AWS Glue"},{"name":"Azure Stream Analytics"},{"name":"Google BigQuery"},{"name":"Snowflake"},{"name":"Databricks"},{"name":"AWS Redshift"},{"name":"Microsoft Fabric"},{"name":"Power BI"},{"name":"Starburst"},{"name":"Oracle"},{"name":"Excel"},{"name":"FINOS Legend"},{"name":"Kotosiro"},{"name":"Apache Kafka","native":true},{"name":"Amazon Athena"},{"name":"Amazon Redshift"},{"name":"Azure Fabric"},{"name":"Apache Iceberg"},{"name":"Apache Hudi"}]` | `[{"name":"Gemini Enterprise Agent Platform"},{"name":"Data Engineering Agent"},{"name":"Data Science Agent"},{"name":"Conversational Analytics Agent"},{"name":"Gemini","native":true},{"name":"Dataflow","native":true}]` |
| language.primary | Scala | - |
| license.spdx | Apache-2.0 | - |
| market.availability | `{"primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | `{"primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` |
| platform.support | - | `{"web":true}` |
| pricing | `{"type":"open_source","freeTier":true,"sourceUrl":"https://delta.io","retrievedAt":"2026-09-10T16:04:07.641Z"}` | `{"type":"usage","plans":[{"free":true,"name":"Free tier","summary":"10 GiB storage + 1 TiB queries/month","description":"Monthly free allocation","contactSales":false,"includedLimits":{"queries":"1 TiB/month","storage":"10 GiB"}}],"summary":"Free tier with 10 GiB storage and 1 TiB monthly queries. New customers receive $300 in free credits.","currency":"USD","freeTier":true,"sourceUrl":"https://cloud.google.com/dotnet/docs/reference/Google.Cloud.Channel.V1/1.7.0/Google.Cloud.Channel.V1.ListChannelPartnerRepricingConfigsResponse","retrievedAt":"2026-08-14T15:28:19.613Z"}` |
| pricing.free_tier | yes | yes |
| pricing.model | open_source | commercial |
| pricing.price_level | free | unknown |
| pricing.transparent | - | no |
| release.cadence_days | 50 | - |
| release.history | `[{"url":"https://github.com/delta-io/delta/releases/tag/v4.4.1","date":"2026-10-05T23:25:36Z","type":"stable","version":"v4.4.1"},{"url":"https://github.com/delta-io/delta/releases/tag/v4.4.0","date":"2026-08-20T16:52:49Z","type":"stable","version":"v4.4.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v3.3.3","date":"2026-08-12T21:01:45Z","type":"stable","version":"v3.3.3"},{"url":"https://github.com/delta-io/delta/releases/tag/v4.3.1","date":"2026-07-08T04:59:39Z","type":"stable","version":"v4.3.1"},{"url":"https://github.com/delta-io/delta/releases/tag/v4.3.0","date":"2026-06-18T04:26:28Z","type":"stable","version":"v4.3.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v4.2.0","date":"2026-04-16T05:00:05Z","type":"stable","version":"v4.2.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v4.1.0","date":"2026-02-26T02:42:06Z","type":"stable","version":"v4.1.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v4.0.1","date":"2026-01-16T00:40:03Z","type":"stable","version":"v4.0.1"},{"url":"https://github.com/delta-io/delta/releases/tag/v4.0.0","date":"2025-06-09T16:22:13Z","type":"stable","version":"v4.0.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v3.3.2","date":"2025-05-31T00:20:00Z","type":"stable","version":"v3.3.2"},{"url":"https://github.com/delta-io/delta/releases/tag/v3.3.1","date":"2025-05-05T03:21:16Z","type":"stable","version":"v3.3.1"},{"url":"https://github.com/delta-io/delta/releases/tag/v3.3.0","date":"2025-01-06T22:04:57Z","type":"stable","version":"v3.3.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v3.2.1","date":"2024-09-26T21:00:46Z","type":"stable","version":"v3.2.1"},{"url":"https://github.com/delta-io/delta/releases/tag/v4.0.0rc1","date":"2024-06-13T16:28:01Z","type":"prerelease","version":"v4.0.0rc1"},{"url":"https://github.com/delta-io/delta/releases/tag/v3.2.0","date":"2024-05-09T19:55:28Z","type":"stable","version":"v3.2.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v3.1.0","date":"2024-01-30T22:13:52Z","type":"stable","version":"v3.1.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v3.0.0","date":"2023-10-17T23:04:31Z","type":"stable","version":"v3.0.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v2.4.0","date":"2023-05-25T22:10:14Z","type":"stable","version":"v2.4.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v2.3.0","date":"2023-04-05T18:42:33Z","type":"stable","version":"v2.3.0"},{"url":"https://github.com/delta-io/delta/releases/tag/v2.0.2","date":"2023-01-13T22:44:44Z","type":"stable","version":"v2.0.2"}]` | - |
| reliability.sla_pct | - | 99.99 |
| reliability.status_page | - | yes |
| security.scorecard | 6.2 | - |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=maven&package_name=io.delta%3Adelta-standalone_2.12&per_page=100","last_12m":0,"max_severity":null}` | - |

## Capabilities (Data Warehouse Software)

| Capability | Delta Lake | Google BigQuery |
|---|:--:|:--:|
| **Deployment** |  |  |
| Deployment | Self-hosted | Managed cloud |
| **Architecture** |  |  |
| Architecture | Separated storage/compute | Serverless |
| Compute model | - | Serverless |
| **Query** |  |  |
| SQL dialect | - | Vendor-specific |
| Federation / lakehouse query-in-place | ✓ | ✓ |
| **Interoperability** |  |  |
| Table-format support | Delta, Iceberg, Hudi | - |
| **Scale** |  |  |
| Concurrency scaling | - | - |
| **Ingestion** |  |  |
| Streaming ingest | ✓ | ✓ |
| **Data model** |  |  |
| Semi-structured (JSON/VARIANT) | First-class | First-class |
| **Analytics** |  |  |
| ML / in-DB functions | - | ✓ |
| **Sharing** |  |  |
| Data sharing / marketplace | ✓ | ✓ |
| **Licensing** |  |  |
| Licence class | Permissive OSS | Proprietary |

*Source: vioscaleAI. Generated 2026-10-16T21:48:15.414Z. "-" = undocumented, not absent.*