Data Transformation > Data transformation > Sample prompts to create an ELT pipeline
  

Sample prompts to create an ELT pipeline

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:
Response from CLAIRE GPT displaying a mapping that loads all gold customers using Source, Filter, and Target transformations.

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:
Response from CLAIRE GPT 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:
Response from CLAIRE GPT displaying a mapping that loads the customer data using Source, Joiner, Aggregator, and Target transformations.

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:
Response from CLAIRE GPT displaying a mapping that loads the payment data using Source, Joiner, Aggregator, Sorter, and Target transformations.