Unify Integrations
Logo
Snowflake

Snowflake

Logo

3 mins READ

Integrating your application with Snowflake transforms your data warehousing and analytics capabilities, offering a cloud-native platform for scalable, flexible, and high-performance data processing.

Connecting your application to a Snowflake account allows you to interact with Snowflake's data warehousing capabilities directly from your application.

Authentication

OAuth with Client Credentials

Before you begin, make sure you have the following information:

Connection Name: Select a descriptive name for your Snowflake connection. This identifier will help you recognize the connection within your application or integration settings. For example, you might choose something like "MyAppSnowflakeDataWarehouse"

Instance URL : The web address of your Snowflake account, formatted as https://<account_identifier>.snowflakecomputing.com. Find your instance url under Admin → Accounts (the Locator field) in Snowflake.

Frame 4601.png
Frame 4601.png

Client ID and Secret: Fetch the Client ID and Secret for your Snowflake account basis this documentation.

Frame 4605.png
Frame 4605.png

Warehouse Name: It is the compute resource that executes SQL queries. To view your warehouses, go to the left sidebar and click "Admin" then click "Warehouses". Here, you'll see a list of warehouse names and their details.

Frame 4602.png
Frame 4602.png

Database Name: It is another crucial piece of information. This is the container for your schemas and tables. To view your databases, go to the left sidebar and click "Data" then click "Databases". You'll see a list of all available databases.

Frame 4604.png
Frame 4604.png

Schema Name: To view schemas, first select a database, then click "Schemas" within that database. You'll see a list of all schemas in the selected database.

Frame 4603.png
Frame 4603.png

JWT

Before you begin, make sure you have the following information:

Connection Name: Select a descriptive name for your Snowflake connection. This identifier will help you recognize the connection within your application or integration settings. For example, you might choose something like "MyAppSnowflakeDataWarehouse"

Instance URL : The web address of your Snowflake account, formatted as https://<account_identifier>.snowflakecomputing.com. Find your account identifier under Admin → Accounts (the Locator field) in Snowflake.

Frame 4601.png
Frame 4601.png

Warehouse Name: It is the compute resource that executes SQL queries. To view your warehouses, go to the left sidebar and click "Admin" then click "Warehouses". Here, you'll see a list of warehouse names and their details.

Frame 4602.png
Frame 4602.png

Database Name: It is another crucial piece of information. This is the container for your schemas and tables. To view your databases, go to the left sidebar and click "Data" then click "Databases". You'll see a list of all available databases.

Frame 4604.png
Frame 4604.png

Schema Name: To view schemas, first select a database, then click "Schemas" within that database. You'll see a list of all schemas in the selected database.

Frame 4603.png
Frame 4603.png

Username: The Snowflake user the connection authenticates as. Role: The role used for requests made with this connection (e.g. SYSADMIN). Leave blank to use the user’s default role. The role must have USAGE on the warehouse and access to the database and schema.

Setup steps:

1. Generate an RSA key pair: On your machine (OpenSSL). An encrypted key is recommended - you will be prompted for a passphrase:

openssl genrsa 2048 | openssl pkcs8 -topk8 -v2 des3 -inform PEM -out rsa_key.p8
openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub

For an unencrypted key, use:

openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt

2. Assign the public key to your snowflake user: Link

Before assigning remove the BEGIN/END header lines and line breaks from rsa_key.pub , and run

ALTER USER <your_user> SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...IDAQAB';

3. Get the fingerprint:

DESC USER <your_user>;   -- read the RSA_PUBLIC_KEY_FP value (SHA256:...)

4. Enter the common fields plus the JWT fields, then save.

Field descriptions:

  • Private Key: The full contents of rsa_key.p8, including the BEGIN/END PRIVATE KEY lines.

  • Encryption Password: The passphrase set when generating the key. Leave blank if the key is unencrypted.

  • Public Key Fingerprint: SHA256 fingerprint of the Snowflake user’s registered public key, without the SHA256: prefix.

Actions

Action

Description

Insert a row

Add a single new row of data to a Snowflake table by mapping values to its columns.

Update rows

Modify existing rows in a table that match a filter condition, setting new values for one or more columns.

Upsert rows

Insert new rows or update existing ones in a single step, matched on a key column.

Delete rows

Remove rows from a table that match a specified filter condition.

Merge rows

Apply inserts, updates and deletes to a target table in one operation based on a source dataset and matching rules (SQL MERGE).

Replicate batch of rows

Efficiently write a batch of rows into a table, typically used in data-pipeline/replication flows.

Select rows

Read rows from a table, with optional filters, ordering and a row limit — without writing SQL.

Select rows using custom SQL

Read data by providing your own SELECT statement for full query control.

Execute SQL

Run any single SQL statement (DML or DDL) against Snowflake and return the result.

Execute multiple SQL

Run several SQL statements in sequence within one call.

Run long query using custom SQL

Submit a long-running custom query asynchronously and retrieve the result once it completes.

Bulk load data to table from stage

Load large volumes of data from a Snowflake stage into a table using high-throughput COPY INTO.

Export query result in CSV file

Run a query and export its result set as a CSV file.

Upload file to internal stage

Upload a file to a Snowflake internal stage so it can be loaded into a table.

Download file from internal stage

Retrieve a file stored in a Snowflake internal stage.