Vertica Blog

Announcing Vertica Version 12

Posted June 6, 2022 by Steven Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem

Read More

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

Load Balancing on Elastic Kubernetes Clusters

Your long-running sessions could fail after you deployed Vertica on Elastic Kubernetes Cluster (EKS) with Load Balancer as the service type. When the load balancer type is not specified in yaml, by default, EKS generates a classic load balancer with a default connection idle timeout of 60 seconds. The aws-load-balancer-connection-idle-timeout can be set up to...
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,...
Tips in bright neon red letters on a dark background with touchscreens.

Default Custom User Resource Pool

In Vertica versions 12.0.4 and later, you can set a default user resource pool for all users instead of defaulting users to a general pool, using the DefaultResourcePoolForUsers configuration parameter. How to set it? As a dbadmin user, create a user resource pool. The pool name can be used to configure the DefaultResourcePoolForUsers option. In...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

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...
Helpful Tips in blue text with magnifying glass

Restrict Modifying Table Rows (UPDATE/DELETE) Irrespective of User Privileges

Do you have a table with critical information such as SIEM events or credit card transactions? Do you want to be able to block user access to UPDATE/DELETE rows in those tables? From version 12.0.0, you can do this by setting the tables as IMMUTABLE. This means you can only insert data and not modify...
Kubernetes and containers

Vertica on Amazon Elastic Kubernetes Service (EKS)

Introduction In my previous blog, I showed you the steps to run Vertica on Kubernetes (K8s) on your laptop. That’s fine if you want to try things out on a small scale, but what if you want to run it on a larger system? In this blog, I will teach you how to deploy Vertica...

Explore Popular Topics

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.
Kubernetes and containers

Vertica on Kubernetes

This blog post has been updated from an earlier one to use new features that make deploying on your own system easier. Vertica released the VerticaDB operator in August, 2021, which began Vertica’s integration with Kubernetes. The operator automates many Vertica administrator tasks, such as restarting Vertica if any of the nodes go down, upgrading...

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...
Tips in bright neon red letters on a dark background with touchscreens.

High Availability for a Vertica in Eon Mode Database with Read-Only Mode

When Vertica is deployed in Eon Mode, there are two major requirements for high availability: maintaining quorum and shard coverage. If either of them is lost, the whole cluster goes down. Before going into details, let us understand what quorum and shard coverage mean. Quorum: In Eon Mode, more than half of the primary nodes...