---
title: "Update Warehouse Connection Parameters"
method: PATCH
path: "/console/v1/wh_connections"
tags: ["Warehouse Connections"]
---

# Update Warehouse Connection Parameters

`PATCH /console/v1/wh_connections`

## Request body

- WhConnectionUpdateDto
  - `databricks` object
    - `host` string
    - `path` string
    - `accessToken` string
    - `stagingDatabase` string — Statsig will use this Database to save intermediate tables in the experimentation pipeline. Must be a database that the service user has write access to.
    - `oauthClientID` string, nullable
    - `consoleComputePath` string, nullable — An optional separate path that Statsig will use to run interactive queries made from the Console.
  - `snowflake` object
    - `accountName` string
    - `serviceUserName` string
    - `serviceUserPassword` string
    - `privateKey` string, nullable
    - `keyPassPhrase` string, nullable
    - `stagingDatabaseName` string — The database containing the staging schema
    - `stagingSchemaName` string — Statsig will use this Schema to save intermediate tables in the experimentation pipeline. Must be a schema that the service user has write access to.
    - `computeWarehouse` string — The warehouse that Statsig will use to run queries. Must be a warehouse that the service user has access to.
    - `consoleComputeWarehouse` string, nullable — An optional warehouse that Statsig will use to run interactive queries made from the Console.
  - `bigquery` object
    - `privateKey` string — Private key for a first-party service account to use for the BigQuery connection.
    - `project` string — The project that Statsig will use to run queries.
    - `consoleComputeProject` string — An optional project that Statsig will use to run interactive queries made from the Console.
    - `stagingDataset` string — Statsig will use this dataset to save intermediate tables in the experimentation pipeline. Must be a dataset that the service user has write access to.
  - `redshift` object
    - `host` string — The name of the Redshift cluster.
    - `port` number, double — The port of the Redshift cluster.
    - `database` string — The database of the Redshift cluster.
    - `username` string — The username of the admin of the Redshift cluster.
    - `password` string — The password of the admin.
    - `stagingSchema` string — The schema to use for staging tables.
    - `useSshTunnel` boolean
    - `sshUsername` string
    - `sshPort` number, double
    - `sshHost` string
    - `sshPrivateKey` string
    - `sshPublicKey` string
    - `verifyCA` boolean — Whether to verify CA over SSL.
    - `useAssumeRole` boolean — Whether to use an IAM role to connect to the Redshift cluster.
    - `roleArn` string
    - `region` string — The AWS region of your Redshift cluster. Needed if using an IAM Role to connect.
  - `athena` object
    - `region` string — The AWS region of your resources.
    - `bucket` string — The name of your S3 bucket.
    - `dataCatalog` string — The name of your Athena Data Source/Catalog.
    - `useCatalogInQueryContext` boolean — Whether to specify the Data Catalog when making calls to your Athena instance via the SDK. This can be helpful to avoid needing to specify the same catalog in SQL for all queries.
    - `database` string — The name of the database to use for staging tables.
    - `queryResultLocation` string — The S3 location for Athena query results.
    - `workgroup` string — The name of the Athena Workgroup to use for query results.
    - `roleArn` string

## Response `200`

Connection updated successfully

- object
  - `message` string

## Other responses

- `403` — Insufficient permissions.

---

[API](https://skmtc.net/statsig/apis/console-api.md) · [All operations](https://skmtc.net/statsig/apis/console-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/statsig/console-api/revisions/3189f450c93b/schema)