Skip to main content

Using Archie with SQL queries

Use Archie to automatically convert a natural language question into a well structured SQL query with a plain English description to aid in human understanding.

Data analysts and business users can jump into the data and do exploratory analysis quicker because they can now use natural language to generate SQL. When these generated queries and summaries are saved, this helps all future users who might have a similar question because saved descriptions and queries are searchable!

To generate an explanation of a SQL query:

  1. Browse to a project where you want to work with the SQL query.

  2. Browse to an already saved query in the project.

  3. In the Archie section, click the Summarize SQL button.

  4. This automatically generates an explanation of the query in simple English.

To generate a SQL query from simple text:

  1. Browse to a project where you want to work with the SQL query.

  2. Open the resource you want to query.

  3. In the query box type in simple English what you want the query to do.

  4. In the Archie section, click the Generate SQL button.

  5. 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.

In this section: