Vertica Blog

OpenText Vertica 23.3 – the Smarter Data Lakehouse

Posted July 31, 2023 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Unveiling the Most Recent Version of the Vertica Grafana Data Source Plugin

Amrita Akshay, Information Developer
October 12, 2023

With over 380K downloads, the Vertica Grafana Data Source plugin just got an upgrade! The plugin was migrated from the deprecated older Grafana toolkit to align with Grafana's new Create-Plugin tool. This accelerates the plugin development with their modern build set up that requires no additional configuration. Additionally, the Vertica SQL Go driver received an...
Quick Tip on a blue enter key on a keyboard

Setting Session Authorization to Troubleshoot

Sruthi Anumula, Senior Database Support Engineer
September 29, 2023

There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...
A key with a key hole and Unlock Vertica Potential in text at the bottom

How to Use Database Designer to Optimize Vertica Physical Data Model in Six Steps

Maurizio Felici, Field Chief Technologist
June 16, 2023

Vertica provides out-of-the-box a powerful tool to tune its Physical Data Model: Database Designer (DBD from now on). You can run DBD using the Management Console GUI but in this article we will focus on what they call “programmatic interface” (read... plain SQL) and – as practical examples are often more enlightening than “theoretical” documentation...

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

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

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

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