To improve the accuracy of the mappings that CLAIRE Copilot creates, use the guidelines to provide clear and specific details that describe the data flow in the mapping.
To create a mapping prompt, use the following guidelines:
•Be clear and concise when you describe the use case and mapping details.
•Provide all details about source and target objects, source and target connections, and the transformations in the mapping. For each transformation, specify what the transformation does.
•Use key words for transformations and functions. For more information about the transformations, transformation capabilities, and functions; see Transformations and Function Reference.
•Start the prompt by providing source and target details. Then, provide transformation details in the same order that the transformations appear in the mapping.
•Specify only one data flow. CLAIRE Copilot can't create mappings with multiple data flows.
Prompt: Create a mapping to filter and route accounts
Let's break down the following prompt:
Create a mapping to extract data from Account table in Salesforce connection and write it to a new table in Snowflake connection. Get the accounts where created year is 2025 and route the accounts in “USA” to one table and the remaining accounts to another table.
The prompt provides the source and target details, including the respective source and target connections. Then, it describes the data flow in the mapping. First, the mapping filters the data by accounts that were created in 2025. Then, the mapping routes the account data to two tables.
The following table lists the key words and how they correspond to mapping elements:
Key words
Mapping element
Account table
Source object in the Source transformation
Salesforce connection
Source connection in the Source transformation
new table
Target object in the Target transformation
Snowflake connection
Target connection in the Target transformation
where created year is 2025
Filter transformation
route the accounts in "USA"
Router transformation
The following image shows each key word in the prompt:
When CLAIRE Copilot creates a mapping based on the prompt, it adds the transformations in the following order: Source, Filter, Router, and Target.
Prompt: Create a mapping to transform the account data
Let's break down the following prompt:
Create a mapping to read data from Account table using Salesforce connection and write it to a new table in Snowflake connection. Join the Account and Orders tables on AccountId. Trim all except the last 6 characters from the ID field and filter only for Accounts where Ownership is 2. Find total employees for each Type by counting account IDs. Route the rows where Type is "Customer - Direct" to one table, ones where Type is "Customer - Channel" to a different table, and the remaining to a third table.
The following table lists the key words and how they correspond to transformations in the mapping:
Key word
Transformation
Join
Joiner transformation
Trim
Expression transformation with the LTRIM function
filter
Filter transformation
counting
Aggregator transformation with the COUNT function
Route
Router transformation
The following image shows each key word in the prompt:
When CLAIRE Copilot creates a mapping based on the prompt, it adds the transformations in the following order: Source, Joiner, Expression, Filter, Aggregator, Router, and Target.
