---
title: "Snowflake Integration"
description: "Manage Snowflake submit statement, get statement, cancel statement, list databases, list warehouses"
---
The Snowflake integration provides access to manage Snowflake submit statement, get statement, cancel statement, list databases, list warehouses through the Integrate MCP server.

## Installation

The Snowflake integration is included with the SDK:

```typescript
import { snowflakeIntegration } from "integrate-sdk/server";
```

## Setup

### 1. Create a Snowflake OAuth App

1. Create an OAuth application for Snowflake
2. Configure your redirect URI
3. Note your Client ID and Client Secret

### 2. Configure the Integration on Your Server

Add the Snowflake integration to your server configuration. The integration automatically reads `SNOWFLAKE_CLIENT_ID` and `SNOWFLAKE_CLIENT_SECRET` from your environment variables:

```typescript
import { createMCPServer, snowflakeIntegration } from "integrate-sdk/server";

export const { client: serverClient } = createMCPServer({
  apiKey: process.env.INTEGRATE_API_KEY,
  integrations: [
    snowflakeIntegration({
      scopes: ["session:role-any"], // Optional
    }),
  ],
});
```

You can override the environment variables by passing explicit values:

```typescript
snowflakeIntegration({
  clientId: process.env.CUSTOM_SNOWFLAKE_ID,
  clientSecret: process.env.CUSTOM_SNOWFLAKE_SECRET,
      scopes: ["session:role-any"], // Optional
});
```

### 3. Client-Side Usage

The default client automatically includes all integrations. You can use it directly:

```typescript
import { client } from "integrate-sdk";

await client.authorize("snowflake");
const result = await client.snowflake.submitStatement({
  statement_json: "value",
});

console.log(result);
```

If you're using a custom client, add the integration to the integrations array:

```typescript
import { createMCPClient, snowflakeIntegration } from "integrate-sdk";

const customClient = createMCPClient({
  integrations: [snowflakeIntegration()],
});
```

## Configuration Options

<AutoTypeTable
  path="../src/integrations/snowflake.ts"
  name="SnowflakeIntegrationConfig"
/>


## Default Scopes

These defaults are applied unless you override `scopes` in the integration config:

- `session:role-any`

## Tools

### `snowflake_submit_statement`

Submit statement

<AutoTypeTable
  path="generated/tool-params/snowflake.ts"
  name="SnowflakeSubmitStatementParams"
/>

### `snowflake_get_statement`

Get statement

<AutoTypeTable
  path="generated/tool-params/snowflake.ts"
  name="SnowflakeGetStatementParams"
/>

### `snowflake_cancel_statement`

Cancel statement

<AutoTypeTable
  path="generated/tool-params/snowflake.ts"
  name="SnowflakeCancelStatementParams"
/>

### `snowflake_list_databases`

List databases

<AutoTypeTable
  path="generated/tool-params/snowflake.ts"
  name="SnowflakeListDatabasesParams"
/>

### `snowflake_list_warehouses`

List warehouses

<AutoTypeTable
  path="generated/tool-params/snowflake.ts"
  name="SnowflakeListWarehousesParams"
/>

## Notes

- Category: Data & BI
- Authentication mode: OAuth