Example: Application ingestion incremental load of Salesforce data to Snowflake
Example: Application ingestion incremental
load of Salesforce data to Snowflake
You want to replicate Salesforce data changes continuously to a Snowflake data
warehouse to make sure downstream applications get the latest customer
information.
To do this, let's create an application ingestion and replication incremental load task in
CLAIRE
Copilot
Open
CLAIRE
Copilot
.
In the
Ask CLAIRE
box, type
the prompt
Incremental load of Salesforce data to Snowflake
. Then
click the Submit icon.
A list of Snowflake target connections available in your
organization appears:
Type the number associated with the
Snowflake target connection you want to use. In this example, let's type
1
for the Snowflake_connection. Then click the Submit
button.
Up to five of the most frequently used connections are
listed.
If the
connection isn't listed, you can type the name of a valid Snowflake connection.
Specify an existing connection that you've previously tested.
A list of
Salesforce source connections available in your organization appears:
Type
1
and
click the Submit button to select salesforce_CMI as the source connection.
A
request for the runtime environment appears:
Type @ to list runtime environments.
Click a runtime environment in the list and then click the Submit icon.
If you
previously set a default runtime environment for your use, this step is
skipped.
A request for the Snowflake target schema appears:
Type @ to list Snowflake target
schemas. Click the target schema you want to use and then click the Submit icon.
Alternatively, if you know the schema name, you can just type the name.
A summary
of the task definition appears for your review:
To create the task asset, click
Yes
.
The task is generated and opens in the task
configuration wizard.
Verify the task definition. You can
edit field values and set additional fields on the
Task
Details
,
Transform
, and
Let's
Go
pages. Toggle on
Show Advanced Options
to
see all fields. However, do not change the source and target connections.
For
example, for the Snowflake target, you must specify a value in the required
Stage
field. On the
Let's Go
page, you can enter a custom name and description for the task and your project
location so that you can find the task again easily.
Save the task.
Deploy the task to create a job
instance. You can then run the job from
My Jobs
or another
monitoring interface.
Success! You've created and deployed an application ingestion and replciation incremental
load job in
ASK INFAPreview
