Snowflake Connected System

Connect to your Snowflake environment to query and manage data from Appian. The Snowflake connected system stores your Snowflake authentication credentials and account information. Create a Snowflake connected system to use a Snowflake database as the source of a record type.

For information that pertains to all connected systems, see Connected System Object.

Create a Snowflake connected system

To create a Snowflake connected system:

1. In your application, go to the Build view.
2. Click NEW > Connected System.
3. From the Create Connected System dialog, select Snowflake Data Source.

4. Configure the properties.

   

   Scroll or drag to pan · ⌘+/⌘− to zoom · Esc to close

5. Click CREATE.

Properties

The Snowflake connected system has the following properties:

Field	Description
Name	The name of the connected system that appears in Appian design objects, such as record types.
Description	Supplemental information about the connected system.
System Logo	An image document used to visually represent the external system being connected to. The logo appears in the integration designer and in the Process Modeler on integrations that connect to this system (using the Call Integration Smart Service). If no document is selected, a default logo is used instead.
Account URL	The URL for your Snowflake account. The Account URL includes your account identifier, which identifies your Snowflake account and region. For example: <ACCOUNT_IDENTIFIER>.snowflakecomputing.com. If you do not know your account identifier, consult your Snowflake administrator.
Warehouse	The default Snowflake warehouse to use for executing queries.
Database	The Snowflake database to connect to.
Role	The Snowflake role to use when connecting. The role determines the access privileges for the session.
Authentication	The authentication method used by this connected system.
Data Source Shortcut	Determines whether to show the connected system as a data source shortcut in the record type configuration.
Shortcut Display Name	The name of the data source shortcut option. The Shortcut Display Name property only appears when Data Source Shortcut is selected.

Authentication

Snowflake does not support traditional basic authentication (username and password). The following authentication methods are available:

• Programmatic Access Token (PAT): Select Programmatic Access Token and provide your Snowflake programmatic access token as the password.
• OAuth 2.0 Client Credentials: Select OAuth 2.0 Client Credentials Grant for secure enterprise connectivity.

Feedback