About SQL AI
- This feature is available only in the latest UI.
- This is a cloud-only feature. It is not available for Collibra Platform for Government (FedRAMP) or self-hosted (CPSH) environments.
AI SQL writer helps you accelerate the creation and troubleshooting of custom SQL rules, making it easier for both advanced and beginner SQL users to create regulatory compliance rules, discover unusual or inaccurate records, and maintain the overall health of your organization's data. The AI SQL writer:
- Suggests custom SQL queries based on your plain-text input.
- Helps troubleshoot malformed or syntactically incorrect SQL queries.
Note This feature is powered by Collibra AI. For information on how we leverage AI in our products, including how we handle data used for training and input, please visit the Collibra Trust Site.
SQL AI flow
The general SQL AI flow is as follows:
- A user enters a plain-text prompt into the SQL AI from the rule workbench.
- The prompt is sent to the Collibra AI proxy
- The suggested SQL query response is formulated.
- The response is routed back to the Data Quality & Observability and is shown in the UI.
Prompt examples
The following examples show the types of prompts you can ask SQL AI. This list is not exhaustive but provides an idea of how simple or complex your prompt can be for SQL AI to suggest a query that meets your needs.
- "high is more than 50"
- "find all of the unique values in Column1 and show how many records exist for each"
- "compare the 2 dates 2018-01-13 to 2018-01-14 - write 2 separate queries for each date, using trade date - write as a common table expression for tables a and b - join using symbol column - use a join to identify which values are in 2018-01-14 that are not in 2018-01-13 - the goal is to find values that are missing from the previous day"