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.
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
Last updated