After you import the source and target objects, create a mapping to read data from and write data to Snowflake.
In a mapping, you define properties that determine how the Data Integration Service extracts data from or loads data to a data source. Configure pushdown optimization for the source and target objects.
Select a project or folder in the Object Explorer view.
Click
Tasks
Create
.
Click
File
New
Mapping
.
Enter a mapping name and click
Finish
.
An empty mapping appears in the editor.
Drag a data object to the editor and select Read to add the data object as a source.
Drag a data object to the editor and select Write to add the data object as a target.
On the
Properties
tab, select
Run-time
.
Select
Full
as pushdown type.
The following image shows the pushdown optimization configuration: