Let's take a look at a few sample prompts to help you get started on creating an ELT pipeline in CLAIRE GPT. The sample prompts show how you can use CLAIRE GPT to create an ELT pipeline and view it as a mapping in Data Integration.
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 Mappings in the Data Integration help.
Prompt: Create a mapping to load all gold customers
The following image shows the response of CLAIRE GPT to the prompt, creating a pipeline that loads gold customers:
Prompt: Show the number of customers located in each city
The following image shows the response of CLAIRE GPT to the prompt, displaying the number of customers in each city:
To create a mapping, use the prompt Create a mapping for the above. The following image shows the response of CLAIRE GPT to the prompt, creating a mapping for customers:
Prompt: Create a pipeline that ranks payment methods by number of customers who use them
The following image shows the response of CLAIRE GPT to the prompt, generating a pipeline that ranks the payment methods: