@devries-cameron20 / composio Mirror · read-only
Fork 0

Composio powers 1000+ toolkits, tool search, context management, authentication, and a sandboxed workbench to help you build AI agents that turn intent into action.

Mirrored from https://github.com/Camo67/composio.git

Synced Nov 21, 06:00 UTC

next
md 65 lines 3.88 KB
Rendered Raw
1 ## How do I set up custom OAuth credentials for Snowflake?
2
3 Snowflake has no Composio-managed OAuth app, so you create an OAuth security integration in your own Snowflake account and use its credentials in Composio. Snowflake has no web form for this; you create the integration with SQL.
4
5 ### Create the Snowflake OAuth integration
6
7 You need the `ACCOUNTADMIN` role, or a role with the privilege to create integrations.
8
9 1. Sign in to [Snowflake](https://app.snowflake.com/) and open a SQL worksheet.
10
11 ![Snowflake sign-in page asking for the account identifier](/images/toolkits/snowflake/sign-in.webp)
12 2. Run this command to create a confidential OAuth client that points at Composio:
13
14 ```sql
15 CREATE SECURITY INTEGRATION oauth_custom_all_roles
16 TYPE = oauth
17 ENABLED = true
18 OAUTH_CLIENT = custom
19 OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
20 OAUTH_REDIRECT_URI = 'https://backend.composio.dev/api/v1/auth-apps/add'
21 OAUTH_ISSUE_REFRESH_TOKENS = TRUE
22 OAUTH_REFRESH_TOKEN_VALIDITY = 7776000;
23 ```
24
25 `OAUTH_REDIRECT_URI` must exactly match the `oauth_redirect_uri` field in your Composio auth config.
26
27 ![Snowflake worksheet with the CREATE SECURITY INTEGRATION command and the Composio redirect URI](/images/toolkits/snowflake/create-security-integration.webp)
28 3. Run `DESC SECURITY INTEGRATION oauth_custom_all_roles;` and copy the `OAUTH_CLIENT_ID` value.
29 4. Run the following command and copy the `OAUTH_CLIENT_SECRET` value from the result:
30
31 ```sql
32 SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('OAUTH_CUSTOM_ALL_ROLES') AS SECRETS;
33 ```
34
35 ### Create the auth config in Composio
36
37 1. In the Composio dashboard, go to **Auth Configs**, click **Create Auth Config**, and select **Snowflake**.
38
39 ![Composio Auth Configs page with the Create Auth Config button](/images/toolkits/snowflake/create-auth-config.webp)
40
41 ![Composio toolkit picker with Snowflake selected](/images/toolkits/snowflake/select-toolkit.webp)
42 2. Keep the authentication type as **OAuth2**.
43
44 ![Snowflake auth config form with OAUTH2 selected and the refresh_token scope](/images/toolkits/snowflake/oauth2-auth-method.webp)
45 3. Paste the `OAUTH_CLIENT_ID` into **Client ID** and the `OAUTH_CLIENT_SECRET` into **Client Secret**, then click **Create Auth Config**.
46
47 ![Snowflake auth config with redacted client ID and secret and the Composio redirect URI](/images/toolkits/snowflake/client-credentials.webp)
48 4. Click **Connect Account** and enter your Snowflake account identifier in `orgname-accountname` format, for example `myorg-account123`. In Snowsight, click your account in the bottom left and choose **View account details** to find it.
49 5. Sign in to Snowflake, approve access, and confirm the account shows as **Active**.
50
51 See [Custom auth configs](/docs/auth-configuration/custom-auth-configs) for the general flow.
52
53 ### Scopes
54
55 The default auth config requests the `refresh_token` scope, so Composio can refresh access without asking the user to sign in again. Snowflake roles, not OAuth scopes, decide which databases, schemas, and warehouses the connection can use.
56
57 ## How do I configure roles and permissions for Snowflake?
58
59 Ensure the OAuth app and Snowflake roles, databases, and schemas are configured correctly for the integration.
60
61 ## Does Snowflake require per-user OAuth credentials?
62
63 Yes. Snowflake OAuth is tied to the user's Snowflake account and security integration. There is not a single generic Snowflake OAuth app that can safely cover every account, role setup, redirect URI, and security policy.
64
65 For a production integration, each Snowflake user should bring the OAuth client credentials from the security integration configured in their own Snowflake account. Create a Composio auth config with those credentials, then let the user connect with the account identifier and permissions for that Snowflake account. This keeps the connection aligned with the user's Snowflake roles, databases, schemas, and refresh-token policy.