Using a Snowflake JDBC connection, Connect for Big Data can
write supported Snowflake data types to Snowflake targets directly for optimal
performance.
At the Target Database Table dialog, define a Snowflake
database table target:
-
At Connection,
select a previously defined Snowflake target connection or select Add
new... to add a new one.
-
Select
a table from the list of Tables, or select Create new... to create a new one.
- User defined SQL statement is not supported.
- All target disposition methods are supported.
-
On the Parameters tab, the following optional parameters are available for Snowflake target database tables. Values specified here take precedence over their corresponding property in the jdbc configuration file, if any.
- Maximum parallel streams - the maximum number of parallel streams that can be established to load data for performance and that are created according to demand.
- Work directory connection - name of the Amazon S3 that Connect uses to connect to and write to work table directory.
- Work table codec - specifies the compression algorithm used to compress Snowflake data.
- Work table directory - serves as the parent-level directory beneath which job-specific subdirectories are created for staging data.
- Work table encryption - server-side encryption algorithm to encrypt the staging data
- Work table schema - the schema used to create the staging table.
-
Set commit interval and Abort task if any record is rejected are not supported.