...
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 (Snowflake JDBC jar 3. |
1.0 or higher) |
. 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. See Downloading the JDBC Driver for more information about JDBC drivers and downloading the appropriate driver for your account. | ||||
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.
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. | ||||
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 | 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 | String/Expression | N/A | Specify the predefined storage integration that is used to authenticate the Google | ||||
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. | ||||
URL property value Default value: None | String | N/A | Specify the URL property value associated with the URL property name. | ||||
Batch size* Default value: 50 | Integer | N/A | Specify the number of Snowflake queries that you want to execute at a time | ||||
Fetch size* Default value: 100 | Integer | N/A | Specify the number of rows a query must fetch for each execution. | ||||
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 | Integer | N/A | Specify the maximum lifetime of a connection in the pool, in seconds. 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. 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. Minimum value: 0 |
Multiexcerpt include macro | ||||||||
---|---|---|---|---|---|---|---|---|
|
...