In this article

Insert excerpt

	Generic Database Account
	Generic Database Account
name	Change In Behavior change in Database Execute Snaps
nopanel	true

Account Settings

...

Field

Field Dependency

Description

Label*

N/A

Specify a unique label for the account.

Default Value: None.
Example: Snowflake_S3_Database_Account

JDBC JARs

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.

JDBC Driver*

N/A

Specify the driver to use for your application.

Default Value: N/A
Example: snowflake-jdbc-3.12.3.jar

Hostname*

N/A

Specify the hostname of the Snowflake server to which you want to connect.

Default Value: N/A
Example: demo.snowflake.net

Port Number*

N/A

Specify the port number associated with the Snowflake S3 database server that you want to use for this account.

Default Value: 443
Example: 808

Username*

N/A

Specify the username that you want to use to connect to the Snowflake database server.

Default Value: N/A
Example: SW_User

Password*

N/A

Specify the password for the username.

Default Value: N/A
Example: P@$$W0r!

Database name*

N/A

Specify the name of the Snowflake database to which you want to connect.

Default Value: N/A
Example: TestDB

Warehouse name*

N/A

Specify the name of the warehouse to which you want to connect.

Default Value: N/A
Example: SW_WH

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: com.snowflake.client.jdbc.SnowflakeDriver
Example: net.snowflake.client.jdbc.SnowflakeDriver

S3 Bucket

N/A

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

S3 Folder

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.

Default Value: N/A
Example: https://sl-bucket-ca.s3.<ca>.amazonaws/<sf>

S3 Access-key ID

N/A

Specify the S3 access key ID that you want to use for AWS authentication.

Default Value: N/A
Example: NAVRGGRV7EDCFVLKJH

S3 Secret key

N/A

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

S3 AWS Token

N/A

Specify the S3 AWS Token to connect to private and protected Amazon S3 buckets.

Info

The temporary AWS Token is used when:

Data is staged in S3 location.
Data is coming from the input view and the files are staged in an external staging location.

Default Value: None
Example: AQoDYXdzEJr

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. It consists of the following fields:

URL property name
URL property value

URL property name

N/A

Specify the name of the parameter for the URL property.

Default Value: N/A
Example: queryTimeout

URL property value

N/A

Specify the value for the URL property parameter.

Default Value: N/A
Example: 0

Batch size

N/A

Required. Specify the number of Snowflake queries that you want to execute at a time.

If the Batch Size is one, the query is executed as-is, that is the Snap skips the batch (non-batch execution).@Kalpana Mall
If the Batch Size is greater than one, the Snap performs the regular batch execution.

Default Value: N/A
Example: 3

Fetch size*

N/A

Specify the number of rows a query must fetch for each execution.

Default Value: 100
Example: 12

Note
Large values could cause the server to run out of memory.

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
Example: 0

Max pool size*

N/A

Specify the maximum number of connections that you want the pool to maintain at a time.

Default Value: 15
Example: 0

Max life time*

N/A

Specify the maximum lifetime of a connection in the pool, in seconds.

Info
Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. 0 indicates an infinite lifetime, subject to the Idle Timeout value. An in-use connection is never retired. Connections are removed only after they are closed.

Default Value: 60
Example: 50

Minimum value: 0
Maximum value: No limit

Idle Timeout*

N/A

Specify the maximum amount of time in seconds that a connection is allowed to sit idle in the pool.

Info
0 indicates that idle connections are never removed from the pool.

Default Value: 5
Example: 4

Minimum value: 0
Maximum value: No limit

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.

Default Value: 10000
Example: 9000

Minimum value: 0
Maximum value: No limit

...

Versions Compared

Old Version 13

New Version 14

Key

Account Settings

Page Comparison

Versions Compared

Old Version 13

New Version 14

Key

Account Settings