Executes one or more SQL statements in your Snowflake DB.

Retrieve the current status of a executed statement from Snowflake.

Snowflake will use OAuth 2.0 for authentication and making API calls on behalf of customers.

Follow these steps to set up an OAuth integration on your snowflake. More information for these steps can be found here https://docs.snowflake.com/en/user-guide/oauth-custom

1. Login to Snowflake and create a worksheet to set a new integration.
2. Create a new security integration by copying the following SQL statement into Snowflake and selecting the **Play** button at the top right of the screen. Make sure to change the `INTEGRATIONNAME` to something you will remember

```sql
CREATE SECURITY INTEGRATION
  INTEGRATIONNAME
  TYPE = OAUTH
  OAUTH_CLIENT = CUSTOM
  OAUTH_REDIRECT_URI = 'https://oauth2.prismatic.io/callback'
  OAUTH_CLIENT_TYPE = 'PUBLIC'
```

3. Run The following SQL statement to get your Auth URL, Token URL, and Client ID. Change `INTEGRATIONNAME` to the name you used during the create statement.

```sql
DESCRIBE INTEGRATION INTEGRATIONNAME
```

4. Run the following SQL statement to get your Client Secret.

   a. Its important that you use the secret listed as AUTH_CLIENT_SECRET from the return in Prismatic

```sql
SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('INTEGRATIONNAME')
```

5. Run the following SQL statement to enable the Integration.

```sql
ALTER SECURITY INTEGRATION INTEGRATIONNAME SET ENABLED = TRUE
```

6. Enter your Authorization URL, Token URL, Client ID, and Client Secret into Prismatic.

   a. Once attempting to authenticate its important to note that users with the roles of `ACCOUNTADMIN`, `SECURITYADMIN`, and `ORGADMIN` will receive an “invalid consent request error” message as snowflake blocks these roles by default. We suggest authenticating with a different user without these roles assigned.


Set up key-pair authentication. For more information refer to the following [guide](https://docs.snowflake.com/en/developer-guide/sql-api/authenticating#using-key-pair-authentication).

As part of this process, you must:

  1. Generate a public-private key pair. The generated private key should be in a file (e.g. named rsa_key.p8).
  2. Assign the public key to your Snowflake user. After you assign the key to the user, run the
  DESCRIBE USER command. In the output, the RSA_PUBLIC_KEY_FP property should be set to the fingerprint of the public key assigned to the user.


Snowflake is a cloud data platform. Use the Snowflake component to access and update data in a Snowflake Database.

[Snowflake](https://www.snowflake.com/) is a cloud data platform. Use the Snowflake component to access and update data in a Snowflake Database.

Action Name	Action Description
Execute SQL	Executes one or more SQL statements in your Snowflake DB.
Get Statement Handle	Retrieve the current status of a executed statement from Snowflake.

Snowflake Connector

Integrate with customers’ other SaaS apps, fast

About the Snowflake Connector

Actions

Triggers

Ready to get started?