In this article
Table of Contents | ||||
---|---|---|---|---|
|
Overview
You can use this account type to connect Snowflake Snaps with data sources that use Snowflake Google Storage Database accountsto a Snowflake instance hosted on Google Cloud Platforms.
Info |
---|
The Snowflake - Bulk Load and Snowflake - Bulk Upsert Snaps support loading data from Google Cloud Storage as an external stage. |
Prerequisites
A valid Snowflake database account.
Limitations and Known Issues
None.
Account Settings
...
...
Info |
---|
|
Field Name | Field Type | Field Dependency | Description | ||
---|---|---|---|---|---|
Label* Default Value: None | String | N/A | Specify a unique label for the account. |
Default value: N/A
Example: Snowflake GCS 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. Click + to add a new row |
for each JDBC JAR file. Add each JAR file in a separate row. |
for more information about JDBC drivers and downloading the appropriate driver for your account. |
This field set contains the JDBC Driver field.
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 |
demo.snowflake.net | String | N/A | Specify the hostname |
of the Snowflake server to which you want to connect |
the new account. | |
Port Number* Default value: |
443 |
332 | 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 |
Key Pair | Dropdown list | N/A |
Choose an authentication type to connect to the |
database. The available options are:
| |
Username* Default Value: N/A |
SW_User | 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 |
Specify the name of the Snowflake database to which you want to connect.
Default value: N/A
Example: SWDB
-----BEGIN PRIVATE KEY-----MIIE6TAbBgkqhkiG9w0BBQMwDgQILYPyennlX2bd8yX8 -----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.
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 encrypted private key passphrase for authentication. | ||||
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 |
Snowflake_cdw |
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. | ||
Google Cloud Storage (GCS) Bucket Default value: N/A | String/Expression | N/A | Specify the name of the GCS bucket from which to load the staged data to your Snowflake database. | ||
Google Cloud Storage (GCS) Folder Default value: |
N/A |
_Files | String/Expression | N/A | Specify the relative path to the folder in the GCS bucket where the source files are located. This is used as a root folder for staging data. | ||
Storage Integration Default value: |
N/A |
GCS_ |
Storage_Integration | String/Expression | N/A | Specify the predefined storage integration that is used to authenticate the Google |
Example: GCS_Storage_Integration
Advanced properties | |||||
URL |
Properties | Use this field set to define |
- URL Property name
- URL Property value
additional URL properties to use, if any. | |||||
URL property name Default value: None | String | N/A | Specify the name of the |
URL property. |
URL property value Default value: None |
4 | String | N/A | Specify the URL property value |
associated with the URL property |
name. | ||
Batch size* Default value: |
50 |
9 |
Integer | N/A | Specify |
the number of Snowflake |
queries that you want to execute at a time |
Fetch size* Default value: |
100 |
90 |
Integer | N/A | Specify |
the number of rows a query must fetch for each execution. | ||
Min pool size* Default value: |
3 |
4 | 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 |
10 | 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 |
90 | Integer | N/A |
Specify |
the maximum lifetime of a connection in the pool, in seconds. |
Default Value: 60
Example: 90
Minimum value: 0 | |||||
Idle Timeout* Default value: 5 | Integer | N/A | Specify |
the maximum amount of time |
a connection is allowed to sit idle in the pool. |
Default Value: 5
Example: 6
A value of 0 indicates that idle connections are never removed from the pool. Minimum value: 0 | |||||
Checkout timeout* Default value: 10000 | Integer | N/A | Specify |
the number of milliseconds you want the system to wait for a connection to become available when the pool is exhausted. |
|
Example: 9000
Minimum value: 0 |
Generating a Valid Key Pair
Multiexcerpt include macro | ||||||||
---|---|---|---|---|---|---|---|---|
|
Multiexcerpt include macro | ||||||||
---|---|---|---|---|---|---|---|---|
|
Snap Pack History
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...