Vertica Blog

Vertica Blog

Integrations

Construction site crane building a blue SQL 3D text.

Creating Vertica Functions in Third Party Tools

Third party SQL client tools that connect to Vertica often provide a SQL command window where you can type SQL commands and view the results. Most of these tools’ SQL command windows support issuing multiple commands in a single SQL block, using the semicolon as the command delimiter. Here is an example in : The...
Go programming language logo and little blue beaver mascot

The Vertica SQL Driver for Go

We are happy to announce the alpha release of the Vertica SQL Driver for Go. Go, also called GoLang, is a statically-typed, high performance language, syntactically similar to C. Originating at Google, it has grown rapidly in popularity over the past decade and has become a language of choice for highspeed components. The Vertica SQL...
Data protection concept art

Data-Centric Security Rules

I just attended the for the first time. I spoke a little on a small panel with a couple of customers about 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 of , the presenter who put...
Connecting grip

JetBrains DataGrip Offers New Vertica Connector

We are pleased to announce that JetBrains has released a Vertica connector for DataGrip! The connector, , 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 . is a database IDE that offers efficient schema navigation, an...

Vertica Dialect for Hibernate Updated!

The Vertica dialect for Hibernate, updated for Vertica 9.2 and Hibernate 5.4.1, is now available for download. The dialect enables Hibernate to map Java classes to database tables in Vertica. Hibernate is an open-source, Object/Relational Mapping (ORM) framework for Java environments. With Hibernate, developers can create an object library that encapsulates object/relational mapping information for...

Plotting data with vsql and gnuplot

Maurizio Felici authored this post. We all know how plotting data is a very useful – and widely adopted – technique. Linux (and MacOS) offer a wonderful command line tool to plot data called gnuplot. You can install and run gnuplot on one of your Vertica nodes so you don’t have to move data out...

Microsoft Power BI: Latest Release Enhances Connection to Vertica

We are excited to announce the new Vertica connector introduced in the October 2018 release of Microsoft Power BI: • With PowerBI Desktop, Vertica is now fully supported using DirectQuery Mode (push-down optimization). • With Power BI Service (Cloud Offering - Saas), DirectQuery mode is now supported with Vertica using the Power BI On-Premise Gateway....

DbVisualizer Free for Vertica Distribution Updates

Stephen Crossman authored this post Recently, there have been some changes in how DbVisualizer Free for Vertica is distributed. Previously, there were standard DbVisualizer Free and Pro Edition distributions available on the DbVisualizer web site, and there was a special DbVisualizer Free for Vertica distribution available on the Vertica Marketplace. Now, in an effort to...
Three 3D arrows, different colors pointing in different directions

Exiting a DbVisualizer Script Following an Error: Quick Tip

After reading yesterday’s Vertica Quick Tip “Exiting a vsql Script Following an Error”, a client asked if the ON_ERROR_STOP variable is available in the popular third party Vertica client tool DbVisualizer. The answer to that is no, as ON_ERROR_STOP is a Vertica vsql client specific setting. However, many clients, including DbVisualizer, have a similar feature!...
Three 3D arrows, different colors pointing in different directions

vertica-python Becomes Vertica’s First Officially Supported Open Source Database Client

Tom Wall authored this post. We are very excited to announce that vertica-python, the open source python database client for Vertica created by Uber Technologies Inc., will officially become a supported database client for Vertica! This is a great milestone for Vertica and our community of users and developers. Not only do we expect to...

Using Java UDX in Vertica

Michael Flower authored this post. Introduction Vertica has a highly extensible UDx framework, which allows external user-defined functions, parsers and data loaders to be installed onto the Vertica server. This means that a routine written in C++, R, Java or Python can be run in-database as a Vertica SQL function. This blog is based on...

Introducing the Vertica ML-Python Library

This blog post was authored by Soniya Shah. One of the coolest things about working at Vertica is our amazing intern program, which often leads to full-time hires. Last year, the Vertica-ML-Python library, also known as vpython, was started as an internship project by Badr Ouali. A year later, he works for Vertica full time...