Vertica Blog
Soniya Shah smiling

Soniya Shah

Information Developer

Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.

I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.

Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!

Connect With Soniya on

Estimate the Price of Diamonds Using Vertica Machine Learning

Soniya Shah, Information Developer
November 7, 2017

This blog post was authored by Vincent Xu. In this blog post, I’ll take you through the exercise I did to estimate the price of a diamond based on its characteristics, using the linear regression algorithm in Vertica. Besides Vertica 9.0, I used Tableau for charting and DbVisualizer as the SQL editor. From this exercise,...

Try out the new Vertica Community Edition Virtual Machine!

Soniya Shah, Information Developer
November 6, 2017

This blog post was authored by Kathy Taylor. New to Vertica? Wondering where to start? Why not start with our new 8.1.1 Community Edition VM? It's free! Just download the VM and start it up in a VM player on your PC. Open the User Guide, start the exercises, and off you go! You'll be...

What’s New in Vertica 9.0: Security and Authentication

Soniya Shah, Information Developer
November 2, 2017

This blog post was authored by Phil Molea. Multi-realm Support Vertica 9.0 introduces multi-realm support for Kerberos authentication. This allows you to assign a different realm so that users from another realm can authenticate to Vertica. At times, customers may store users in a protected directory server (AD or Linux KDC) for their trusted realm....
Three 3D arrows, different colors pointing in different directions

What’s New in Vertica 9.0: Google Cloud Platform

Soniya Shah, Information Developer
November 1, 2017

This blog post was authored by Chris Daly. Announcing Vertica availability in Google Cloud Platform With the release of Vertica 9.0, the team at Micro Focus has brought you a ton of new updates and enhancements that are certainly worthy of getting excited about! If you haven’t had a chance, you should check out the...

What’s New in Management Console 9.0

Soniya Shah, Information Developer
October 31, 2017

This blog post was authored by Lisa Donaghue. In Vertica 9.0, Management Console (MC) provides tools to provision and manage clusters and databases on an AWS environment. You can get started easily with a guided Cluster Creation wizard on AWS. The new Fast Tasks page introduces new users to a few fundamental MC tasks to...
Modern Database Analytics

Machine Learning Mondays: Vertica 9.0 Cheat Sheet

Soniya Shah, Information Developer
October 30, 2017

This blog post was authored by Vincent Xu. Vertica 9.0 is out and here is the updated Vertica machine learning cheat sheet. Vertica 9.0 introduces a slew of new machine learning features including one-hot encoding, Lasso regression, cross validation, model import/export, and many more. See the cheat sheet for examples of how to use the...

What’s New in Vertica 9.0: Machine Learning Enhancements

Soniya Shah, Information Developer
October 26, 2017

This blog post was authored by Soniya Shah. Vertica 9.0 introduces new functionality that continues to match our goals for fast-paced development of the existing machine learning functions. In this release, we introduce two new summary functions, support for cross validation, support for one hot encoding, and the ability to import and export your models...

Vertica Deep Dive Comes to Boston: #OwnTheNew

Soniya Shah, Information Developer
October 24, 2017

This blog post was authored by Sarah Lemaire. Two weeks after the successful Deep Dive in Los Angeles, Boston-area Vertica users had the unique opportunity to meet with Sumeet Keswani and Shrirang Kamat from the Vertica Customer Experience Team. These two Vertica experts offered attendees tips for managing their Vertica environment for maximum performance. These...
Database Server Room

What’s New in Vertica 9.0: Reading Parquet and ORC from S3

Soniya Shah, Information Developer
October 23, 2017

This blog post was authored by Monica Cellio. Parquet and ORC are widely-used Hadoop columnar file formats. Because these formats are columnar, they perform extremely well when queried as external tables in Vertica. Vertica queries implement column selection, predicate pushdown, and partition pruning. Vertica has supported reading Parquet and ORC data from HDFS or from...

Vertica 9

Soniya Shah, Information Developer
October 18, 2017

This blog post was authored by Steve Sarsfield. The Vertica development team has just released Version 9.0. With every major release it gives me time to not only look back and see what was developed this cycle, but a look at the entire timeline. I joined the Vertica team about 4 years ago in the...
Database Server Room

What’s New in Vertica 9.0: Eon Mode Beta

Soniya Shah, Information Developer
October 17, 2017

This blog post was authored by Soniya Shah. What is Eon Mode Beta? With Vertica 9.0, you can run Vertica in Eon Mode Beta, using Amazon Web Services to capitalize on cloud economics while still enjoying the fast query processing for which Vertica is known. Running Vertica in Eon Mode Beta separates the computational processes...

What’s New in Vertica 9.0?

Soniya Shah, Information Developer
October 16, 2017

This blog post was authored by Soniya Shah. In Vertica 9.0, we introduce new functionality including: • Eon Mode Beta • Supported Platform Updates • Machine Learning Enhancements • Apache Hadoop Integration Updates • Partition Grouping and Hierarchical Partitioning • Browsing S3 Data Using External Tables • Support for the UUID Data Type Eon Mode...