Let's take a look at a few sample prompts to help you get started on your Data Governance and Catalog data transformation journey in CLAIRE GPT.
The sample prompts show how you can use CLAIRE GPT to transform tables and create an ELT pipeline that you can run.
When CLAIRE GPT creates an ELT pipeline, it appears in the form of a mapping in Data Integration. The mapping reads a source and writes the transformed data to a target. To edit, save, and run the mapping, click Open in Data Integration. You can run the mapping using SQL ELT optimization. For more information, see the Data Integration help.
Customers with a feedback score greater than 5
To find all customers with a feedback score greater than 5, you can enter the following prompt:
Show all customers in @CUSTOMERS with a feedback score greater than 5
The following image shows the response of CLAIRE GPT to the prompt, displaying customers in the CUSTOMERS table with a feedback score greater than five:
To see the SQL code used to transform the data, expand the Explanation. The following SQL code is used to transform the data: