About AmpAI Assistant¶
The AmpAI Assistant is a generative AI feature within the SQL Query Editor that provides real-time insights while you author SQL queries against any database in the Customer 360 page.
Use the AmpAI Assistant to:
Ask for help while resolving a SQL error
Get advice on how to improve a query
Ask questions about SQL syntax, such as “What is the syntax for a window function?”
Create SQL queries starting from natural language, such as “Who are my top 100 customers by lifetime spend?” or “Show me everyone who shopped in-store over the last 30 days.”
Important
As with all generative AI capabilities, the outputs of AmpAI Assistant are probabilistic. Users should double check outputs for accuracy.
Review the Privacy FAQ for the AI Assistant to learn more about how the AmpAI Assistant interacts with GPT-4 and the Microsoft Azure OpenAI Service.
Amperity Learning Lab
|
The AmpAI Assistant is a generative AI-based feature that can help you build better SQL queries against the data in your Amperity tenant. Open Learning Lab to learn more about how the AmpAI Assistant can help you build better queries. Registration is required. |
Enable (or disable) AmpAI Assistant¶
AmpAI features, including AmpAI Assistant, may be enabled (or disabled) by a user who is assigned the DataGrid Operator or DataGrid Administrator policy.
To disable AmpAI Assistant
From the Settings page, open the AmpAI tab.
Under Advanced settings, select the Disable AmpAI features option to disable AmpAI features, including the AmpAI Assistant.
Click Confirm.
How AmpAI Assistant works¶
AmpAI Assistant is powered by a private instance of OpenAI GPT-4.
Amperity uses the largest context window that is currently available, and then provides query, schema, results, and error information to the model to help ensure the best chance of generating highly relevant results.
Note
More detail about how AmpAI Assistant works, including data sharing policies, how the model stores data, and what types of data is sent (or not sent), is available from the AI Assistant Privacy FAQ.
Examples¶
The following examples show some of the ways you can use the AmpAI Assistant while working in the SQL Query Editor.
Note
The answers to these questions within your tenant will depend on the query, schema, results, and error information that was provided to the model and may be different than the examples shown in this topic.
Ask questions about syntax¶
You can ask the AmpAI Assistant to help you understand how specific types of syntax work in a SQL query.
- Question
“What is the syntax for a CASE statement?”
- Answer
The AmpAI Assistant will respond similar to:
Note
Amperity uses Presto SQL syntax within the SQL Query Editor.
Ask for help resolving errors¶
When you have an error in your query syntax you can ask the AmpAI Assistant for help resolving the error.
- Question
“Can you help me resolve this error?”
- Answer
The AmpAI Assistant will respond similar to:
Build natural language queries¶
You can use natural language—the same types of sentences you use when talking to co-workers and friends—to ask the AmpAI Assistant to help you build queries against any database in the Customer 360 page.
Customers by lifetime spend¶
- Question
“Who are my top 100 customers by lifetime spend?”
- Answer
The AmpAI Assistant will respond similar to:
Tip
When “Tables and fields are valid” is shown for the SQL returned by the AmpAI Assistant you can try running the query in the SQL Query Editor.
Click the Copy SQL link in the response from the AmpAI Assistant, paste the SQL into the SQL Query Editor, click the Run query button, and then (after the query is finished running) you can view the results.
In-store shoppers¶
- Question
“Show me everyone who shopped in-store over the last 30 days.”
- Answer
The AmpAI Assistant will respond similar to:
