# Create SQL Warehouse — Databricks

> Creates a new SQL Warehouse in Databricks. See the documentation

- Key: `databricks-create-sql-warehouse`
- Type: Action (Write)
- Version: 0.0.7
- App: Databricks (`databricks`) — https://pipedream.com/apps/databricks.md
- This page (HTML): https://pipedream.com/apps/databricks/actions/create-sql-warehouse
- Hints: open-world
- Source: https://github.com/PipedreamHQ/pipedream/blob/master/components/databricks/actions/create-sql-warehouse/create-sql-warehouse.mjs

## Description

Creates a new SQL Warehouse in Databricks. [See the documentation](https://docs.databricks.com/api/workspace/warehouses/create)

## Props

| Prop | Type | Required | Description |
|---|---|---|---|
| `name` | `string` | Yes | A human-readable name for the warehouse |
| `clusterSize` | `string` | Yes | Size of the cluster |
| `autoStopMinutes` | `integer` | No | Minutes of inactivity before auto-stop. 0 disables auto-stop. Must be 0 or ≥ 10. |
| `minNumClusters` | `integer` | No | Minimum number of clusters to maintain (> 0 and ≤ min(max_num_clusters, 30)). |
| `maxNumClusters` | `integer` | No | Maximum number of clusters for autoscaler (≥ min_num_clusters and ≤ 30). |
| `enablePhoton` | `boolean` | No | Whether the warehouse should use Photon optimized clusters. |
| `enableServerlessCompute` | `boolean` | No | Whether the warehouse should use serverless compute. |
| `warehouseType` | `string` | No | Warehouse type: PRO or CLASSIC. Set PRO + enableServerlessCompute = true to use serverless. |
| `spotInstancePolicy` | `string` | No | Configures whether the warehouse should use spot instances. |
| `channel` | `object` | No | Channel details. Example: { "name": "CHANNEL_NAME_CUSTOM", "dbsql_version": "2023.35" } |
| `tags` | `object` | No | Custom key-value tags for resources associated with this SQL Warehouse. Example: { "environment": "prod", "team": "data-platform" }. |
| `instanceProfileArn` | `string` | No | Deprecated. Instance profile used to pass IAM role to the cluster. |

## Run it

**MCP**

```ts
import { Client } from "@modelcontextprotocol/sdk/client/index.js"
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js"
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const accessToken = await pd.rawAccessToken

const transport = new StreamableHTTPClientTransport(
  new URL("https://remote.mcp.pipedream.net/v3"),
  {
    requestInit: {
      headers: {
        Authorization: `Bearer ${accessToken}`,
        "x-pd-project-id": process.env.PIPEDREAM_PROJECT_ID!,
        "x-pd-environment": "production",
        "x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
        "x-pd-app-slug": "databricks",
      },
    },
  },
)

const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)

const { tools } = await mcp.listTools()

// listTools() hands your model this tool's input schema, so it can
// fill the arguments itself:
const result = await mcp.callTool({
  name: "databricks-create-sql-warehouse",
  arguments: {
    name: "Warehouse Name",
    clusterSize: "Cluster Size",
  },
})
```

**TypeScript**

```ts
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "databricks-create-sql-warehouse",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    databricks: { authProvisionId: "apn_xxxxxxx" },
    name: "Warehouse Name",
    clusterSize: "Cluster Size",
  },
})

console.log(result)
```

**cURL**

```bash
curl -X POST https://api.pipedream.com/v1/connect/{project_id}/actions/run \
  -H "Content-Type: application/json" \
  -H "X-PD-Environment: production" \
  -H "Authorization: Bearer {access_token}" \
  -d '{
    "external_user_id": "{external_user_id}",
    "id": "databricks-create-sql-warehouse",
    "configured_props": {
      "databricks": { "authProvisionId": "apn_xxxxxxx" },
      "name": "Warehouse Name",
      "clusterSize": "Cluster Size"
    }
  }'
```

---

- App: https://pipedream.com/apps/databricks.md · All apps: https://pipedream.com/apps