Input SQL Data

To provide one or more SQLs:

• Select the Connection Name from the drop down menu.

• Select the desired schema.

• Provide the SQL and a name (the name should not have spaces).

• Click on Validate.

• If the SQL is valid, the SQL will be added to the list on the right side.

SQL Input

Instead of writing the SQL, we can also write the requirement in English

Steps to write the requirement in English

• Select the Connection Name from the drop down menu.

• Select the desired schema.

• Provide the SQL and a name (the name should not have spaces).

• Select checkbox "Use AI SQL Assistance"

• Select all the tables, that are required for this SQL by clicking on "Add Tables"

• In "AI Prompt", enter English description.

• Click on "Generate SQL"

Example : select all records from customers table who have placed orders from orders table after year 2023

This is beta feature and there could be issues with generated SQL