Cloud Data Integration for PowerCenter
- Cloud Data Integration for PowerCenter
- All Products
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 .
|
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.
|
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.
\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.
|
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.
|