Let's take a look at an example that demonstrates how you can create a mapping by starting the conversation with a basic prompt.
1You submit the following basic prompt to start the conversation:
I want to create an integration pipeline. I'll figure out my sources and targets on the fly.
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 source:
1. Microsoft Fabric Warehouse
2. Snowflake Data Cloud
3. Fabric Onelake1
4. Fabric Onelake2
5. Fabric Onelake3
2You submit the following prompt:
I don't want to use any of these connections. List all Oracle connections for me.
CLAIRE Copilot replies with the following statement:
Here's a list of connections:
1. ADB Oracle
2. ADB Oracle2
3. CRM Connection
4. New_Oracle_RDS
5. Oracle3
3You submit the following prompt:
Great. I want to use ADB Oracle.
CLAIRE Copilot replies with the following statement:
The Source's connection of ADB Oracle validation is successful, but object name is not provided, please verify.
4You submit the following prompt:
Let's use the CUSTOMERS table.
CLAIRE Copilot replies with the following statement:
The Source connection of ADB Oracle, object name of CUSTOMERS validation is successful.
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
5You submit the following prompt:
I forgot which step I'm on right now. What else do I need to do to generate the pipeline?
CLAIRE Copilot replies with the following statement:
The Source connection has been successfully validated with the object name 'CUSTOMERS'. The Target connection is pending clarification/identification. Please choose a Target connection from the list provided earlier.
6You submit the following prompt:
List all CSV file connections so I can choose a target.
CLAIRE Copilot replies with the following statement:
Here's a list of connections:
1. AA_FF_tgt
2. Tgt_2_CSV
3. flatfile_target
4. flatfile_target2
5. flatfile_target_Copy
7You submit the following prompt:
Awesome. Let's use flatfile_target as my target connection.
CLAIRE Copilot replies with the following statement:
The Target's connection of flatfile_target validation is successful, but object name is not provided, please verify.
8You submit the following prompt:
Let's create a new file called test_object.csv for the target object.
CLAIRE Copilot replies with the following statement:
The Target connection of flatfile_target, object name of test_object.csv validation is successful.
Now that the mapping has a source and target, CLAIRE Copilot generates a summary of the mapping and asks you if you want to create it.