Generating and explaining SQL queries with Archie
Archie enables users to generate SQL queries from natural language input and provides plain English explanations for existing queries. This feature helps data analysts and business users explore data more efficiently without needing extensive SQL knowledge.
Users can type a question in simple English, and Archie will generate a structured SQL query. Additionally, for existing queries, Archie can generate a clear, human-readable explanation, making it easier to understand and reuse queries. Saved queries and their descriptions are searchable, allowing future users to find and leverage previous work.
To generate an explanation of a SQL query:
Browse to a project where you want to work with the SQL query.
Browse to an already saved query in the project.
In the Archie section, click the Summarize SQL button.
This automatically generates an explanation of the query in simple English.
To generate a SQL query from simple text:
Browse to a project where you want to work with the SQL query.
Open the resource you want to query.
In the query box type in simple English what you want the query to do.
In the Archie section, click the Generate SQL button.
This automatically generates the query and adds it to the query box. Review the query to make sure it is correct. Alternatively, click the Run Query button to see if it runs properly or there are any errors in it. Fix the errors and run the query again.