DBMS > Google BigQuery vs. Snowflake vs. TiDB
System Properties Comparison Google BigQuery vs. Snowflake vs. TiDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Google BigQuery Xexclude from comparison||Snowflake Xexclude from comparison||TiDB Xexclude from comparison|
|Description||Large scale data warehouse service with append-only tables||Cloud-based data warehousing service for structured and semi-structured data||TiDB is an open source distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability.|
|Primary database model||Relational DBMS||Relational DBMS||Relational DBMS|
|Secondary database models||Document store|
|Developer||Snowflake Computing Inc.||PingCAP, Inc.|
|Current release||7.0.0, March 2023|
|License Commercial or Open Source||commercial||commercial||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||yes||yes||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|TiDB Cloud: Fully-managed TiDB Service. Bring everything great about TiDB to the cloud.|
|Implementation language||Go, Rust|
|Server operating systems||hosted||hosted||Linux|
|Data scheme||yes||yes support of semi-structured data formats (JSON, XML, Avro)||yes|
|Typing predefined data types such as float or date||yes||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||yes||no|
|SQL Support of SQL||yes||yes||yes|
|APIs and other access methods||RESTful HTTP/JSON API||CLI Client|
|Supported programming languages||.Net|
|Triggers||no||no similar concept for controling cloud resources||no|
|Partitioning methods Methods for storing different data on different nodes||none||yes||horizontal partitioning (by key range)|
|Replication methods Methods for redundantly storing data on multiple nodes||yes||Using Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||yes with TiSpark Connector|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||yes||yes full support since version 6.6|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no Since BigQuery is designed for querying data||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no||no|
|User concepts Access control||Access privileges (owner, writer, reader) on dataset, table or view level Google Cloud Identity & Access Management (IAM)||Users with fine-grained authorization concept, user roles and pluggable authentication||Fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||TiDB is an open-source NewSQL database built by PingCAP. TiDB supports Hybrid Transactional...|
|Competitive advantages||In the current database landscape, infrastructure engineers often have to use one...|
|Typical application scenarios||TiDB is designed to support both OLTP and OLAP scenarios. You can use TiDB , the...|
|Key customers||Shopee (E-commerce) BookMyShow.com (E-commerce) Yiguo.com (E-commerce) JD Cloud &...|
|Market metrics||25K+ GitHub Stars for TiDB, and 8K+ GitHub Stars for TiKV 1.6K+ members in TiDB Community...|
|Licensing and pricing models||Open Source Apache 2.0 with either commercial licensing or fully-hosted DB-as-a-service...|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||CData: Connect to Big Data & NoSQL through standard Drivers.|
SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
|SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.|
CData: Connect to Big Data & NoSQL through standard Drivers.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years
Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years
The popularity of cloud-based DBMSs has increased tenfold in four years
Snowflake is the DBMS of the Year 2022, defending the title from last year Snowflake is the DBMS of the Year 2021
Snowflake is the DBMS of the Year 2021
|Recent citations in the news|
Comparing Redshift and BigQuery in various terms
Dev Tier with BigQuery
Great Google BigQuery Date Functions to Know - Software connecting all databases
Google BigQuery catalogs
4 Ways MongoDB Enhances Your Google BigQuery Experience
provided by Google News
Snowflake acquires Neeva to bring intelligent search to its cloud data management solution
Snowflake Bolsters Data Cloud Search Capabilities with Neeva ...
Snowflake acquires Neeva to add generative AI-based search to Data Cloud
Data Management News for the Week of May 26; Updates from ...
Despite poor guidance, Snowflake CEO says he is optimistic about the future
provided by Google News
PingCAP’s Innovative TiDB Database – Techstrong.TV
Pliops and phoenixNAP team up to turbocharge Redis – Blocks and ...
PingCAP Announces TiDB Cloud Serverless Tier, Delivering ...
PingCAP Innovates GitHub Insights with the GitHub Data Explorer Tool
Apache Druid, TiDB, ClickHouse, or Apache Doris? A Comparison ...
provided by Google News
Sales and Revenue Analyst
Senior BI Developer
Database Reliability Engineer
Systems Design Engineer
Staff Software Engineer, Ads Infra
Software Engineer - Cash Databases
Staff Software Engineer - Cash Cards
Database Engineer (Spanner Expertise)
Share this page