Vertica Blog

Vertica Blog

Advanced Analytics

Vertica by opentext logo, a plus sign, and dbt logo on a blue background

Unlock the Potential of Your Data in Vertica with dbt: Experience ETL-Free Data Transformation

Co-authored with Oussama Chakri. Discover the all-new open-source dbt-Vertica adapter, offering cutting-edge features that will transform your data analytics journey. By connecting to Vertica with vertica-python, this adapter elevates the Data Build Tool (dbt) experience, enabling you to extract valuable insights and make data-driven decisions faster than ever. With the dbt-Vertica adapter, you can eliminate...
Vertica by opentext logo along with the datahub logo on a blue background

Unlock the Potential of Data Discovery in Vertica with DataHub: Master Metadata and Accelerate Data Access

Co-authored with Oussama Chakri. Smoothen your data discovery and metadata management by integrating Vertica with DataHub using the new, certified DataHub-Vertica Plugin. This powerful combination will modernize your approach to metadata management, eliminating the need to search for the ideal dataset for your analysis. DataHub is a comprehensive metadata platform designed for data discovery, governance,...
Vertica by opentext, logo with a plus sigh and Prometheus and GrafanaLabs logo seperated by a pipe symbol with a white background.

Monitoring Metrics Using Vertica Prometheus and Vertica Grafana DataSource Plugins

Announcing an end-to-end solution to monitor your Vertica metrics! This solution provides a detailed overview of the open-source Grafana Data Source Plugin and Vertica Prometheus Exporter. It explains how you can use these plugins individually to track your metrics in Grafana or use them together based on your requirement. This solution covers • Grafana Data...

We Got Your Favorite Vertica Grafana Datasource Plugin an Upgrade!

We just released the vertica-grafana-datasource plugin with new and improved features. Since its recent release, we have had about 250k plus downloads and the number is only increasing! The raw query mode now supports auto-completion that helps you suggest keywords as you type. You can also configure your backup server node which means that the...

OpenText Welcomes Micro Focus Customers, Partners, and Employees

OpenText CEO and CTO Mark Barrenechea blogs on how the Micro Focus acquisition expands OpenText's mission to help enterprise professionals secure their operations, gain more insight into their information, and better manage an increasingly hybrid and complex digital fabric. Read his article here.

GigaOm Radar for Data Warehouses Recognizes Vertica as Leader

With the excitement in our industry regarding the emergence of data lakehouses, there’s a good chance that you are planning to modernize or even “replatform” your incumbent data warehouse to meet an ever-evolving variety of analytical use cases. Many vendors, like Vertica, have transformed the original concept of data warehouses with groundbreaking innovations like massively...
Vertica plus Domino Data Lab logos

Unleash the Power of Data Science with Vertica and Domino Data Lab

Introducing an end-to-end machine learning solution with Vertica and Domino Data Lab that enables you to explore, analyze, and model your data in Vertica using VerticaPy. Domino Data Lab is a data science platform to build and deploy machine learning models, monitor performance, and collaborate with one another. VerticaPy is a Python library to perform...
SQL Query Optimization

Improving COUNT DISTINCT Performance with Approximate Functions

A common analytic use case is to find the number of distinct items in a data set. Vertica performs well at solving COUNT DISTINCT in a few ways. Since Vertica stores all data in columns, it is possible to optimize for COUNT DISTINCT by building a projection that is tuned for this use case. Vertica...
Vertica plus Prometheus Logo image

Monitor your Vertica Metrics in Prometheus Using the New Vertica Prometheus Exporter

Looking to visualize Vertica metrics in your favorite monitoring tool that supports Prometheus? You can now do it with the Vertica Prometheus Exporter! We are happy to announce the Vertica Prometheus Exporter, an open-source project now available on Vertica’s GitHub. The exporter uses the vertica-sql-go driver to connect to Vertica. Prometheus is a monitoring system...

Break the bias – and predict brake bias

The theme for this year’s International Women’s Day (IWD) was given the name #BreakTheBias to get us to imagine a gender equal world. A world free of bias, stereotypes, and discrimination, a world that is diverse, equitable, and inclusive, where difference is valued and celebrated. Together, we can protect women’s equality. At Micro Focus, as...
spark plus vertica hands touching

Unleash the Power of Vertica and Apache Spark Using the Upgraded Spark Connector

This post is authored by Alex Le What is Apache Spark? Apache Spark is a distributed compute engine that provides a robust API for data science, machine learning, or to work with big data. It is fast, scalable, simple, and supports multiple languages, including Python, SQL, Scala, Java, and R. Backed by the Apache 2.0...

Vertica Grafana Plugin just got an Upgrade!

A new version of the Vertica Grafana Plugin is now available. You can download it from the Vertica GitHub page or the Grafana website. With many of our customers using the Vertica Grafana plugin, addition of the new Vertica Performance Dashboard makes it easy to visualize metrics. You can now create dashboards, quickly import it...