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!

Amrita Akshay, Information Developer
April 11, 2023

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

Sruthi Anumula, Senior Database Support Engineer
March 7, 2023

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

Amrita Akshay, Information Developer
May 11, 2023

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

Amrita Akshay, Information Developer
May 10, 2023

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

Sruthi Anumula, Senior Database Support Engineer
May 9, 2023

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

Amrita Akshay, Information Developer
May 4, 2023

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

Sruthi Anumula, Senior Database Support Engineer
February 14, 2023

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)

Matt Spilchen, Senior Systems Software Engineer
February 3, 2023

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

SQL
DBadmin
Advanced Analytics
machine learning
Best Practices
Cloud
VSQL
Eon Mode
Analytics
Partner Integrations
Vertica
Open Source
AWS
IoT
Time series

OpenText Welcomes Micro Focus Customers, Partners, and Employees

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
January 31, 2023

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

Matt Spilchen, Senior Systems Software Engineer
January 26, 2023

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

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
January 17, 2023

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

Sruthi Anumula, Senior Database Support Engineer
January 9, 2023

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