Versions Compared

Old Version 11

changes.mady.by.user Kalpana Malladi

Saved on

compared with

New Version 12

changes.mady.by.user Kalpana Malladi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

Table of Contents
maxLevel2
absoluteUrltrue

...

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

Info

You can use the Snowflake Azure Account type to create both standard and dynamic accounts. If you want to enter a dynamic value for a specific field, click the Expression Image Modified icon adjacent to the field, and use expressions in the field to specify dynamic values as required.

Prerequisites

None.

Limitations and Known Issues

...

Field NameField TypeDescription
Label*String

Specify a unique label for the account.

Default value: None
Example: Snowflake Azure Account

JDBC JARs

Use this field set to add a list of JDBC jar files to be loaded (Snowflake JDBC jar 3.0.0 or higher). Click  to add a JDBC driver. Add each jar file in a separate row.

JDBC Driver*


Default value: None
Example: net.snowflake.client.jdbc.SnowflakeDriver

String

Specify the fully-qualified name of the JDBC driver class to be used for connecting to the server.


Hostname*


Default value:

 [

None

]


Example:

net

demo.snowflake.

client.jdbc.SnowflakeDriverHostname*

net

String/Expression

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

Port Number*


Default value:

None
Example: demo.snowflake.net		Port Number*

443 

Integer/Expression

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


Authentication Type


DefaultValue: Password
Example: Key Pair


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

  • Password: Authenticates with Username and Password credentials.

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

Default value: 443 

Username*

Username


DefaultValue: N/A
Example: SW_User


Specify the username to connect to the Snowflake database server.

Password


DefaultValue: N/A
Example: ll@98#*00w


Specify the password for the username to connect to the Snowflake database server.

Private Key


DefaultValue: N/A
Example: -----BEGIN PRIVATE KEY-----MIIE6TAbBgkqhkiG9w0BBQMwDgQILYPyennlX2bd8yX8
xOxGSGfvB+99+PmSlex0FmY9ov1J8H1H9Y3lJXXb

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


Specify the key that you have generated for authentication. The key must include the generated header and footer.

The private key is read, decrypted if necessary, and included with properties to connect to Snowflake, where it is validated against its paired public key to authenticate the connection.

Learn more about configuring and generating a valid key pair.

Encrypted Private Key Passphrase


DefaultValue: N/A
Example: Nki62lmWfFO75Xg04W+Fnlt9ejiMn4zPbkf/me Aq1R3X7CM/ORLuLms4vU70NjzNYo09SO
UXhQmoqpEkQBvrrYuzdaQt5hvwh7vZQh WZ5L8+lTRoAneFtmd6LZ94AssA==


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 only.

Username*


Default value: None
Example: testuser

String/Expression

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


Password*


Default value: None
Example:

testuserPassword*

P@##20!(*67

String/Expression

Specify the password associated with the username specified above. This will be used as the default password while retrieving connections.


Database name*


Database name*

Default value: None
Example:

P@##20!(*67

testdb

String/Expression

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


Warehouse name*


Default value: None
Example:

testdbWarehouse name*

testwh

String/Expression

Specify the name of the warehouse to which you want to connect.Default value: None
Example: testwh


JDBC Driver Class

String

Specify the JDBC driver class to use.


Default Value: net.snowflake.client.jdbc.SnowflakeDriver
Example: net.snowflake.client.jdbc.SnowflakeDriver

String

Specify the JDBC driver class to use.


Azure storage account name


Default value: None
Example: testazurestorage

String/Expression

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


Azure storage account key


Default value: None

Example: testazurestorage		Azure storage account keyString/Expression

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

Container

Example: Container1

String/Expression

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


Path


Default value: None
Example:

Container1

Folder1/SubFolder1

PathString/Expression

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

Default value: None
Example: Folder1/SubFolder1


Shared Access Signature (SAS) Token Method


Default value: User Supplied

Dropdown list

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


User token

Default value:

User Supplied

None

String/Expression

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


Client side encryption

Default value: None

.


Example: Custom_Key

Dropdown list

Select one of the following options to encrypt the blob before uploading to Microsoft Azure. You can choose one of the following two options:

  • 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


Example: Custom_Key

Custom keyString/Expression

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.

Default value: None

URL Properties

Use this field set to configure the URLs associated with this account. It consists of the following fields:

  • URL property name
  • URL property value
Note
titleGranting roles

You can grant roles to the SnapLogic Snowflake account by using the role parameter in the URL Properties field set. Ensure that the roles are predefined in your Snowflake account before configuring the SnapLogic Snowflake account. 

URL Property Name: role

URL Property Value: SYSADMIN

See Roles and Grant Roles for details.


URL property name


Default value: None
Example: queryTimeout

String

Specify the name of the URL property.


URL property value


Default valuevalue: None
Example:  queryTimeout

URL property value

0

String

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


Batch size*


Default value: None
Example: 0

Batch size*

50

Integer/Expression

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

Note

Select queries are not batched.


Warning

Using a large batch size could use up the JDBC placeholder limit of 2100.

Default value: 50


Fetch size*Integer/Expression

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

Warning

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


Min pool size*


Default value: 3
Example:2

Integer/Expression

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

Default value: 3
Example: 2

Minimum value: 0
Maximum value: No limit

Max pool size*


Default value: 50
Example: 40

Integer/Expression

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

Note

Snowflake Bulk Load/Bulk Upsert/S3 Upsert Snap requires a minimum of 2 connections per Snap in a pipeline. For example, if a pipeline has a Snowflake Bulk Load Snap and an S3 Upsert Snap, then the pool size must be greater than or equal to 4 for successful execution.

Default value: 50

Example: 40

Minimum value: 0
Maximum value: No limit

Max life time*


Default value: 60
Example: 50

Integer/Expression

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: 605
Example: 504

Idle Timeout*Integer/Expression

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: 510000
Example:4

Checkout timeout*

 9000

Integer/Expression

Specify the number of milliseconds you want the system to wait for a connection to become available when the pool is exhausted. A value of 0 instructs the system to wait forever. For any other value, the system throws an exception after the wait time has expired.Default value: 10000
Example: 9000


Multiexcerpt include macro
nameGenerating a valid key pair
templateData[]
pageSnowflake S3 Dynamic Account
addpanelfalse

Multiexcerpt include macro
nameSnowflake_Accounts_Troubleshooting
templateData[]
pageSnowflake S3 Dynamic Account
addpanelfalse

Insert excerpt
Snowflake Snap Pack
Snowflake Snap Pack
nopaneltrue

...