Autopilot™ for SQL (Public Preview)

Autopilot for SQL is a suite of AI-powered features that assists you in editing and testing data transformations, reducing manual effort and ensuring the accuracy of the data used in your process app.

Autopilot for SQL helps you to:

• Automatically create suggested transformation rules.
• Detect inconsistencies or errors in data transformations.
• Recommend optimal data joins and formatting for faster trasformation.

To get started with Autopilot for SQL, select the Autopilot icon from the header bar. This opens the Autopilot chat window, where you can choose from default prompts or enter a prompt yoursef to start an Autopilot chat.

Autopilot for SQL can also suggest activities to configure SQL queries or even add new SQL files. For example, you can ask: Can you add a SQL file for Suppliers?

Autopilot for SQL then returns follow-up questions, suggests next steps, and provides an action summary before applying changes. You can review, accept, or refine the suggestions as needed.

Check out About Autopilot chat in the Autopilot user guide for more information.

Example: Explain SQL using Autopilot

The following illustration shows and example on how you can ask Autopilot to explain a SQL query. You can use the prompt "Can you explain the SQL in this file?", for a SQL file that you opened in the data transformations editor.

Example: Adding bussiness logic using Autopilot

The following illustration shows an example on how you can ask Autopilot to add a tag to the Tags.sql file. You can use the prompt "Please add a tag with all cases without a case value."

Example: Fixing a SQL error using Autopilot

You can use Autopilot to update a SQL query and fix an issue identified in an error message in the Log. The following illustration shows an example using the prompt "Can you fix the SQL error I see in my log?".