Vertica Blog

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

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

Read More

Hybrid Deployment for an Enterprise Data Warehouse Provides Maximum Benefits

Hemendhira Muralidharan, Senior Product Marketing Manager
July 28, 2021

Hybrid cloud strategy is the future of enterprises. As vital as the cloud can be to improving the economics and agility of Enterprise Data Warehouse (EDW) provisioning, most enterprises will need some on-premises capability as well to satisfy requirements for performance, privacy, and security, for both them and their customers. In addition, a lot of...

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

Announcing Vertica Integration with Workato

Amrita, Information Developer
July 30, 2021

We are very excited for our latest integration with Workato! Workato is an Integration Platform as a Service (iPaaS) that intelligently integrates applications and automates workflows. Workato uses a recipe which is its user-friendly interface to connect multiple applications and automate complex business workflows. Each recipe starts with a trigger that initializes the integration and...

Announcing Vertica Integration with Querybook

Amrita, Information Developer
July 29, 2021

We are pleased to announce the integration of Vertica with Querybook. Querybook is an open-source IDE developed by Pinterest that allows you to query data, create analyses, and share your queries. Querybook also features a simple notebook interface that lets companies configure query engines, table metadata ingestion, and access permissions. It allows them to create...

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

Subscribe For Email Updates

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

Sign-up

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

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

Explore Popular Topics

DBadmin
SQL
Advanced Analytics
machine learning
Best Practices
VSQL
Cloud
Eon Mode
Vertica
Analytics
Partner Integrations
AWS
IoT
Time series
Open Source

Quick Tip: Replacing non-UTF-8 Characters

Jim 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...
Quick Tip - blue button

Quick Tip: MC Adds a New Feedback Button

Jim 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

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