Snowflake

This article describes General Ledger application settings that apply to all users licensed to use the General Ledger feature, when using a Snowflake General Ledger type.

Prerequisites

• Spreadsheet Server version 25.4 or later
• For Key Pair authentication, admin should generate a Private Key or Encrypted Private Key for use

Configuration Steps

1. From the Application Configurator panel, select the Connections tab and create a new connection.

2. Select the Snowflake option under the dropdown menu.

   

3. Give the connection a name. This is the name that will show up on the left side menu once saved. When creating queries or formulas, this is the connection name that will display.
4. Use the following table to enter data in the Snowflake panel:

   Connection Fields

   Field	Description
   Connection Name	Specify the connection name. This is the name that will show up on the left side menu once saved. When creating queries or formulas, this is the connection name that will display.
   Snowflake Account	Specify the Snowflake Account. For more information, see Snowflake Account Documentation.
   Database Name	Specify the Snowflake Database Name. For more information, see Show Databases Documentation.
   Schema Name	Specify the Snowflake Schema Name. For more information, see Show Schemas Documentation.
   Authentication Type	Select the authentication method. Two options are available: Browser SSO or Key Pair.

   Authentication Type: Browser SSO

   When Browser SSO is selected:

   

   Field	Description
   User Name	Specify the user name.
   SSO Login	Prompts the user to log in via SSO to validate the connection. Login frequency depends on cached token expiration times defined by the Snowflake SSO Admin.

   Authentication Type: Key Pair

   When Key Pair is selected:

   

   For information about Key Pair authentication, see Snowflake Key Pair Authentication Documentation.

   For instructions on generating keys, see Generate Keys for Snowflake.

   

   Field	Description
   User Name	Specify the user name.
   Private Key File	Load or copy the Private Key File. Copy the entire key including the header and footer.
   Key Password	Specify the Key Password for encrypted Private Keys. Leave blank for non-encrypted private keys.

5. Saving and Testing: Click Save to save the connection.

6. Click Test to confirm a successful connection.

   Button	Function
   Test	Displays a message in the Results field indicating whether or not the connection was successful.