# Best Columnar Databases for Medium-Sized Businesses *By [Shalaka Joshi](https://research.g2.com/insights/author/shalaka-joshi)* Products classified in the overall Columnar Databases category are similar in many regards and help companies of all sizes solve their business problems. However, medium-sized business features, pricing, setup, and installation differ from businesses of other sizes, which is why we match buyers to the right Medium-Sized Business Columnar Databases to fit their needs. Compare product ratings based on reviews from enterprise users or connect with one of G2's buying advisors to find the right solutions within the Medium-Sized Business Columnar Databases category. In addition to qualifying for inclusion in the Columnar Databases category, to qualify for inclusion in the Medium-Sized Business Columnar Databases category, a product must have at least 10 reviews left by a reviewer from a medium-sized business. ## Category Overview **Total Products under this Category:** 27 ## Trust & Credibility Stats **Why You Can Trust G2's Software Rankings:** - 30 Analysts and Data Experts - 3,300+ Authentic Reviews - 27+ Products - Unbiased Rankings G2's software rankings are built on verified user reviews, rigorous moderation, and a consistent research methodology maintained by a team of analysts and data experts. Each product is measured using the same transparent criteria, with no paid placement or vendor influence. While reviews reflect real user experiences, which can be subjective, they offer valuable insight into how software performs in the hands of professionals. Together, these inputs power the G2 Score, a standardized way to compare tools within every category. --- **Sponsored** ### QuestDB QuestDB is an open-source, SQL-first time-series database built for the most demanding workloads—from trading floors to mission control. A multi-tier design keeps hot data in native partitions and cold history in Parquet/object storage, queried via one SQL layer. Vectorized, columnar execution delivers high-throughput ingest and millisecond queries. Open formats (Parquet/Arrow) make it AI-ready and lock-in free. Deploy self-hosted or in your cloud (BYOC). [Visit company website](https://www.g2.com/external_clickthroughs/record?secure%5Bad_program%5D=ppc&secure%5Bad_slot%5D=category_product_list&secure%5Bcategory_id%5D=2546&secure%5Bdisplayable_resource_id%5D=1761&secure%5Bdisplayable_resource_type%5D=Category&secure%5Bmedium%5D=sponsored&secure%5Bplacement_reason%5D=neighbor_category&secure%5Bplacement_resource_ids%5D%5B%5D=1761&secure%5Bprioritized%5D=false&secure%5Bproduct_id%5D=131714&secure%5Bresource_id%5D=2546&secure%5Bresource_type%5D=Category&secure%5Bsource_type%5D=category_page&secure%5Bsource_url%5D=https%3A%2F%2Fwww.g2.com%2Fcategories%2Fcolumnar-databases%2Fmid-market&secure%5Btoken%5D=795392ab35642936e0c98a3573060f5a4abff2d7bcc511eccbab1fc35865963f&secure%5Burl%5D=https%3A%2F%2Fquestdb.com&secure%5Burl_type%5D=company_website) --- ## Top-Rated Products (Ranked by G2 Score) ### 1. [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) BigQuery is a fully managed, AI-ready data analytics platform that helps you maximize value from your data and is designed to be multi-engine, multi-format, and multi-cloud. Store 10 GiB of data and run up to 1 TiB of queries for free per month. **Average Rating:** 4.5/5.0 **Total Reviews:** 1,157 **User Satisfaction Scores:** - **Data Model:** 9.1/10 (Category avg: 8.7/10) - **Data Types:** 8.7/10 (Category avg: 8.5/10) - **Has the product been a good partner in doing business?:** 8.6/10 (Category avg: 8.4/10) - **Integrated Cache:** 8.5/10 (Category avg: 8.5/10) **Seller Details:** - **Seller:** [Google](https://www.g2.com/sellers/google) - **Year Founded:** 1998 - **HQ Location:** Mountain View, CA - **Twitter:** @google (31,885,216 Twitter followers) - **LinkedIn® Page:** https://www.linkedin.com/company/1441/ (336,169 employees on LinkedIn®) - **Ownership:** NASDAQ:GOOG **Reviewer Demographics:** - **Who Uses This:** Data Engineer, Data Analyst - **Top Industries:** Information Technology and Services, Computer Software - **Company Size:** 37% Enterprise, 35% Mid-Market #### Pros & Cons **Pros:** - Ease of Use (156 reviews) - Speed (143 reviews) - Fast Querying (120 reviews) - Integrations (118 reviews) - Query Efficiency (114 reviews) **Cons:** - Expensive (127 reviews) - Query Issues (78 reviews) - Cost Issues (63 reviews) - Cost Management (60 reviews) - Learning Curve (54 reviews) ### 2. [Snowflake](https://www.g2.com/products/snowflake/reviews) Snowflake makes enterprise AI easy, efficient and trusted. Thousands of companies around the globe, including hundreds of the world’s largest, use Snowflake’s AI Data Cloud to share data, build applications, and power their business with AI. The era of enterprise AI is here. Learn more at snowflake.com (NYSE: SNOW). **Average Rating:** 4.6/5.0 **Total Reviews:** 666 **User Satisfaction Scores:** - **Data Model:** 9.2/10 (Category avg: 8.7/10) - **Data Types:** 9.2/10 (Category avg: 8.5/10) - **Has the product been a good partner in doing business?:** 9.0/10 (Category avg: 8.4/10) - **Integrated Cache:** 9.2/10 (Category avg: 8.5/10) **Seller Details:** - **Seller:** [Snowflake, Inc.](https://www.g2.com/sellers/snowflake-inc) - **Company Website:** https://www.snowflake.com - **Year Founded:** 2012 - **HQ Location:** San Mateo, CA - **Twitter:** @SnowflakeDB (240 Twitter followers) - **LinkedIn® Page:** https://www.linkedin.com/company/snowflake-computing/ (10,857 employees on LinkedIn®) **Reviewer Demographics:** - **Who Uses This:** Data Engineer, Data Analyst - **Top Industries:** Information Technology and Services, Computer Software - **Company Size:** 44% Mid-Market, 43% Enterprise #### Pros & Cons **Pros:** - Ease of Use (89 reviews) - Scalability (68 reviews) - Data Management (67 reviews) - Features (66 reviews) - Integrations (61 reviews) **Cons:** - Expensive (53 reviews) - Cost (36 reviews) - Cost Management (32 reviews) - Learning Curve (25 reviews) - Feature Limitations (21 reviews) ### 3. [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) Tens of thousands of customers use Amazon Redshift, a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. It is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions. **Average Rating:** 4.3/5.0 **Total Reviews:** 367 **User Satisfaction Scores:** - **Data Model:** 8.4/10 (Category avg: 8.7/10) - **Data Types:** 8.4/10 (Category avg: 8.5/10) - **Has the product been a good partner in doing business?:** 8.7/10 (Category avg: 8.4/10) - **Integrated Cache:** 8.2/10 (Category avg: 8.5/10) **Seller Details:** - **Seller:** [Amazon Web Services (AWS)](https://www.g2.com/sellers/amazon-web-services-aws-3e93cc28-2e9b-4961-b258-c6ce0feec7dd) - **Year Founded:** 2006 - **HQ Location:** Seattle, WA - **Twitter:** @awscloud (2,223,984 Twitter followers) - **LinkedIn® Page:** https://www.linkedin.com/company/amazon-web-services/ (156,424 employees on LinkedIn®) - **Ownership:** NASDAQ: AMZN **Reviewer Demographics:** - **Who Uses This:** Data Engineer, Senior Data Engineer - **Top Industries:** Information Technology and Services, Computer Software - **Company Size:** 40% Enterprise, 39% Mid-Market #### Pros & Cons **Pros:** - Ease of Use (7 reviews) - Integrations (7 reviews) - Easy Integrations (5 reviews) - Fast Querying (5 reviews) - Scalability (5 reviews) **Cons:** - Complexity (5 reviews) - Feature Limitations (5 reviews) - Software Limitations (5 reviews) - Query Issues (4 reviews) - Query Optimization (4 reviews) ### 4. [OpenText Vertica](https://www.g2.com/products/opentext-vertica/reviews) Vertica is the unified analytics platform, based on a massively scalable architecture with a broad set of analytical functions spanning event and time series, pattern matching, geospatial, and built-in machine learning capability. Vertica enables data analytics teams to easily apply these powerful functions to large and demanding analytical workloads, arming them and their customers with predictive business insights. Vertica provides a unified analytics platform across major public clouds and on-premises data centers, and integrates data in cloud object storage and HDFS without forcing any data movement. Available as a SaaS option, or as a customer-managed platform, Vertica helps teams combine growing data siloes for a more complete view of available data. Vertica features separation of compute and storage, so teams can spin up storage and compute resources as needed, then spin down afterwards to reduce costs. **Average Rating:** 4.3/5.0 **Total Reviews:** 195 **User Satisfaction Scores:** - **Data Model:** 8.4/10 (Category avg: 8.7/10) - **Data Types:** 8.0/10 (Category avg: 8.5/10) - **Has the product been a good partner in doing business?:** 8.3/10 (Category avg: 8.4/10) - **Integrated Cache:** 8.5/10 (Category avg: 8.5/10) **Seller Details:** - **Seller:** [OpenText](https://www.g2.com/sellers/opentext) - **Year Founded:** 1991 - **HQ Location:** Waterloo, ON - **Twitter:** @OpenText (21,588 Twitter followers) - **LinkedIn® Page:** https://www.linkedin.com/company/2709/ (23,339 employees on LinkedIn®) - **Ownership:** NASDAQ:OTEX **Reviewer Demographics:** - **Who Uses This:** Senior Software Engineer, Data Engineer - **Top Industries:** Computer Software, Information Technology and Services - **Company Size:** 44% Enterprise, 39% Mid-Market ### 5. [Apache Parquet](https://www.g2.com/products/apache-parquet/reviews) Apache Parquet is a columnar storage format available to any project in the Hadoop ecosystem, regardless of the choice of data processing framework, data model or programming language. **Average Rating:** 4.3/5.0 **Total Reviews:** 26 **User Satisfaction Scores:** - **Data Model:** 9.0/10 (Category avg: 8.7/10) - **Data Types:** 8.8/10 (Category avg: 8.5/10) - **Has the product been a good partner in doing business?:** 7.5/10 (Category avg: 8.4/10) - **Integrated Cache:** 8.6/10 (Category avg: 8.5/10) **Seller Details:** - **Seller:** [The Apache Software Foundation](https://www.g2.com/sellers/the-apache-software-foundation) - **Year Founded:** 1999 - **HQ Location:** Wakefield, MA - **Twitter:** @TheASF (66,116 Twitter followers) - **LinkedIn® Page:** https://www.linkedin.com/company/215982/ (2,408 employees on LinkedIn®) **Reviewer Demographics:** - **Top Industries:** Computer Software, Information Technology and Services - **Company Size:** 48% Mid-Market, 30% Small-Business ### 6. [Hbase](https://www.g2.com/products/hbase/reviews) A scalable, distributed database that supports structured data storage for large tables. Use HBase when you need random, realtime read/write access to Big Data. **Average Rating:** 4.2/5.0 **Total Reviews:** 103 **User Satisfaction Scores:** - **Data Model:** 8.1/10 (Category avg: 8.7/10) - **Data Types:** 7.2/10 (Category avg: 8.5/10) - **Has the product been a good partner in doing business?:** 8.0/10 (Category avg: 8.4/10) - **Integrated Cache:** 7.0/10 (Category avg: 8.5/10) **Seller Details:** - **Seller:** [The Apache Software Foundation](https://www.g2.com/sellers/the-apache-software-foundation) - **Year Founded:** 1999 - **HQ Location:** Wakefield, MA - **Twitter:** @TheASF (66,116 Twitter followers) - **LinkedIn® Page:** https://www.linkedin.com/company/215982/ (2,408 employees on LinkedIn®) **Reviewer Demographics:** - **Who Uses This:** Software Engineer, Big Data Engineer - **Top Industries:** Information Technology and Services, Computer Software - **Company Size:** 52% Enterprise, 27% Mid-Market ## Parent Category [IT Management Software](https://www.g2.com/categories/it-management) ## Related Categories - [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) - [Time Series Databases](https://www.g2.com/categories/time-series-databases) - [Real-time Analytic Database Software](https://www.g2.com/categories/real-time-analytic-database)