In this article
Table of Contents | ||||
---|---|---|---|---|
|
Overview
You can use this account type to connect Snowflake Snaps with data sources that use Snowflake S3 Database accounts.
Prerequisites
None.
Limitations and Known Issues
None.
Behavior Change
...
Account Settings
...
Specify a unique label for the account.
Default Value: None.
Example: Snowflake_S3_Database_Account
...
N/A
...
Use this field set to specify the JDBC JAR files to be loaded (Snowflake JDBC jar 3.0.0 or higher).
Info |
---|
The Snowflake account has been tested for version 3.12.3 JDBC JAR. |
Click to add a new row for each JDBC JAR file. Add each JAR file in a separate row. See Downloading the JDBC Driver for more information about JDBC drivers and downloading the appropriate driver for your account.
This field set contains the JDBC Driver field.
...
Specify the driver to use for your application.
Default Value: N/A
Example: snowflake-jdbc-3.12.3.jar
...
Specify the hostname of the Snowflake server to which you want to connect.
Default Value: N/A
Example: demo.snowflake.net
...
Specify the port number associated with the Snowflake S3 database server that you want to use for this account.
Default Value: 443
Example: 808
...
Specify the username that you want to use to connect to the Snowflake database server.
Default Value: N/A
Example: SW_User
...
Specify the password for the username.
Default Value: N/A
Example: P@$$W0r!
...
Specify the name of the Snowflake database to which you want to connect.
Default Value: N/A
Example: TestDB
...
Specify the name of the warehouse to which you want to connect.
Default Value: N/A
Example: SW_WH
...
Specify the fully-qualified/domain name of the JDBC driver class to be used for connecting to the Snowflake Google Database Storage server.
Default Value: com.snowflake.client.jdbc.SnowflakeDriver
Example: net.snowflake.client.jdbc.SnowflakeDriver
...
Specify the name of the S3 bucket that you want to use for staging data to Snowflake.
Default Value: N/A
Example: sl-bucket-ca
...
Specify the relative path to a folder in the S3 bucket listed in the S3 Bucket field. This is used as a root folder for staging data to Snowflake.
Default Value: N/A
Example: https://sl-bucket-ca.s3.<ca>.amazonaws/<sf>
...
Specify the S3 access key ID that you want to use for AWS authentication.
Default Value: N/A
Example: NAVRGGRV7EDCFVLKJH
...
Specify the S3 secret key associated with the S3 Access-ID key listed in the S3 Access-key ID field.
Default Value: N/A
Example: 2RGiLmL/6bCujkKLaRuUJHY9uSDEjNYr+ozHRtg
...
Specify the S3 AWS Token to connect to private and protected Amazon S3 buckets.
Info |
---|
The temporary AWS Token is used when:
|
Default Value: None
Example: AQoDYXdzEJr
...
Use this field set to define the account parameter's name and its corresponding value. Click + to add the parameters and the corresponding values. Add each URL property-value pair in a separate row. It consists of the following fields:
- URL property name
- URL property value
...
Specify the name of the parameter for the URL property.
Default Value: N/A
Example: queryTimeout
...
Specify the value for the URL property parameter.
Default Value: N/A
Example: 0
...
In this article
Table of Contents | ||||
---|---|---|---|---|
|
Overview
You can use this account type to connect Snowflake Snaps with data sources that use Snowflake S3 Database accounts.
If the Snap fails to connect to the database, it attempts to reconnect three times.
You can validate an account connection when creating a Snowflake S3 Database Account, but not when creating a Snowflake S3 Dynamic Account because the account properties of a dynamic account are provided dynamically as pipeline parameters. The difference between the Snowflake S3 Database Account and Snowflake S3 Dynamic Account is that in the latter you can specify the account properties as expressions that reference pipeline parameters.
Prerequisites
None.
Limitations and Known Issues
If an S3 bucket is specified in the SnapLogic Snowflake Account, the S3 credentials are validated as follows:
The S3 access-key ID and S3 secret key specified are used to create an S3 connection.
If the S3 access-key ID and S3 secret key are not specified, the Snap uses the IAM role instead.
If the Snap is not able to write to the S3 bucket, validation ends with an error stating that the Snap is unable to write to the specified S3 bucket.
If the Snap is able to write to (but not delete from) the specified S3 bucket, validation ends with an error indicating that the configuration is not able to delete from the S3 bucket.
The S3 AWS token is also validated if specified.
Note that only global Security Token Service (STS) regions are supported.
If an S3 bucket isn’t specified in the SnapLogic Account, no validation of S3 credentials occurs.
Account Settings
Info |
---|
|
...
Field Name | Field Type | Field Dependency | Description | |
---|---|---|---|---|
Label* Default value: None | String | N/A | Specify a unique label for the account. | |
Account properties* | ||||
JDBC JARs | Use this field set to add a list of JDBC JAR files to be loaded. The Snowflake account has been tested with the JDBC driver version 3.14.0.
| |||
JDBC Driver* Default value: None | String | N/A | Specify the fully-qualified name of the JDBC driver class to be used for connecting to the server. The Snowflake Snap Pack is bundled with the default Snowflake JDBC JAR v3.14 file. Therefore, even if you do not provide a JDBC Driver, the account does not fail. | |
Hostname* Default value: None | String | N/A | Specify the hostname of the Snowflake server to which you want to connect the new account. | |
Port Number* Default value: 443 | Integer | N/A | Specify the port number associated with the Snowflake database server that you must use for this account. | |
Authentication Type* Default Value: Password | Dropdown list | N/A | Choose an authentication type to connect to the database. The available options are:
| |
Username* Default Value: N/A | String | N/A | Specify the username to connect to the Snowflake database server. | |
Password* Default Value: N/A | String | Appears when you select Password for Authentication Type. | Specify the password associated with the username specified above. This will be used as the default password while retrieving connections. | |
Encrypted Private Key* Default Value: N/A -----END PRIVATE KEY----- | String | Appears when you select Key Pair for Authentication Type. | Specify the key that you have generated for authentication. The key must include the generated header and footer. The Private Key is read, decrypted if necessary, and included with properties to connect to Snowflake, where it is validated with its paired Public Key to authenticate the connection. Learn more about configuring and generating a valid key pair. | |
Encrypted Private Key Passphrase* Default Value: N/A | String | Appears when you select Key Pair for Authentication Type. | Specify the passphrase for the Encrypted Private Key. Leave this field blank if the specified Private Key is not encrypted. However, we recommend that you use Encrypted Private Key. | |
Database name* Default value: None | String | N/A | Specify the name of the database to which you want to connect. | |
Warehouse name* Default value: None | String | N/A | Specify the name of the warehouse to which you want to connect. | |
JDBC Driver Class Default Value: net.snowflake.client.jdbc.SnowflakeDriver | String | N/A | Specify the JDBC driver class to use. | |
S3 Bucket Default Value: N/A | String | N/A | Specify the name of the S3 bucket that you want to use for staging data to Snowflake.
| |
S3 Folder Default Value: N/A | String/Expression | N/A | Specify the relative path to a folder in the S3 bucket listed in the S3 Bucket field. This is used as a root folder for staging data to Snowflake. | |
S3 Access-key ID Default Value: N/A | String/Expression | N/A | Specify the S3 access key ID that you want to use for AWS authentication. | |
S3 Secret key Default Value: N/A | String/Expression | N/A | Specify the S3 secret key associated with the S3 Access-ID key. listed in the S3 Access-key ID field. | |
S3 AWS Token Default Value: None | String/Expression | N/A | Specify the S3 AWS Token to connect to private and protected Amazon S3 buckets. Note that only global Security Token Service (STS) regions are supported. The temporary AWS Token is used when:
| |
S3 Storage Integration Default Value: N/A | String/Expression | N/A | Specify the predefined storage integration that is used to authenticate the Amazon S3 bucket hosting as an external stage.
For more information about creating Storage Integration, see Configuring a Snowflake Storage Integration to Access Amazon S3. | |
Advanced properties | ||||
URL Properties | Use this field set to define additonal URL properties to use if any. | |||
URL property name Default value: None | String | N/A | Specify the name of the URL property. Snowflake allows session parameters to be set as follows: Session parameters enable you to customize Snowflake sessions and manage access control to various resources within a Snowflake account. | |
URL property value Default value: None | String | N/A | Specify the URL property value associated with the URL property name. | |
Batch size*
| Integer | N/A | Specify the number of Snowflake queries that you want to execute at a time.
|
|
|
|
|
| |
Fetch size* Default |
value: |
100 |
12 |
Integer | N/A | Specify |
the number of rows a query must fetch for |
Default Value: 100
Example: 12
each execution. Large values could cause the server to run out of memory. | ||||
Min pool size* Default value: 3 | Integer | N/A | Specify |
the minimum number of idle connections that you want the pool to maintain at a time. | |
Max pool size* Default |
value: |
15 |
Integer | N/A | Specify |
the maximum number of connections that you want the pool to maintain at a time. | |
Max life time* Default |
value: |
60 |
50 | Integer | N/A | Specify |
the maximum lifetime of a connection in the pool, in seconds. |
|
|
|
Default Value: 60
Example: 50
Minimum value: 0 | ||||
Idle Timeout* Default value: 5 | Integer | N/A | Specify |
the maximum amount of time in seconds that a connection is allowed to sit idle in the pool. |
0 indicates that idle connections are never removed from the pool. |
Example: 4
Minimum value: 0 | |
Checkout timeout |
* Default value: 10000 | Integer | N/A | Specify |
the maximum time in milliseconds you want the system to wait for a connection to become available when the pool is exhausted. |
Example: 9000
If you provide 0, the Snap waits infinitely until the connection is available. Therefore, we recommend you not to specify 0 for Checkout Timeout. For any other value other than 0, the Snap displays an exception after the wait time has expired. Minimum value: 0 |
...
Multiexcerpt include macro | ||||||||
---|---|---|---|---|---|---|---|---|
|
Multiexcerpt include macro | ||||||||
---|---|---|---|---|---|---|---|---|
|
Snap Pack History
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...