Skip to main content
Now that we’ve connected our first data source, let’s explore the data. If you are not familiar with SQL, python or other data exploration languages and frameworks available in popular data warehouses, worry not! Our AI assistant is here to help you.

​
Using the AI assistant

In order to use the AI assistant, follow the steps below:
  1. Go to Explorer and click the AI Assistant button on the right side of the screen.
  2. Enter a question about your data.
  3. The AI assistant will generate a SQL query to answer your question.
  4. Review the query and generated results.
The AI assistant learns from your interactions and feedback, so the more reinforce positive results using the like button, the better it gets.
If you want to make adjustments to the query or even create your own queries from scratch, be aware that the language used in the SQL query editor is Presto DB. See more details about the syntax in the official docs.

​
Example

Consider a table named outbound_leads with the following schema and sample data:
NameCreation DateEmailSourceAge RangeMain Interest
Bonnie Jones2023-10-22 17:24:17erikakramer@example.orgEmail Campaign65+Healthcare
Victoria Schaefer2023-10-23 17:24:17fisherjohn@example.netTrade Show25-34Technology
Jonathon Lucas2023-10-23 17:24:17arichardson@example.comLinkedIn25-34Travel
Suppose you want to know how many leads were created each month to understand your marketing performance. You can simply ask the AI assistant in natural language:
“How many leads were created each month?”
The AI assistant will generate a SQL query to answer your question. It will create the query based on the context of the tables, columns and descriptions available in your Catalog. You can keep iterating on the query until you get the data you need, or even explore the data further with follow-up questions. Video Tutorial For a visual walkthrough of how to explore your data with the AI assistant, watch this video:
Great! You’ve just learned how to use our AI Assistant to help build your SQL queries. ➡️ Now, let’s move on to the next page to understand how to transform your data.
Need Help? If you encounter any issues during onboarding or need assistance, feel free to reach out to our support team. We’re here to help you get started.
⌘I