Data Engineering Streaming
- Data Engineering Streaming 10.4.0
- All Products
Property
| Description
|
---|---|
UpdateMode
| Not applicable for streaming mappings.
|
Database
| Overrides the database name specified in the connection.
|
Schema
| Overrides the schema name specified in the connection.
|
Warehouse
| Overrides the Snowflake warehouse name specified in the connection.
|
Role
| Overrides the Snowflake user role specified in the connection.
|
Pre SQL
| Not applicable for streaming mappings.
|
Post SQL
| Not applicable for streaming mappings.
|
Batch Row Size
| Not applicable for streaming mappings.
|
Number of local staging files
| Not applicable for streaming mappings.
|
Truncate Target Table
| Truncates the database target table before inserting new rows.
Select one of the following options:
Default is false.
|
Additional Write Runtime Parameters
| Specify additional run-time parameters.
Separate multiple runtime parameters with &.
To run streaming mappings to a Snowflake target, configure the following properties:
For example, consider the following run-time parameters:
Specify the
pem_private_key and the
streaming_stage properties in the following format:
pem_private_key=<PEM_key_value>&streaming_stage=<stage_name>
The
pem_private_key and
streaming_stage properties are applicable for streaming mappings on the Spark engine.
|
Table Name
| Overrides the table name of the Snowflake target table.
|
Rejected File Path
| Not applicable for streaming mappings.
|
Target Schema Strategy
| Target schema strategy for the Snowflake target table.
You can select one of the following target schema strategies:
|