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 Anomaly Description written on it

Detect Outliers Using Isolation Forest

George Larionov
August 2, 2022

The Isolation Forest (IForest) algorithm is a powerful and scalable algorithm for identifying outliers in your data. It uses a unique approach which focuses directly on characterizing outliers instead of normal data points. Specifically, IForest focuses on the two quantitative properties of outliers: they are few and different. A scalable implementation of the Isolation Forest algorithm is available...

Announcing our Integration with Chata

Amrita Akshay, Information Developer
July 28, 2022

We’re thrilled to announce our new integration with AutoQL, a natural language interface to database system (NLIDB) by Chata. You can now use this conversational AI solution to ask questions, get insights, and analyse your data in Vertica. This exploration covers the implementation process, deployment options, how to connect to Vertica, and use the AutoQL...

When the typewriter is broken: Vertica’s Event-Based Windows to the rescue

Mark Whalley, Manager, Vertica Education
July 18, 2022

Those of you who read my blog post “Take nothing but memories. Leave nothing but footprints” may recall my passion for using Raspberry Pi computers to capture IoT data from aeroplane transponders and GPS satellites, then feeding that streaming data into Apache Kafka and to integrate it with Vertica and perform near real-time analytics and...

Subscribe For Email Updates

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

Sign-up

What’s needed for a happy software dev team in data analytics?

Mike Perrow, Senior Product Marketing Writer/Editor
July 6, 2022

For an organization to excel at data analytics, the IT team needs to coordinate a number of different disciplines and personnel with experience in those disciplines. This usually includes data analysts, data engineers, and, increasingly, data scientists. The data engineering discipline is sometimes thought of as the plumbing that, like pipes in a house, delivers...

VerticaPy Unify 2022 Sessions

Badr Ouali, Head of Data Science
June 21, 2022

Vertica Unify 2022 is a great time to learn about Vertica, its new features, and best practices. To complement the many great presentations at Vertica Unify 2022 both in Boston and Paris, I’m very excited to present two sessions: one on VerticaPy best practices, and another general session on VerticaPy and its features. VerticaPy is...

No need to extract data from your database to do your analytics!

Mark Whalley, Manager, Vertica Education
June 16, 2022

While taking a long-awaited, and, IMHO some well-deserved R&R in the sun, I heard that ping notification coming from my backpack, and not being one who can ignore such things, reached for my iPad. With my OOTO email response already set, I should be able to ignore most incoming messages, texts and otherwise, safe in...

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
Vertica Version 12

Announcing Vertica Version 12

Steve Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
June 6, 2022

Vertica is pleased to announce version 12 of our unified analytics platform. Since the introduction of Vertica version 11 around June last year, several releases have gone out. Our release cycle has become more continuous, and the Vertica engineering team packs a lot of capabilities into every release. What this means is that a LOT...

Customers in the Spotlight at Vertica Unify ’22

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
May 31, 2022

It’s hard to believe that it has been almost a decade since we held our inaugural Vertica Big Data Conference, back in 2013. At that time, our goal was to hold an annual user conference with a few simple yet guiding principles – no sales or marketing pitches, hold the event in Boston, and line...

Vertica Wins the Gold in Bloor Market Update

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
May 3, 2022

Know Your Options for Analytical Databases and Data Warehouses For CDOs and CIOs, there have never been more options to choose from when deciding where to run their analytical workloads. Analytical databases and data warehouses are two popular options – with the data warehouse market experiencing 10% annual growth and many new entrants* – particularly...

Vertica for Time Series Analytics and IoT

Steve Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
May 3, 2022

When you want to make a prediction – stocking levels for items in your store, predicting energy usage so supply is ready, or being proactive about equipment failures – those predictions often rely on time-series data, a series of data points measuring the same signal or process through time. By analyzing that data, companies can...
Vertica and GitLab Logo

Vertica and GitLab Integration

Amrita Akshay, Information Developer
April 29, 2022

Good news for GitLab users! You can now integrate GitLab with Vertica to run your SQL scripts in GitLab CI/CD itself with GitLab runner. Alternatively, you can integrate using only Linux or a Git supported database IDE. These integrations are explained in detail in the Vertica and GitLab: Technical Exploration in our Knowledge Base.
Unified Analytics and Unified Storage Example

Unified Analytics and Unified Storage

Steve Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
April 19, 2022

How data analytics plus object store handles a classic problem Today, VAST Data announced a partnership and integration with Vertica. The partnership combines a popular and proven analytical database with a hot new up-and-coming object storage company. This relationship is meaningful for the future of analytics, because the future of analytics is hybrid clouds. Let...