In this article
...
Limitations and Known Issues
None.
Account Settings
ParameterField Name | TypeField Dependency | DescriptionDefault Value | Example | |
---|---|---|---|---|
Label* | String | Required.N/A | Specify a unique label for the account. | NDefault value: N/A |
JDBC JARS | 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* | String | Required. N/A | Specify the driver class to use for your application. NDefault value: N/A | |
Hostname* | StringN/A | Required. Specify the hostname of the Snowflake server to which you want to connect. Default value: N/A | ||
Port Number* | String | Required. 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* | String | Required. N/A | Specify the username that you want to use to connect to the Snowflake Google Storage database server. NDefault value: N/A | |
Password* | String | Required. N/A | Specify the password for the username. NDefault value: N/A | |
Database name* | String | Required. The N/A | Specify the name of the Snowflake database to which you want to connect. NDefault value: N/A | |
Warehouse name* | String | Required. The N/A | Specify the name of the warehouse to which you want to connect. NDefault value: N/A | |
JDBC Driver Class | String | The 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 | StringN/A | Specify the name of the GCS bucket from which to load the staged data to your Snowflake database. NDefault value: N/A | ||
Google Cloud Storage (GCS) Folder | StringN/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. NDefault value: N/A | ||
Storage Integration | StringN/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 | StringN/A | Specify the name of the parameter for the URL property. Default value: N/A | ||
URL Property value | StringN/A | Specify the value for the URL property parameter. Default value: N/A | ||
Batch size* | IntegerN/A | Required. Specify the number of Snowflake queries that you want to execute at a time. Default value: 50 | ||
Fetch size* | IntegerN/A | Required. Specify the number of rows a query must fetch for each execution. Default value: 100 | ||
Min pool size* | IntegerN/A | Required. Specify the minimum number of idle connections that you want the pool to maintain at a time. Default value: 3 | ||
Max pool size* | IntegerN/A | Required. Specify the maximum number of connections that you want the pool to maintain at a time. Default Value: 15 | ||
Max life time* | IntegerN/A | Required. Specify the maximum lifetime of a connection in the pool, in seconds. Default Value: 60 Minimum value: 0 | 90 | |
Idle Timeout* | IntegerN/A | Required. Specify the maximum amount of time in seconds that a connection is allowed to sit idle in the pool. Default Value: 5 Minimum value: 0 | 5 | 6 |
Checkout timeout* | IntegerN/A | Required. Specify the maximum time in milliseconds you want the system to wait for a connection to become available when the pool is exhausted. Default Value: 10000 Minimum value: 0 Maximum value: No limit | 10000 | 9000 |
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
...