Let's take a look at an example that demonstrates how you can fill in missing details during the conversation.
1You submit the following prompt to start the conversation:
Create a mapping to read data from Account table using the "Salesforce" source connection and write it to new tables. Trim all except the last 6 characters from the Id field and Filter only for Accounts where Ownerid is “2”. Find total employees for each Type by counting account IDs.
CLAIRE Copilot replies with the following statement:
It looks like you're trying to create a mapping.
Let's gather some more information.
Here's a list of connections for the target:
1. Microsoft Fabric Warehouse 01
2. Snowflake Data Cloud 02
3. Fabric Onelake 01
4. Fabric Onelake 02
5. Fabric Onelake_Copy
2You submit the following prompt:
Show me all Snowflake connections instead.
CLAIRE Copilot replies with the following statement:
Here's a list of connections:
1. Snowflake Data Cloud 01
2. con_Snowflake_01_Dev
3. SF_CON
4. Snowflake 02
5. Snowflake_QA
3You submit the following prompt:
Great. I know there are more Snowflake connections than the ones listed here. I want to use ‘Snowflake’ as my target connection for all my targets.
CLAIRE Copilot replies with the following statement:
I can't find that target object [Missing] using connection Snowflake. You can check the spelling or ask me to find a different object. Which target object do you want to use?
4You submit the following prompt:
Let’s use Customer_Direct as one table, Customer_channel as one table, and Default as the last table.
CLAIRE Copilot replies with the following statement:
The Target connection of Snowflake, object name of Customer_Direct validation is successful.
The Target connection of Snowflake, object name of Customer_channel validation is successful.
The Target connection of Snowflake, object name of Default validation is successful.
All connections have been identified and updated.
Because you provided all missing details, CLAIRE Copilot generates a summary of the mapping and asks you if you want to create it.
5You submit the following prompt:
Oops, I forgot something. Route the rows where Type is “Customer – Direct” to the first table, ones where Type is “Customer – Channel” to the second table, and the remaining rows to the last table.
CLAIRE Copilot regenerates the mapping summary and asks you again if you want to create it.