How VerticaPy reduces TCO - Umar Farooq Ghumman & Badr Ouali

Vertica is a powerful and scalable MPP database that allows for end-to-end data science at scale. However, as it is a relational database, it relies on pure SQL.
VerticaPy is a Python-based abstraction designed to facilitate data science in Vertica.
It offers a range of functionalities, from data exploration to machine learning, and can help to reduce total cost of ownership (TCO).
We will focus on three main points:
• Performance: VerticaPy pushes everything to Vertica, making it fast and scalable.
There is no need for additional technologies to perform data exploration in a timely manner.
VerticaPy also offers several optimizations to avoid impacting the core system.
• Machine learning: VerticaPy includes machine learning functionality that is easy to use and deploy, without the need for additional technologies or consultants.
• Open architecture: With DBLINK integration, it is possible to query any external database using a simple ODBC connection.
You will see how easy it is to query multiple sources in one place, with Vertica pushing aggregations or pulling data as needed for different use cases.

Umar Farooq Ghumman & Badr Ouali, Vertica