Snowflake Azure Database Account

In this article

Overview

You can use this account type to connect Snowflake Snaps with data sources that use the Snowflake Azure Database account. 

You can use the Snowflake Azure Account type to create both standard and dynamic accounts.

Prerequisites

None.

Limitations and Known Issues

None.

Account Settings

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon ( ): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ( ): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( ): Indicates that you can add fields in the field set.

  • Remove icon ( ): Indicates that you can remove fields from the field set.

 

Field Name

Field Type

Field Dependency

Description

Field Name

Field Type

Field Dependency

Description

Label*

Default value: None
ExampleSnowflake Azure Database Account

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. By default, the Snowflake account is bundled with the JDBC driver version 3.16.0. However, you can add a custom JAR file.

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
Example: snowflake-jdbc-3.16.0.jar

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 driver v3.16.0. Therefore, even if you do not provide a JDBC Driver, the account does not fail.

 

 

Hostname*

Default value: None
Example: demo.snowflake.net

String/Expression

N/A

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

Port Number*

Default value: 443 
Example: 332

Integer/Expression

N/A

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



Authentication Type*



Default Value: Password
Example: Key Pair

Dropdown list

N/A

Choose an authentication type to connect to the database. The available options are:

  • Password: Authenticates with the Username and Password credentials.

  • Key Pair: Authenticates using the Private Key and Encrypted Private Key Passphrase.

Username*

Default Value: N/A
ExampleSW_User

String/Expression

N/A

Specify the username to connect to the Snowflake database server.

Password*

Default Value: N/A
Examplell@98#*00w

String/Expression

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
Example: -----BEGIN PRIVATE KEY-----MIIE6TAbBgkqhkiG9w0BBQMwDgQILYPyennlX2bd8yX8
xOxGSGfvB+99+PmSlex0FmY9ov1J8H1H9Y3lJXXb

-----END PRIVATE KEY-----

String/Expression

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
Example: Nki62lmWfFO75Xg04W+Fnlt9ejiMn4zPbkf/me Aq1R3X7CM/ORLuLms4vU70NjzNYo09SO
UXhQmoqpEkQBvrrYuzdaQt5hvwh7vZQh WZ5L8+lTRoA
neFtmd6LZ94AssA==

String/Expression

Appears when you select Key Pair for Authentication Type.

Specify the encrypted private key passphrase for authentication.

Database name*



Default value: None
Example: testdb

String/Expression

N/A

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



Warehouse name*



Default value: None
Example: testwh

String/Expression

N/A

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



JDBC Driver Class



Default Valuenet.snowflake.client.jdbc.SnowflakeDriver
Examplenet.snowflake.client.jdbc.SnowflakeDriver

String

N/A

Specify the JDBC driver class to use.



Azure storage account name



Default value: None
Exampletestazurestorage

String/Expression

N/A

Specify the name of the instance of the Azure storage account.



Azure storage account key



Default value: None

String/Expression

N/A

Specify the key to connect to the instance of the Azure storage account listed above.

You can use either of the two keys available in the Access Key tab of the dashboard in the Azure portal to populate this value.

Container



Default Value: None
Example: Container1

String/Expression

N/A

Specify the name of the Azure storage blob container that you want to use for hosting files.



Path

Default Value: None
Example: Folder1/SubFolder1

String/Expression

N/A

Specify the location of the folder in the container listed above where you want to host files.



Shared Access Signature (SAS) Token Method



Default Value: User Supplied

Dropdown list

N/A

Specify the method of supplying the SAS token to the Snaps. You can choose between the following two options:

  • User Supplied: Choose this option if you intend to manually enter the shared access token signature.

    If you opt for the User Supplied option, then you need to ensure that your tokens are valid whenever the pipeline is run; else, the pipelines will fail. For more information, see Generating a SAS Token in Snowflake documentation.

  • System Generated: Choose this option if you want Snaps to generate and use the SAS tokens as and when required.

User token



Default Value: None

String/Expression

N/A

Specify the shared access token that you want to use to access the Azure storage blob folder specified in the Path above. You can get a valid SAS token from the Azure portal.

This property is applicable only when you choose User Supplied in the Shared Access Token Signature Method field above. 

Client side encryption



Default Value: None
Example: Custom_Key

Dropdown list

N/A

Select either of the following options to encrypt the blob before uploading to Microsoft Azure:

  • None: Indicates that you do not want to use client-side encryption.

  • Custom_Key: Indicates that you want to use a custom key to access the storage blob.



Custom key



Default Value: None

String/Expression

N/A

Specify the custom key that you want to use to access the Azure storage blob. This property is applicable only when you select Custom_Key in the Client side encryption field above. The key should be a 128- or 256-bit Base64-encoded key.

Advanced properties

URL Properties

Use this field set to define additonal URL properties to use if any.

URL property name

 

Default value: None
ExamplequeryTimeout

String

N/A

Specify the name of the URL property.



URL property value

 

Default value: None
Example: 0

String

N/A

Specify the URL property value associated with the URL property name.



Batch size*



Default value: 50
Example: 40

Integer/Expression

N/A

Specify the number of statements that you want to execute at a time.

Fetch size*



Default value: 100
Example200

Integer/Expression

N/A

Specify the number of rows you want a query to fetch during each execution.



Min pool size*



Default value: 3
Example: 2

Integer/Expression

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

Integer/Expression

N/A

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

Minimum value: 0
Maximum value: No limit

Max life time*



Default value: 60
Example: 50

Integer/Expression

N/A

Specify the maximum lifetime of a connection in the pool. Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. A value of 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.



Idle Timeout*



Default value:5
Example: 4

Integer/Expression

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.



Checkout timeout*



Default value: 10000
Example: 9000

Integer/Expression

N/A

Specify the number of milliseconds you want the system to wait for a connection to become available when the pool is exhausted. 

Generating a Valid Key Pair

Snap Pack History

 


Related Links

<