In this article
...
Limitations and Known Issues
None.
Account Settings
Field Name | Field Dependency | Description |
---|---|---|
Label* | N/A | Specify a unique label for the account. Default value: N/A |
JDBC JARSJARs | Use this field set to upload the JDBC driver and other JAR files that you want to use into SLDB. Click to add a new row. Add each JDBC 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. | |
JDBC Driver* | N/A | Specify the driver to use for your application. Default value: N/A |
Hostname* | N/A | Specify the hostname of the Snowflake server to which you want to connect. Default value: N/A |
Port Number* | N/A | Specify the port number associated with the Snowflake Google Storage Database server that you want to use for this account. Default value: 443 |
Username* | N/A | Specify the username that you want to use to connect to the Snowflake Google Storage database server. Default value: N/A |
Password* | N/A | Specify the password for the username. Default value: N/A |
Database name* | N/A | Specify the name of the Snowflake database to which you want to connect. Default value: N/A |
Warehouse name* | N/A | Specify the name of the warehouse to which you want to connect. Default value: N/A |
JDBC Driver Class | N/A | 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: net.snowflake.client.jdbc.SnowflakeDriver |
Google Cloud Storage (GCS) Bucket | N/A | Specify the name of the GCS bucket from which to load the staged data to your Snowflake database. Default value: N/A |
Google Cloud Storage (GCS) Folder | 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. Default value: N/A |
Storage Integration | N/A | Specify the predefined storage integration that is used to authenticate the Google Default value: N/A |
URL properties | 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. This field consists of the following fields:
| |
URL Property name | N/A | Specify the name of the parameter for the URL property. Default value: N/A |
URL Property value | N/A | Specify the value for the URL property parameter. Default value: N/A |
Batch size* | N/A | Specify the number of Snowflake queries that you want to execute at a time. Default value: 50 |
Fetch size* | N/A | Specify the number of rows a query must fetch for each execution. Default value: 100 |
Min pool size* | N/A | Specify the minimum number of idle connections that you want the pool to maintain at a time. Default value: 3 |
Max pool size* | N/A | Specify the maximum number of connections that you want the pool to maintain at a time. Default Value: 15 |
Max life time* | N/A | Required. Specify the maximum lifetime of a connection in the pool, in seconds. Default Value: 60 Minimum value: 0 |
Idle Timeout* | N/A | Specify the maximum amount of time in seconds that a connection is allowed to sit idle in the pool. Default Value: 5 |
Checkout timeout* | 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. Minimum value: 0 Default Value: 10000 |
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
...