--- title: "Integrating with Snowflake" slug: "integrating-with-snowflake" tags: ["snowflake", "Database Tables"] updated: 2026-03-30T17:12:42Z published: 2026-03-30T17:12:42Z --- > ## Documentation Index > Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt > Use this file to discover all available pages before exploring further. # Integrating with Snowflake ## Overview **Snowflake** is a data warehousing service that can support a high amount of workloads simultaneously. By integrating with Snowflake, users can access Snowflake's ability to store and share large amounts of data, and Decisions' library of automated Workflows, Steps, Reports, and more. Starting in v9.13, Snowflake drivers are included in Decisions container images. Users with container environments can now integrate with Snowflake databases. Versions v9.12 and below do not support container integration with Snowflake. ### Prerequisites: - Snowflake ODBC driver from the [Snowflake Documentation site](https://docs.snowflake.com/en/user-guide/odbc-download.html). --- ## Configuration 1. Navigate to**Integrations > Databases** and click CREATE CONNECTION. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-16_12h11_06.png) 2. In the **Database Integration** dialog, define a **Connection****Name**. From the**Database Type** dropdown, select **ODBC**. 3. Enter the connection string to connect to the Snowflake database. Click PICK OR CREATE ODBC DB TYPE and select **Pick Existing**. Case SensitiveAll values in the connection string are case sensitive. This includes the Snowflake database name, schema, role, etc.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-16_12h15_10.png) ```actionscript Driver={SnowflakeDSIIDriver}; Server=abc12345.dataCenter.snowflakecomputing.com; account=abc12345; Database=SNOWFLAKE_SAMPLE_DATA; Uid=snowflakeUserID; Pwd=snowflakePassword; schema=public; warehouse=COMPUTE_WH; role=SYSADMIN; ``` | Driver={SnowflakeDSIIDriver}; | Reference the ODBC driver by name. | | --- | --- | | Server=abc12345.dataCenter.snowflakecomputing.com; account=abc12345; | The account ID and datacenter location provided by Snowflake. | | Database=SNOWFLAKE_SAMPLE_DATA; | The database name. | | Uid=snowflakeUserID; Pwd=snowflakePassword; | Snowflake username and password. | | schema=public; warehouse=COMPUTE_WH; role=SYSADMIN; | Data usage details. | 4. Navigate to **ALL > DatabaseDefinitionWizard,** select **Snowflake**, and click **PICK**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-16_12h18_10.png) 5. Enable **Specify Private****Key**to configure key pair authentication. - **Private Key**: Upload the private key file associated with the Snowflake user. - **Private Key File Password**: Provide the password for the private key file, if applicable. - The private key information is appended to the connection string automatically.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1774559576392.png) 6. Click **TEST** to test the database connection. If the Test Status is Success, click **OK** to save. Selecting ODBC Query Connections in the Query EditorAs of the v9.1 release, ODBC Connections, such as Snowflake, are no longer selectable in the Query Editor. Query Integration (Add Query) will continue to be supported. For more information, please visit our [Query Editor](https://documentation.decisions.com/docs/query-editor?highlight=snowflake#feature-changes) Documentation. --- ## Communicate with the Integrated Table A Flow can be created to demonstrate how to communicate with the [Integrated Database Table](https://documentation.decisions.com/v9/docs/integrate-with-database-table) using the system-generated steps in a Workflow process. The steps for the integrated table can be found under **Integration > Database > [Integrated Database Name] > [Integrated Table Name]**in the Flow Designer. ## Special Query Characters Snowflake query commands can be viewed [here](https://docs.snowflake.com/en/sql-reference/constructs). | **Character** | **Function** | | --- | --- | | ? | Specify a parameter. ? takes the parameter order so that a user can re-order parameters accordingly. Each ? is a different parameter. The field must be specified in the INPUT PARAMETERS field. Example screenshots are below. | | * | The output should include all columns of the specified object, or all columns of all objects if * is not qualified with an object name or alias. | | $$$$ | Unlimited non-negative integer constant | | ' ' | Empty string treated as 0. | MATCH_RECOGNIZE | **Character** | **Function** | | --- | --- | | <^> | Start of partition | | <$> | End of partition | | + | Quantifier - 1 or more | | * | Quantifier - 0 or more | | ? | Quantifier - 0 or 1 | | {n} | Quantifier - Exactly n | | {n, } | Quantifier - n or more | | {,m} | Quantifier - 0 to m | | {n,m} | Quantifier - n to m | | ... ... | Operators - Concatenation | | {- ... -} | Operators - Exclusion | | ( ... ) | Operators - Grouping | | PERMUTE(..., ...) | Operator - Permution | | ... \| ... | Operator - Alternative | WHERE | **Character** | **Function** | | --- | --- | | + | Used to make joins into outer joins | --- #### Specify a Parameter This example returns the first three parameters. CALL sp.example(?,?,?) ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-08-06_14h20_28.png)![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/7.14.23.11.33Snowflake%20Procedure.PNG) --- ## Feature Changes | Description | Version | Release Date | Developer Task | | --- | --- | --- | --- | | Add The Ability To Specify An OAuth token to use with the Snowflake Connection String | 9.22 | March 2026 | [DT-045237] | | Snowflake is now supported in Containers. | [9.13](https://documentation.decisions.com/v99/docs/version-913x-release-notes) | July 2025 | [DT-045073] | For further information on Integrations, visit the [Decisions Forum](https://community.decisions.com/categories/Integrations).