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

How to Access Flexible, Cloud-Optimized Analytics on AWS

Ben Smith, Senior Product Marketing Manager
July 1, 2019

Vertica was designed from the very first line of code to be a software-only data warehouse with complete freedom from underlying infrastructure, giving you the choice to decide what hardware to use and where. This commitment to flexibility is evident in our product history, as we took the same core MPP analytics engine from commodity...
Compass rose with true north pointing to "Helpful Tips" text

Tracking VBR Invocations

James Knicely, Vertica Field Chief Technologist
June 28, 2019

The Vertica Backup and Recovery tool (vbr) allows you to back up and restore either the full database, or one or more schema and table objects of interest. You can also copy a cluster and list backups you created previously. You can view vbr invocations by querying the DC_VBR_INVOCATIONS data collector table! Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/VBRUtilityReference.htm...
Vintage businessman concept wearing futuristic helmet at office

Track License Usage Over Time

James Knicely, Vertica Field Chief Technologist
June 28, 2019

The LICENSE_AUDITS system table lists the results of Vertica's license automatic compliance audits. You can query it to track your Vertica license usage over time! Looks like I’m going to need add some new Vertica license soon! Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/LICENSE_AUDITS.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Licensing/CalculatingTheDatabaseSize.htm Have fun!

Subscribe For Email Updates

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

Sign-up

Data protection concept art

Data-Centric Security Rules

Paige Roberts, Vertica Open Source Relations Manager
June 27, 2019

I just attended the Cybersecurity Summit in Dallas for the first time. I spoke a little on a small panel with a couple of customers about Voltage SecureData and Format Preserving Encryption (FPE). Then I got to go to other presentations and learned a lot. Probably the number one presentation that stuck with me, was...
Connecting grip

JetBrains DataGrip Offers New Vertica Connector

Kathy Taylor, Information Technology Developer, Vertica
June 25, 2019

We are pleased to announce that JetBrains has released a Vertica connector for DataGrip! The connector, introduced in DataGrip 2019.1, allows SQL developers to use DataGrip to interact with Vertica. DataGrip uses Vertica’s JDBC driver to connect to Vertica. For details about connecting DataGrip to Vertica, see Vertica Integration with DataGrip: Connection Guide. DataGrip is...
Tips and Tricks Orange Button

A Quick Way to View the Current and Ancient History Mark Epochs

James Knicely, Vertica Field Chief Technologist
June 20, 2019

The MANAGE_EPOCH function can be called to quickly display the Current Epoch (CE) and Ancient History Mark (AHM) Epochs! Helpful Links: https://www.vertica.com/kb/Understanding-Vertica-Epochs/Content/BestPractices/Understanding-Vertica-Epochs.htm Have fun!

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 message on post-it note

Enable All Granted Roles on Login

James Knicely, Vertica Field Chief Technologist
June 20, 2019

You can automatically enable roles for users in two ways: Enable roles for individual users on login (either with the SET ROLE command or default roles). Enable all roles for all users on login (at the database level via the EnableAllRolesOnLogin parameter). The second option is great (and easy) if you want all users to...
Business card that says Expert Tips,

Generate DDL for Changed Configuration Parameters

James Knicely, Vertica Field Chief Technologist
June 13, 2019

The CONFIGURATION_CHANGES system table records the change history of system configuration parameters. If you want to apply all of the changes to a different Vertica database, you can generate the necessary DDL commands to do that! Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/CONFIGURATION_PARAMETERS.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/CONFIGURATION_CHANGES.htm Have fun!
Copy data

Generating Recursive COPY Commands

James Knicely, Vertica Field Chief Technologist
June 13, 2019

Recently a friend mentioned she wanted to load all of the files using the COPY command, where all the data files were located in many, many sub-directories. You can load all of the files in a single command by looping through each of the sub-directories. I have the following files in sub-directories under the parent...
Counting

Table Row Counts by Schema

James Knicely, Vertica Field Chief Technologist
June 13, 2019

I had a colleague ask today how she could generate a report showing the total table row counts by schema. This should be easy, right? After all, the PROJECTION_STORAGE system table has a ROW_COUNT column. But it turns out it’s a little complex considering there are segmented and unsegmented projections and delete vectors in Vertica....
young girl choosing recommended video playback button.

Content Analytics and Video Recommendation Systems with Vertica

Marko Štajcer, Director of Innovation & Development department at Poslovna inteligencija d.o.o.
June 11, 2019

Analyzing digital content and the behavior of viewing customers in real-time is essential to a lot of companies. Communication operators and content providers are offering many services that enable customers to consume video content using different fixed and mobile technologies through different devices, either in their homes or mobile. For these operators and providers, it...
Drawing of 4 blue pillars: Separation, Automation, Prediction, Protection

Vertica’s Architectural Direction – Separation of Compute and Storage

Chuck Bear, Vertica Chief Architect
June 10, 2019

For over a decade, Vertica has delivered industry-leading performance on analytic query workloads in on-premises “shared-nothing” environments. Due to several good (and several lucky) historical architectural decisions, Vertica in Eon Mode is also leading the market for elastic, on-demand databases in public clouds. This post will review the key features of the Vertica architecture, and describe Vertica’s...