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

First annual “Data Disruptors Awards” caps Vertica Unify 2021

Mike Perrow, Senior Product Marketing Writer/Editor
July 27, 2021

“Vertica has been powering the world’s data disruptors for a decade, including companies that have created new industries, and have had an impact on the environment, and on the health of humans and animals.” Those were the opening comments by Joy King, Vertica’s VP of Product and Go-to-Market Strategy, at Thursday morning’s opening session for...

DataGals Panel reveals common workplace biases, but also opportunities

Mike Perrow, Senior Product Marketing Writer/Editor
July 23, 2021

  Representing five different time zones, and committed to sharing their thoughts and guidance based on the success they’ve achieved in their careers, five women gathered live and online Thursday, July 22 to discuss their experiences in high tech. Here's how they appeared in this virtual panel discussion: Far left: Joy King, VP of Product...

Vertica Unify 2021 – Day 2 keynote spotlights a noble cause

Mike Perrow, Senior Product Marketing Writer/Editor
July 21, 2021

At Vertica Unify 2021, the focus this week has been on the techniques and best practices around data analytics. Naturally. There’s a lot of technology to cover in this space, and we’re delighted to have so many of the best and brightest minds in virtual attendance, helping us deliver, explain, and demonstrate these things. And,...

Subscribe For Email Updates

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

Sign-up

Vertica 11 announced at Unify 2021: Delivering on vision of Unified Analytics

Mike Perrow, Senior Product Marketing Writer/Editor
July 20, 2021

Introduced by Joy King, Vertica’s VP of Product & GTM Strategy, Colin Mahony, SVP and General Manager of Vertica, kicked off today’s Vertica Unify 2021 by explaining Vertica’s founding philosophy and sharing “some of the advancements we’ve made most recently, as well as the direction we’re going in future.” That included the announcement of Vertica...

DaaS Labs Embeds Vertica for Machine Learning Analytics at Superior Speed and Scale

Hemendhira Muralidharan, Senior Product Marketing Manager
July 19, 2021

Uncovering hidden patterns, trends, correlations, and insights in data has become a common business pursuit as companies look for different ways and means to monetize their data. Most of this activity relies on advanced data techniques like artificial intelligence, natural language processing, machine learning, deep learning, computer vision, and more. These techniques are DaaS Labs’s...

Quick Tip: Replacing non-UTF-8 Characters

James Knicely, Vertica Field Chief Technologist
July 16, 2021

Vertica database servers expect to receive all data in UTF-8 and Vertica outputs all data in UTF-8. However, you can load or insert data into Vertica that is non UTF-8, but you'll want to clean it up. I used to recommend the REGEXP_REPLACE function for that task, but now there is a better way! 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
Quick Tip - blue button

Quick Tip: MC Adds a New Feedback Button

James Knicely, Vertica Field Chief Technologist
July 15, 2021

Do you love Vertica and want to let us know, or want to provide some constructive criticism? Well, now you can easily do that. Starting in Vertica 10.1.x, Management Console added a new Feedback Button which lets you submit a star rating and free-text comments to Vertica. The button displays vertically at the bottom-right of...
Helpful Tips in blue text with magnifying glass

Quick Tip: Determining Database “Cell” Count

James Knicely, Vertica Field Chief Technologist
July 14, 2021

The Vertica system tables LICENSE_AUDITS and USER_AUDITS include a mysterious column called CELL_COUNT. What exactly is the Cell Count? It's simply a calculation that looks like this: DATABASE CELL_COUNT = (Table_1 Column Count * Table_1 Row Count) + (Table_2 Column Count * Table_2 Row Count) + … + (Table_n Column Count * Table_n Row Count)...

The Climate Corporation awarded for outstanding AI/ML: We’re all winners with sustainable agriculture

Cheryl Bradstreet
June 28, 2021

The Climate Corporation, a subsidiary of Bayer, aims to help all the world’s farmers sustainably increase their productivity with digital tools. The Climate FieldView™ platform provides farmers with a comprehensive, connected suite of digital tools aimed at mitigating risk and optimizing farm productivity. As Vertica’s customer references manager, I gather stories around what our users...

Taking the pulse of cloud adoption trends: The Flexera “State of the Cloud” report

Jeremiah Morrow, Senior Industry Product Marketing Manager
June 23, 2021

Before I joined Vertica, I worked in the cloud services world, first for a reseller and then for a Cloud Services Provider (CSP). During my time in this space I followed cloud adoption trends closely by necessity, and one of my favorite sources of data on the subject was RightScale’s (now Flexera’s)  “State of the...

Partners Showcase Solutions at Vertica Unify ’21

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
June 21, 2021

Registrations for Vertica Unify ’21 are rapidly climbing as we anticipate thousands of data experts to convene for the analytics event of the year. Vertica customers have long adopted a "best tool for the job" approach – and that goes beyond choosing Vertica to accelerate analytics and machine learning at scale. Success often requires our...

Vertica-as-a-Service: Advanced analytics just got a little easier

Joy King, VP Product & GTM Strategy, Vertica
June 15, 2021

Anytime business software can provide greater ease-of-use, it leads to better business outcomes at a faster pace. What could be better than that? How about analytics-as-a-service, built on a cloud-native architecture running in your AWS account, and leveraging your own negotiated pricing and committed spend? Add the full suite of advanced analytics, in-database machine learning,...