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.


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


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.


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.


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.


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.


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.


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.


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.


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.pubFor an unencrypted key, use:
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt2. 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 theSHA256:prefix.
Actions
Action | Description |
| Add a single new row of data to a Snowflake table by mapping values to its columns. |
| Modify existing rows in a table that match a filter condition, setting new values for one or more columns. |
| Insert new rows or update existing ones in a single step, matched on a key column. |
| Remove rows from a table that match a specified filter condition. |
| Apply inserts, updates and deletes to a target table in one operation based on a source dataset and matching rules (SQL MERGE). |
| Efficiently write a batch of rows into a table, typically used in data-pipeline/replication flows. |
| Read rows from a table, with optional filters, ordering and a row limit — without writing SQL. |
| Read data by providing your own SELECT statement for full query control. |
| Run any single SQL statement (DML or DDL) against Snowflake and return the result. |
| Run several SQL statements in sequence within one call. |
| Submit a long-running custom query asynchronously and retrieve the result once it completes. |
| Load large volumes of data from a Snowflake stage into a table using high-throughput COPY INTO. |
| Run a query and export its result set as a CSV file. |
| Upload a file to a Snowflake internal stage so it can be loaded into a table. |
| Retrieve a file stored in a Snowflake internal stage. |