Cloudera Docs

Fact support for SQL query

The Data Explorer SQL AI Assistant now allows you to use Facts to guide the generation of precise SQL queries. It enables the AI Assistant to process the defined custom facts in the AI Assistant settings to enrich prompt construction and improve the accuracy of complex, cross-database SQL workflows.

Key advantages

  • Provides the Assistant with specific organizational logic to reduce errors in generated SQL code.
  • Enables seamless querying across different systems by defining how disparate datasets relate to each other.
  • Automates the inclusion of complex context, reducing the need for repetitive manual input.

Limitations

  • The system does not currently enforce a character limit for facts. Including excessively long instructions can result in model hallucinations.
  • You can define a list of facts that the SQL AI Assistant includes as global context when generating your queries.
  1. Click Assistant on the Data Explorer SQL editor, then open the AI Assistant Settings.
  2. Define your instruction in the Facts section and click Add.
  3. Click Ok to apply the changes.