The operational bottleneck, which frustrates every modern, data-driven enterprise, is a universal challenge. Business leaders have urgent, high-value questions, but the answers are often locked behind a wall of complex database syntax. 

Historically, a human translator, typically a data analyst, was needed to bridge this gap. This process often involved spending hours writing, testing, and debugging complex SQL queries. That loss of time slowed down decision-making, drained valuable engineering resources, and limited organizational agility. 

Imagine if you could ask your database a question using natural language and quickly get the answers you need directly there. With the introduction of AI-assisted analytics in VMware Tanzu Data Intelligence, we are redefining the traditional data access model for multimodal data analytics on private cloud.

The new interface with conversational data

Tanzu Data Intelligence is fundamentally changing the way teams interact with their data estates by introducing a powerful new tool, SQL Assistant for Tanzu Data Intelligence. This tool offers a unified workflow that seamlessly combines natural language query-writing with natural language question-asking.

This AI assistant is not merely a standard chatbot attached to a dashboard. It is a deeply integrated, context-aware tool specifically engineered to enhance data analysts’ efficiency and effectiveness.

For example, an analyst can now ask the system to perform tasks using straightforward, natural language:

• “Tell me which table stores my employee information and which one tracks money made from sales.”
• “Show me a list of the top 3 sales representatives by total revenue generated this year. Use their actual names, not the IDs.”
• “Calculate the monthly sales growth for the last three months. I need to see the month and the total transaction amount.”
• “Check if there are any sales transactions that don’t have a corresponding customer profile or product ID assigned to them.”

With this intuitive, conversational approach, the time it takes to go from a pressing business question to an actionable insight can be significantly reduced. 

While the SQL Assistant accelerates data exploration, it does so with strict, enterprise-grade guardrails. To keep interactions safe, the underlying LLM is restricted strictly to read-only operations. This explicitly prevents from unilaterally executing any structural or destructive database actions, such as DROP, CREATE, or TRUNCATE, helping to keep your data secure and unaltered while users explore what is available to them.

SQL Assistant panel

Here is how the SQL Assistant for Tanzu Data Intelligence can transform the daily workflow for data teams:

Bypassing the code: Direct natural language questions

For business users or analysts who need immediate answers without getting bogged down in syntax, the new tool allows you to completely bypass SQL. You can directly ask natural language questions about your data. By typing a plain-English request, the AI engine interprets the intent, queries the underlying data, and delivers the insight instantly.

Auto-generating complex, engine-specific SQL

For data professionals who need to see, manipulate, or save the underlying code, the AI acts as an expert pair programmer. When prompted with a natural language request, it automatically generates complex SQL queries.

Crucially, the tool understands the specific architecture it is running on. It does not just generate generic SQL; it writes highly optimized, VMware Tanzu Greenplum-specific SQL queries tailored to the advanced analytical capabilities of Tanzu Data Intelligence. Users can seamlessly copy and paste this AI-generated SQL directly into the editor for further refinement or immediate execution.

Deciphering the past: Explaining legacy code

One of the most time-consuming tasks for any data analyst is inheriting and deciphering undocumented legacy code. A query written years ago by an engineer who is no longer at the company can take days to untangle. The SQL Assistant, leveraging AI-assisted analytics, serves as an instant translator. By highlighting a block of complex SQL, the AI can instantly explain exactly what the legacy code does, the tables it touches, and the logic it executes.

Mastering MPP: Intelligent optimization

Writing functional SQL is one thing; writing SQL that executes efficiently across a massive, distributed database is another.

Tanzu Greenplum relies on massively parallel processing (MPP) to query petabytes of data at lightning speed. However, poorly written queries can cause data skew or bottleneck the system. This new Tanzu Data Intelligence feature provides intelligent optimization suggestions specifically for MPP workloads. It analyzes the query and recommends structural changes to enable the workload to execute with maximum efficiency across the distributed nodes.

The future of the analyst

AI-assisted analytics in Tanzu Data Intelligence is not intended to replace data analysts. It is intended to give them a massive multiplier on their effectiveness. By automating the tedious syntax generation, instantly deciphering legacy code, and providing expert-level MPP optimization, analysts are freed from the weeds of query writing. 

This means they can shift their focus from writing code to architecting data strategies, uncovering deeper business insights, and driving true data intelligence across the private cloud.These updates are part of the newly released VMware Tanzu Data Intelligence 10.4. Beyond what we’ve covered here, the new version of Tanzu Data Intelligence introduces innovations like AI-assisted analytics, frictionless private cloud deployments, and seamless integrations between real-time operations and big data analytics, among others. Read the full release announcement here.