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

Creating Iceberg External Tables in Vertica

Sruthi Anumula, Senior Database Support Engineer
June 1, 2023

From Vertica 12.0.4 onwards, we support creating external tables with parquet files in Apache Iceberg Table format. Iceberg is a high-performance table format which uses advanced filtering techniques and provides better performance by avoiding file listing. The striking feature of the external Iceberg tables is that there is no need to specify columns when defining...
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,...

Subscribe For Email Updates

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

Sign-up

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

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

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