AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents
TypeScript ai-agentai-agent-toolsai-agentsai-agents-frameworkmcpmcp-servermcp-toolsmcpsn8n-alternativeno-code-automationworkflowworkflow-automationworkflows
import {
PieceAuth,
Property,
OAuth2AuthorizationMethod,
AppConnectionType,
} from '@activepieces/pieces-framework';
import {
buildConnectionOptions,
buildCustomAuthOptions,
withConnectionOptions,
} from './common/client';
function optionalString(value: unknown): string | undefined {
return typeof value === 'string' && value.trim() !== '' ? value : undefined;
}
export const snowflakeOAuth2Auth = PieceAuth.OAuth2({
displayName: 'OAuth',
description: `Connect via Snowflake OAuth using a custom security integration.
> **Prerequisite:** You need the \`ACCOUNTADMIN\` role (or a role with the \`CREATE INTEGRATION\` privilege).
---
### Step 1 — Create a security integration
Open a **SQL Worksheet** in your Snowflake console and run:
\`\`\`sql
CREATE SECURITY INTEGRATION "activepieces"
TYPE = OAUTH
OAUTH_CLIENT = CUSTOM
OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
OAUTH_REDIRECT_URI = 'https://cloud.activepieces.com/redirect'
ENABLED = TRUE
OAUTH_ISSUE_REFRESH_TOKENS = TRUE
OAUTH_USE_SECONDARY_ROLES = IMPLICIT;
\`\`\`
> Replace the redirect URI with the one shown on your Activepieces OAuth connection page.
>
> \`OAUTH_USE_SECONDARY_ROLES = IMPLICIT\` lets the access token use any role granted to the user. Without it, the token is bound to the user's default Snowflake role and the **Default Role** field below will be ignored.
---
### Step 2 — Retrieve client credentials
Run the following query to get your **Client ID** and **Client Secret**:
\`\`\`sql
SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('activepieces');
\`\`\`
Copy \`OAUTH_CLIENT_ID\` and \`OAUTH_CLIENT_SECRET\` from the JSON result.
---
### Step 3 — Find your Account Identifier
Click the **account icon** at the bottom-left of the Snowflake console → **View account details**.
Copy the **Account Identifier** (e.g. \`xy12345.us-east-1\` or \`orgname-accountname\`).
---
### Step 4 — Connect
Enter the **Client ID** and **Client Secret** in the Activepieces OAuth2 settings for this connection, fill in the **Account Identifier** below, then click **Connect**.`,
authUrl: 'https://{account}.snowflakecomputing.com/oauth/authorize',
tokenUrl: 'https://{account}.snowflakecomputing.com/oauth/token-request',
scope: ['refresh_token'],
pkce: false,
authorizationMethod: OAuth2AuthorizationMethod.BODY,
required: true,
props: {
account: Property.ShortText({
displayName: 'Account Identifier',
required: true,
description:
'Account icon (bottom-left) → **View account details** → copy the **Account Identifier**. Examples: `xy12345.us-east-1`, `orgname-accountname`.',
}),
database: Property.ShortText({
displayName: 'Default Database',
required: false,
description:
'Optional. Default database for queries. Find names under **Data → Databases**.',
}),
warehouse: Property.ShortText({
displayName: 'Default Warehouse',
required: false,
description:
'Optional. Default virtual warehouse. Find names under **Admin → Warehouses**.',
}),
role: Property.ShortText({
displayName: 'Default Role',
required: false,
description:
'Optional. Default security role. Find names under **Admin → Users & Roles → Roles**.',
}),
},
validate: async ({ auth }) => {
try {
await withConnectionOptions({
options: buildConnectionOptions({
auth: {
type: AppConnectionType.OAUTH2,
access_token: auth.access_token,
props: {
account: String(auth.props?.['account'] ?? ''),
database: optionalString(auth.props?.['database']),
warehouse: optionalString(auth.props?.['warehouse']),
role: optionalString(auth.props?.['role']),
},
},
}),
statementTimeoutSeconds: 60,
fn: (session) => session.query({ sql: 'SELECT CURRENT_USER()' }),
});
return { valid: true };
} catch (e) {
return { valid: false, error: (e as Error).message };
}
},
});
export const snowflakeCustomAuth = PieceAuth.CustomAuth({
displayName: 'Username & Password / Key Pair',
description: `Connect using your Snowflake username with either a **password** or an **RSA private key**.
### Finding your Account Identifier
Click the **account icon** at the bottom-left of the Snowflake console → **View account details**.
Copy the **Account Identifier** (e.g. \`xy12345.us-east-1\` or \`orgname-accountname\`).
---
### Option A — Password
Use your Snowflake username and the password you use to log in at [app.snowflake.com](https://app.snowflake.com).
Your username is shown in the profile section at the top-left of the console, or under **Admin → Users & Roles → Users**.
---
### Option B — Key Pair *(recommended for automation)*
**1. Generate a key pair** (run in your terminal):
\`\`\`bash
# Unencrypted (no passphrase needed)
openssl genrsa 2048 | openssl pkcs8 -topk8 -nocrypt -out rsa_key.p8
openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub
# Encrypted (you will be prompted for a passphrase)
openssl genrsa 2048 | openssl pkcs8 -topk8 -out rsa_key_encrypted.p8
openssl rsa -in rsa_key_encrypted.p8 -pubout -out rsa_key.pub
\`\`\`
**2. Register the public key** with your Snowflake user (run in a SQL Worksheet):
\`\`\`sql
ALTER USER <your_username>
SET RSA_PUBLIC_KEY='<contents of rsa_key.pub, excluding the BEGIN/END lines>';
\`\`\`
**3. Paste the private key** — copy the full contents of \`rsa_key.p8\` (including the \`-----BEGIN PRIVATE KEY-----\` or \`-----BEGIN ENCRYPTED PRIVATE KEY-----\` header and footer) into the **Private Key** field below. Line breaks may be pasted as spaces.`,
props: {
account: Property.ShortText({
displayName: 'Account Identifier',
required: true,
description:
'Account icon (bottom-left) → **View account details** → copy the **Account Identifier**. Examples: `xy12345.us-east-1`, `orgname-accountname`.',
}),
username: Property.ShortText({
displayName: 'Username',
required: true,
description:
'Your Snowflake login name. Shown in the profile section (top-left of the console) or under **Admin → Users & Roles → Users**.',
}),
password: PieceAuth.SecretText({
displayName: 'Password',
description:
'Your Snowflake password *(Option A)*. Leave blank if you are using a Private Key.',
required: false,
}),
privateKey: PieceAuth.SecretText({
displayName: 'Private Key',
description:
'RSA private key in PEM format *(Option B)*. Paste the full contents of your `.p8` file, including the `-----BEGIN PRIVATE KEY-----` and `-----END PRIVATE KEY-----` lines. Leave blank if you are using a Password.',
required: false,
}),
privateKeyPassphrase: PieceAuth.SecretText({
displayName: 'Private Key Passphrase',
description:
'Passphrase for the private key. Only required if you generated an **encrypted** key pair.',
required: false,
}),
database: Property.ShortText({
displayName: 'Default Database',
description:
'Optional. Default database for queries. Find names under **Data → Databases**.',
required: false,
}),
role: Property.ShortText({
displayName: 'Default Role',
description:
'Optional. Default security role. Find names under **Admin → Users & Roles → Roles**.',
required: false,
}),
warehouse: Property.ShortText({
displayName: 'Default Warehouse',
description:
'Optional. Default virtual warehouse. Find names under **Admin → Warehouses**.',
required: false,
}),
},
required: true,
validate: async ({ auth }) => {
if (!auth.password && !auth.privateKey) {
return {
valid: false,
error: 'Either Password or Private Key must be provided.',
};
}
try {
await withConnectionOptions({
options: buildCustomAuthOptions({ props: auth }),
statementTimeoutSeconds: 60,
fn: (session) => session.query({ sql: 'SELECT CURRENT_USER()' }),
});
return { valid: true };
} catch (e) {
return { valid: false, error: (e as Error).message };
}
},
});
export const snowflakeAuth = [snowflakeOAuth2Auth, snowflakeCustomAuth];