Cloudera Docs

Getting an explanation of a SQL query in natural language in Hue

You can use the SQL AI Assistant to breakdown and understand a complex SQL query in natural language.

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. Insert a SQL query in the Hue editor that you would like to understand in natural language.
  4. Click Assistant on the Hue SQL editor:
    Screenshot showing how to launch the SQL AI Assistant from the Hue web interface.
  5. Click EXPLAIN.
    Screenshot showing how to generate an explanation of a SQL query in natural language using the SQL AI Assistant in Hue.
    The LLM generates the explanation of the SQL query.
    Screenshot showing the explanation of a SQL query in natural language using the SQL AI Assistant in Hue.