Generating SQL from natural language in Hue

The SQL AI Assistant in Cloudera Data Warehouse (CDW) helps you to generate SQL queries by entering a prompt in natural language. You can then insert the generated SQL in the Hue SQL editor and run it as usual.

Your administrator must have configured and set up the required infrastructure for you to use the SQL AI Assistant. See About setting up the SQL AI Assistant in CDW.
  1. Log in to the Data Warehouse service as DWUser.
  2. Open Hue corresponding to your Virtual Warehouse.
  3. Click Assistant on the Hue SQL editor:
    Screenshot showing how to launch the SQL AI Assistant from the Hue web interface.
  4. Click GENERATE.
    A SQL query is generated based on your input prompt. Click Insert to insert the query into the editor and run it.