Table of Contents

Search

  1. Preface
  2. Getting started with PowerCenter modernization
  3. Repository Assessment
  4. Asset Conversion
  5. Bulk Metadata Update
  6. Jobs
  7. Configurations

PowerCenter Modernization

PowerCenter Modernization

Snowflake advanced properties

Snowflake advanced properties

The following tables lists the Snowflake properties that you can configure for a
Connection Map configuration
:

Object properties

The following table describes the Snowflake connection properties:
Connection property
Description
Database
The Snowflake database name to be used when creating the object. The database name similar to the database name specified in the
DATABASEMAP.properties
file.
Default is
dbname_changeit
.
Schema
The Snowflake schema name to be used when creating the object. Th schema name is similar to the schema name specified in the
SCHEMAMAP.properties
file.
Default is
schema_changeit
.
Specify the parameters in the following format:
<database name>/<schema name>
You must specify both the database and schema name. If you specify only the database name, source objects do not appear in the Select Source Object window. If you specify only the schema name, an
Invalid Schema
exception occurs while reading data.

Source advanced properties

The following table describes the Snowflake source advanced properties:
Property name
Description
Database
Overrides the database specified in the connection.
Default is
$$sf_database
.
Schema
Overrides the schema specified in the connection.
Default is
$$sf_schema
.
Warehouse
Overrides the Snowflake warehouse name specified in the connection.
Role
Overrides the Snowflake role assigned to user you specified in the connection.

Target advanced properties

The following table describes the Snowflake target advanced properties:
Property Name
Description
Database
Overrides the database that you used to import the object.
Default is
$$sf_database
.
Schema
Overrides the schema that you used to import the object.
Default is
$$sf_schema
.
Warehouse
Overrides the Snowflake name specified in the connection. The warehouse name in the mapping overrides the warehouse name you specify in the connection.
Role
Overrides the Snowflake role assigned to the user specified in the connection.
Batch Row Size
The number of rows written to a single file in the agent location. When the number of rows written to the file reaches the value specified, the agent flushes the data queue and starts processing the write commands.
Number of local staging files
The number of files that represents a single batch of data.
The default number of files considered is 64.
After the agent uploads the specified number of local staging files to the Snowflake user stage, Snowflake unloads the data to the target table.
Additional Write Runtime Parameters
The additional runtime parameters that you can use when you write to Snowflake.
You can enter multiple write runtime parameters, separated by ampersand (&).
Rejected File Path
The filename and path of the file on the agent machine where you want to write the rejected records.
For example,
\rejectedfiles\reject7
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the agent forwards rejected rows to the next transformation.

Lookup advanced properties

The following table describes the Snowflake lookup transformation advanced properties:
Property Name
Description
Database
Overrides the database specified in the connection.
Default is
$$sf_database
.
Schema
Overrides the schema specified in the connection.
Default is
$$sf_schema
.
Warehouse
Overrides the Snowflake warehouse name specified in the connection.
Role
Overrides the Snowflake role assigned to user you specified in the connection.

0 COMMENTS

We’d like to hear from you!