# Top Free Columnar Databases

Check out our list of free Columnar Databases. Products featured on this list are the ones that offer a free trial version. As with most free versions, there are limitations, typically time or features.

If you'd like to see more products and to evaluate additional feature options, compare all [Columnar Databases](https://www.g2.com/categories/columnar-databases) to ensure you get the right product.

## View Free Columnar Databases

G2 takes pride in showing unbiased reviews on user satisfaction in our ratings and reports. We do not allow paid placements in any of our ratings, rankings, or reports. Learn about our [scoring methodologies](https://research.g2.com/g2-scoring-methodologies).

**13** Columnar Databases Products Available
View all [Columnar Databases](https://www.g2.com/categories/columnar-databases)

View all [Columnar Databases](https://www.g2.com/categories/columnar-databases)

[
### Google Cloud BigQuery
](https://www.g2.com/products/google-cloud-bigquery/reviews)

[By Google](https://www.g2.com/sellers/google)

[

(1,227)4.5 out of 5
](https://www.g2.com/products/google-cloud-bigquery/reviews#reviews "Read Google Cloud BigQuery Reviews")

Product Description

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

**Users:** Data Engineer, Data Analyst · **Industries:** Information Technology and Services, Computer Software · **Market Segment:** 38% Enterprise, 35% Mid-Market

Google Cloud BigQuery features and usability ratings that predict user satisfaction

9.0

Data Model

Average: 8.7

8.7

Data Types

Average: 8.5

8.6

Has the product been a good partner in doing business?

Average: 8.4

8.5

Integrated Cache

Average: 8.5

 ![Mateo K.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Mateo K.")
MK

I like that Google Cloud BigQuery is free if you're not operating on a big scale, which is great because we use it without paying for it. I'd also...[Read review](https://www.g2.com/products/google-cloud-bigquery/reviews/google-cloud-bigquery-review-12611959)

 ![Veera Shubhashree P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Veera Shubhashree P.")
VP

I use Google Cloud BigQuery for learning big data concepts and implementing chatbots. I like that all the services and products are in one place,...[Read review](https://www.g2.com/products/google-cloud-bigquery/reviews/google-cloud-bigquery-review-12612804)

Year Founded
1998

HQ Location
Mountain View, CA

Company Website
https://cloud.google.com/

Twitter
@google

LinkedIn® Page
https://www.linkedin.com/company/1441/

Ownership
NASDAQ:GOOG

Phone
+1 (650) 253-0000

[
### Amazon Redshift
](https://www.g2.com/products/amazon-redshift/reviews)

[By Amazon Web Services (AWS)](https://www.g2.com/sellers/amazon-web-services-aws-3e93cc28-2e9b-4961-b258-c6ce0feec7dd)

[

(402)4.3 out of 5
](https://www.g2.com/products/amazon-redshift/reviews#reviews "Read Amazon Redshift Reviews")

Product Description

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

**Users:** Data Engineer, Senior Data Engineer · **Industries:** Information Technology and Services, Computer Software · **Market Segment:** 40% Enterprise, 39% Mid-Market

Amazon Redshift features and usability ratings that predict user satisfaction

8.4

Data Model

Average: 8.7

8.4

Data Types

Average: 8.5

8.7

Has the product been a good partner in doing business?

Average: 8.4

8.2

Integrated Cache

Average: 8.5

 ![Kathy L.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Kathy L.")
KL

Amazon Redshift provides excellent scalability for handling large volumes of structured data and integrates smoothly with other AWS services like...[Read review](https://www.g2.com/products/amazon-redshift/reviews/amazon-redshift-review-11605390)

 ![Antarix K.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Antarix K.")
AK

Easy to scale up and down, Multi zone architecture for data safeguarding. Easy to scale schedule. Easy logs access. Easy to setup and simple to...[Read review](https://www.g2.com/products/amazon-redshift/reviews/amazon-redshift-review-11796946)

Year Founded
2006

HQ Location
Seattle, WA

Company Website
https://aws.amazon.com/?nc2=h\_lg

Twitter
@awscloud

LinkedIn® Page
https://www.linkedin.com/company/amazon-web-services/

Ownership
NASDAQ: AMZN

[![G2 Advertising](/assets/my-g2-logo-41632af6f81a240a0a9886638f412b2ac9a29f4001534f8c83be89a58ef9d45d.svg "G2 Advertising")](https://sell.g2.com/case-studies/how-aisdr-uses-g2-ads-to-turn-g2-into-top-5-traffic-source)

Sponsored

G2 Advertising

Get 2x conversion than Google Ads with G2 Advertising!

G2 Advertising places your product in premium positions on high-traffic pages and on targeted competitor pages to reach buyers at key comparison moments.

[
Learn More
](https://sell.g2.com/case-studies/how-aisdr-uses-g2-ads-to-turn-g2-into-top-5-traffic-source)

[
### Snowflake
](https://www.g2.com/products/snowflake/reviews)

[By Snowflake, Inc.](https://www.g2.com/sellers/snowflake-inc)

[

(754)4.5 out of 5
](https://www.g2.com/products/snowflake/reviews#reviews "Read Snowflake Reviews")

Product Description

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 applic

**Users:** Data Engineer, Data Analyst · **Industries:** Information Technology and Services, Computer Software · **Market Segment:** 45% Mid-Market, 42% Enterprise

Snowflake features and usability ratings that predict user satisfaction

9.2

Data Model

Average: 8.7

9.2

Data Types

Average: 8.5

9.0

Has the product been a good partner in doing business?

Average: 8.4

9.2

Integrated Cache

Average: 8.5

 ![Verified User in Health, Wellness and Fitness](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Health, Wellness and Fitness")
CH

Its flexibility to grow from a very small free POC to a global multiregion data system with AI, both technologically and in price. This is...[Read review](https://www.g2.com/products/snowflake/reviews/snowflake-review-12840793)

 ![Conner R.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Conner R.")
CR

Super reliable, with a much more robust integration guide that makes setup and implementation clearer.[Read review](https://www.g2.com/products/snowflake/reviews/snowflake-review-12849271)

Year Founded
2012

HQ Location
San Mateo, CA

Company Website
https://www.snowflake.com

Twitter
@SnowflakeDB

LinkedIn® Page
https://www.linkedin.com/company/snowflake-computing/

Ownership
NYSE:SNOW

[
### Hbase
](https://www.g2.com/products/hbase/reviews)

[By The Apache Software Foundation](https://www.g2.com/sellers/the-apache-software-foundation)

[

(114)4.2 out of 5
](https://www.g2.com/products/hbase/reviews#reviews "Read Hbase Reviews")

Product Description

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.

**Users:** Software Engineer, Big Data Engineer · **Industries:** Computer Software, Information Technology and Services · **Market Segment:** 52% Enterprise, 27% Mid-Market

Hbase features and usability ratings that predict user satisfaction

8.1

Data Model

Average: 8.7

7.2

Data Types

Average: 8.5

8.0

Has the product been a good partner in doing business?

Average: 8.4

7.0

Integrated Cache

Average: 8.5

 ![Gaurav N.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Gaurav N.")
GN

1. Free and open source 2. Comes as part of all Hadoop distribution 3. Good for fast inserts and scan use cases [Read review](https://www.g2.com/products/hbase/reviews/hbase-review-46559)

 ![Verified User in Newspapers](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Newspapers")
UN

With HBase, you get what you asked for. HBase is great because it's an open-source, well-known Apache project. As a result, the community and...[Read review](https://www.g2.com/products/hbase/reviews/hbase-review-179964)

Year Founded
1999

HQ Location
Wakefield, MA

Company Website
https://knox.apache.org/index.html

Twitter
@TheASF

LinkedIn® Page
https://www.linkedin.com/company/215982/

[
### OpenText Vertica
](https://www.g2.com/products/opentext-vertica/reviews)

[By OpenText](https://www.g2.com/sellers/opentext)

[

(216)4.3 out of 5
](https://www.g2.com/products/opentext-vertica/reviews#reviews "Read OpenText Vertica Reviews")

Product Description

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-i

**Users:** Senior Software Engineer, Data Engineer · **Industries:** Computer Software, Information Technology and Services · **Market Segment:** 44% Enterprise, 39% Mid-Market

OpenText Vertica features and usability ratings that predict user satisfaction

8.4

Data Model

Average: 8.7

8.0

Data Types

Average: 8.5

8.3

Has the product been a good partner in doing business?

Average: 8.4

8.5

Integrated Cache

Average: 8.5

 ![Suru S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Suru S.")
SS

Can perform any type of analytics, in our use-case we use Time Series, Pattern Matching by ingesting data gathering from different data sources...[Read review](https://www.g2.com/products/opentext-vertica/reviews/opentext-vertica-review-7679475)

 ![Kuldeep S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Kuldeep S.")
KS

OpenText Veryica excels in understanding context, generating coherent responses, and aiding various natural language processing tasks. Its...[Read review](https://www.g2.com/products/opentext-vertica/reviews/opentext-vertica-review-8881830)

Year Founded
1991

HQ Location
Waterloo, ON

Company Website
https://www.opentext.com/

Twitter
@OpenText

LinkedIn® Page
https://www.linkedin.com/company/2709/

Ownership
NASDAQ:OTEX

Phone
 +1-519-888-7111

[
### KX
](https://www.g2.com/products/kx-kx/reviews)

[By KX](https://www.g2.com/sellers/kx-a145756d-91d3-463e-a51d-9e13b1ac577c)

[

(51)4.6 out of 5
](https://www.g2.com/products/kx-kx/reviews#reviews "Read KX Reviews")

Product Description

We power the time-aware data-driven decisions that enable fast-moving organizations to realize the full potential of their AI investments and outpace competitors. Our technology delivers transforma

**Industries:** Financial Services, Banking · **Market Segment:** 57% Enterprise, 25% Small-Business

KX features and usability ratings that predict user satisfaction

8.8

Data Model

Average: 8.7

9.5

Data Types

Average: 8.5

9.0

Has the product been a good partner in doing business?

Average: 8.4

9.1

Integrated Cache

Average: 8.5

KL

Its speed, and the expressiveness of the language, q. The speed of development in the team is difficult to replicate in other languages. Its also a...[Read review](https://www.g2.com/products/kx-kx/reviews/kx-review-7687751)

NP

Insane performance and elegant minimalist syntax. Ajing billions of rows in a few seconds is perfect for time series data analysis.[Read review](https://www.g2.com/products/kx-kx/reviews/kx-review-8371517)

Year Founded
1996

HQ Location
NY, USA

Company Website
https://kx.com/

Twitter
@kxsystems

LinkedIn® Page
https://www.linkedin.com/company/kx-systems

[
### Druid
](https://www.g2.com/products/druid/reviews)

[By Druid](https://www.g2.com/sellers/druid)

[

(31)4.3 out of 5
](https://www.g2.com/products/druid/reviews#reviews "Read Druid Reviews")

Product Description

Apache Druid is an open source real-time analytics database. Druid combines ideas from OLAP/analytic databases, timeseries databases, and search systems to create a complete real-time analytics soluti

**Industries:** Computer Software · **Market Segment:** 52% Enterprise, 29% Mid-Market

Druid features and usability ratings that predict user satisfaction

8.8

Data Model

Average: 8.7

7.8

Data Types

Average: 8.5

7.7

Has the product been a good partner in doing business?

Average: 8.4

8.9

Integrated Cache

Average: 8.5

 ![Ashish M.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Ashish M.")
AM

1) Pre-rolled up data into dimension and metrics 2) Lighting fast data/ query result retrieval[Read review](https://www.g2.com/products/druid/reviews/druid-review-4501273)

Year Founded
1998

HQ Location
Rio de Janeiro, Rio de Janeiro

Company Website
https://druid.com.br

Twitter
@druid

LinkedIn® Page
https://www.linkedin.com/company/druid\_2/

[
### MariaDB
](https://www.g2.com/products/mariadb/reviews)

[By MariaDB](https://www.g2.com/sellers/mariadb)

[

(226)4.4 out of 5
](https://www.g2.com/products/mariadb/reviews#reviews "Read MariaDB Reviews")

Product Description

MariaDB frees companies from the costs, constraints and complexity of proprietary databases, enabling them to reinvest in what matters most – rapidly developing innovative, customer-facing application

**Users:** Software Engineer, Senior Software Engineer · **Industries:** Information Technology and Services, Computer Software · **Market Segment:** 43% Small-Business, 33% Mid-Market

MariaDB features and usability ratings that predict user satisfaction

8.8

Data Model

Average: 8.7

8.9

Data Types

Average: 8.5

8.1

Has the product been a good partner in doing business?

Average: 8.4

9.0

Integrated Cache

Average: 8.5

NI

MariaDB is a powerful database server with open source features that is improved every day by MySQL developers. It has many features and its speed...[Read review](https://www.g2.com/products/mariadb/reviews/mariadb-review-7966567)

 ![Suraj S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Suraj S.")
SS

The best thing I like about MariaDB is that it is super-compatible with MySQL, by which new users won't find it difficult to shift and start the...[Read review](https://www.g2.com/products/mariadb/reviews/mariadb-review-8434445)

Year Founded
2014

HQ Location
Espoo, Finland

Company Website
https://mariadb.com

Twitter
@mariadb

LinkedIn® Page
https://www.linkedin.com/company/1214250/

Ownership
NYSE: MRDB

[
### CrateDB
](https://www.g2.com/products/cratedb/reviews)

[By CrateDB](https://www.g2.com/sellers/cratedb)

[

(85)4.4 out of 5
](https://www.g2.com/products/cratedb/reviews#reviews "Read CrateDB Reviews")

Product Description

The real-time database for analytics, search, and AI. Store any type of data and combine the simplicity of SQL with the scalability of NoSQL. CrateDB is an open source, multi-model, distributed and co

**Users:** Software Engineer, Data Engineer · **Industries:** Computer Software, Information Technology and Services · **Market Segment:** 54% Small-Business, 31% Mid-Market

CrateDB features and usability ratings that predict user satisfaction

9.0

Data Model

Average: 8.7

9.2

Data Types

Average: 8.5

9.3

Has the product been a good partner in doing business?

Average: 8.4

10.0

Integrated Cache

Average: 8.5

 ![Limuel O.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Limuel O.")
LO

This is one of my favorite software because of its ease of use very ease to create a database, It can handle a massive amount of data, and it...[Read review](https://www.g2.com/products/cratedb/reviews/cratedb-review-5097783)

 ![Aidan A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Aidan A.")
AA

I value the pricing over competitors like CockroachDB, and MongoDB Atlas for similar amounts of data stored and retrieved.[Read review](https://www.g2.com/products/cratedb/reviews/cratedb-review-7225697)

Year Founded
2013

HQ Location
Redwood City, CA

Company Website
https://cratedb.com/

Twitter
@cratedb

LinkedIn® Page
https://www.linkedin.com/company/crateio/

[
### StarTree
](https://www.g2.com/products/startree/reviews)

[By StarTree](https://www.g2.com/sellers/startree)

[

(29)4.5 out of 5
](https://www.g2.com/products/startree/reviews#reviews "Read StarTree Reviews")

Product Description

StarTree Cloud is a fully-managed user-facing real-time analytics Database-as-a-Service (DBaaS) designed for OLAP at massive speed and scale. Based on Apache Pinot™, StarTree Cloud provides enterprise

**Industries:** Computer Software, Financial Services · **Market Segment:** 38% Small-Business, 31% Enterprise

StarTree features and usability ratings that predict user satisfaction

8.3

Data Model

Average: 8.7

8.1

Data Types

Average: 8.5

8.8

Has the product been a good partner in doing business?

Average: 8.4

8.7

Integrated Cache

Average: 8.5

 ![Nishu G.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Nishu G.")
NG

Fully managed Database as a service and also self service provision[Read review](https://www.g2.com/products/startree/reviews/startree-review-8377579)

 ![Verified User in Computer & Network Security](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Computer & Network Security")
EC

"Bring Your Own Cloud" is great - they manage but we control. It worked just as described. They're very responsive for onboarding/support issues...[Read review](https://www.g2.com/products/startree/reviews/startree-review-8379851)

Year Founded
2019

HQ Location
Mountain View, California

Company Website
https://www.startree.ai/

Twitter
@startreedata

LinkedIn® Page
https://www.linkedin.com/company/startreedata/

[
### Tembo
](https://www.g2.com/products/tembo/reviews)

[By Tembo](https://www.g2.com/sellers/tembo)

[

(26)4.7 out of 5
](https://www.g2.com/products/tembo/reviews#reviews "Read Tembo Reviews")

Product Description

Tembo is a multi-workload Postgres managed service that enables organizations to harness the full power of Postgres for transactional, analytical, and AI workloads. With robust SaaS and self hosted de

**Industries:** Computer Software · **Market Segment:** 85% Small-Business, 15% Mid-Market

Tembo features and usability ratings that predict user satisfaction

8.9

Data Model

Average: 8.7

9.4

Data Types

Average: 8.5

10.0

Has the product been a good partner in doing business?

Average: 8.4

8.9

Integrated Cache

Average: 8.5

 ![Verified User in Computer Software](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Computer Software")
UC

It resolves our specific needs such as the cloud and stack related deployments[Read review](https://www.g2.com/products/tembo/reviews/tembo-review-10758657)

SN

The best thing I like about Tembo is that they have extensive postgres extension library[Read review](https://www.g2.com/products/tembo/reviews/tembo-review-10760117)

Year Founded
2022

HQ Location
Cincinnati, US

Company Website
https://tembo.io/

Twitter
@tembo\_io

LinkedIn® Page
https://www.linkedin.com/company/tembo-inc/

[
### Tinybird
](https://www.g2.com/products/tinybird/reviews)

[By Tinybird](https://www.g2.com/sellers/tinybird)

[

(14)4.1 out of 5
](https://www.g2.com/products/tinybird/reviews#reviews "Read Tinybird Reviews")

Product Description

Tinybird is a fully managed ClickHouse® service designed for software developers and AI-native product teams by enabling them to create large-scale real-time analytics projects with minimal effort. Ti

**Industries:** Computer Software · **Market Segment:** 50% Mid-Market, 36% Small-Business

Tinybird features and usability ratings that predict user satisfaction

0.0

No information available

0.0

No information available

10.0

Has the product been a good partner in doing business?

Average: 8.4

0.0

No information available

 ![Pankaj Rao G.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pankaj Rao G.")
PG

Tinybird simplifies development, excelling in real-time analytics with unmatched speed and cost effectiveness. Easy data ingestion, quick querying,...[Read review](https://www.g2.com/products/tinybird/reviews/tinybird-review-9116980)

Year Founded
2019

HQ Location
New York, US

Company Website
https://tinybird.co

LinkedIn® Page
https://www.linkedin.com/company/35704741

[
### Tiger Data
](https://www.g2.com/products/tiger-data/reviews)

[By Tiger Data (creators of TimescaleDB)](https://www.g2.com/sellers/tiger-data-creators-of-timescaledb)

[

(33)4.6 out of 5
](https://www.g2.com/products/tiger-data/reviews#reviews "Read Tiger Data Reviews")

Product Description

Tiger Data, from the creators of TimescaleDB, is the #1 Postgres time-series database for developers, devices and agents. Keep sensor, on-chain, and customer data fresh while retaining years of histor

**Industries:** Computer Software, Financial Services · **Market Segment:** 79% Small-Business, 18% Mid-Market

Tiger Data features and usability ratings that predict user satisfaction

7.2

Data Model

Average: 8.7

7.8

Data Types

Average: 8.5

9.3

Has the product been a good partner in doing business?

Average: 8.4

7.8

Integrated Cache

Average: 8.5

KF

We loved the ease of installation and the familiarity of Timescale with PostgreSQL. It was easy to get started, and it has been easy to maintain...[Read review](https://www.g2.com/products/tiger-data/reviews/tiger-data-review-7756652)

 ![Kenny C.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Kenny C.")
KC

Timescale has predictable cost anchored in familiar reality; it is driven by storage volume and system load. You don't have that familiar, awful...[Read review](https://www.g2.com/products/tiger-data/reviews/tiger-data-review-7773719)

Year Founded
2015

HQ Location
New York, New York

Company Website
https://www.tigerdata.com/

Twitter
@TigerDatabase

LinkedIn® Page
https://www.linkedin.com/company/timescaledb/