PowerExchange for Snowflake User Guide

10.5
- 10.5.6
- 10.5.4
- 10.4.1
- 10.4.0

Back Next

Creating a Snowflake Target

You can create a Snowflake target using the

Create Target

option.

Select a project or folder in the

Object Explorer

view.

Select a source or a transformation in the mapping.

Right-click the Source transformation and select

Create Target

The

Create Target

dialog box appears.

The following image shows the

Create Target

option:

Select

Others

and then select

Snowflake

data object from the list in the

Data Object Type

section.

The following image shows the

Data Object Type

section:

Click

The

New Snowflake Data Object

dialog box appears.

The following image shows the

New Snowflake Data Object

dialog box:

Specify a name for the Snowflake data object and the path.

Enter a name for the data object.

Click

Finish

The new target appears under the

Physical Data Objects

category in the project or folder in the

Object Explorer

view.

In the Snowflake connection

Details

tab, specify the database and the schema name to create the target type.

The following image shows the connection properties:

You can view the configured database and schema name in the additional JDBC URL parameters field.

In the Snowflake advanced target properties, select the target schema strategy as

Create - Create target if it does not exist

The following image shows the configured advanced properties:

You can view the configured target schema strategy.

Rename Saved Search

Table of Contents

PowerExchange for Snowflake User Guide

PowerExchange for Snowflake User Guide

Creating a Snowflake Target

Creating a Snowflake Target