What is Vertica used for?

Vertica is a columnar analytical database for data warehousing and in-database machine learning on large datasets. It is a good fit for analytics on very large datasets and data warehousing for reporting.

How much does Vertica cost?

Vertica doesn't publish fixed prices; pricing is quoted on request.

Is Vertica open source?

No. Vertica is proprietary (closed-source) software. Open-source alternatives to Vertica include ClickHouse, Databend and Apache Cloudberry.

Can I self-host Vertica?

Yes. Although Vertica is closed source, it can be self-hosted on your own servers.

What are some alternatives to Vertica?

Vertica competes with Teradata, Snowflake and Amazon Redshift. For open-source options, see Enlisted's ranked list of open-source Vertica alternatives.

Vertica: features, pricing and alternatives

About Vertica

Vertica is a commercial analytical database that stores data in columns, a design suited to scanning and aggregating very large datasets. It is used for data warehousing and analytics, and supports running machine learning inside the database instead of moving data out.

Organizations run Vertica as a SQL-based analytics engine that can be deployed in their own data centers or in the cloud. It is sold under commercial licensing, and details of editions, connectors and pricing are provided by the vendor.

Key features

Columnar storage for analytics
SQL data warehousing
In-database machine learning
Deployment on premises or in the cloud

Good fit for

→Analytics on very large datasets
→Data warehousing for reporting

Tags: analytics-database; columnar; data-warehouse; sql; machine-learning; enterprise

Vertica: questions and answers

What is Vertica used for?: Vertica is a columnar analytical database for data warehousing and in-database machine learning on large datasets. It is a good fit for analytics on very large datasets and data warehousing for reporting.
How much does Vertica cost?: Vertica doesn't publish fixed prices; pricing is quoted on request.
Is Vertica open source?: No. Vertica is proprietary (closed-source) software. Open-source alternatives to Vertica include ClickHouse, Databend and Apache Cloudberry.
Can I self-host Vertica?: Yes. Although Vertica is closed source, it can be self-hosted on your own servers.
What are some alternatives to Vertica?: Vertica competes with Teradata, Snowflake and Amazon Redshift. For open-source options, see Enlisted's ranked list of open-source Vertica alternatives.