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 a new table. 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. Fabric_SalesProd 2. Snowflake_AnalyticsDev 3. OneLake_MarketingStaging 4. Snowflake_FinanceProd 5. OneLake_OperationsStaging
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_ProdDB 2. Snowflake_SalesWarehouse 3. Snowflake_MarketingAnalytics 4. Snowflake_DevEnvironment 5. Snowflake_FinanceReporting
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 made a note of target connection Snowflake. I can't find target object [Missing] using connection Snowflake. You can check the spelling or ask me to find a different object.
4You submit the following prompt:
Let’s use Customer_Direct.
CLAIRE Copilot replies with the following statement:
I successfully validated target connection Snowflake and source object Customer_Direct.
Because you provided all missing details, CLAIRE Copilot generates a summary of the mapping and asks you if you want to create it.