Statsig

Statsig Warehouse Connections API

The Warehouse Connections API from Statsig — 1 operation(s) for warehouse connections.

GitHub OpenAPI

Operations 1

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

PATCH /console/v1/wh_connections Update warehouse connection parameters · Update Warehouse Connection Parameters #
Ask an LLM
“Where do I update the credentials for our warehouse connection?”
“Can I change connection settings for Snowflake or BigQuery via the API?”
Tell an agent
Update the Snowflake connection parameters to {snowflake}.
Set the BigQuery connection settings to {bigquery}.

Documentation

📖
Documentation
https://docs.statsig.com/console-api/introduction

Specifications

⚙
OpenAPI
https://artifacts.apis.io/statsig/openapi/statsig-warehouse-connections-api-openapi.yml

Other Resources

🔗
ToolCrosswalk
https://artifacts.apis.io/statsig/mcp/statsig-tool-crosswalk.yml
🔗
ErrorCatalog
https://artifacts.apis.io/statsig/errors/statsig-problem-types.yml
🔗
DataModel
https://artifacts.apis.io/statsig/data-model/statsig-data-model.yml
🔗
Conventions
https://artifacts.apis.io/statsig/conventions/statsig-conventions.yml

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/statsig:statsig-warehouse-connections-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

statsig-warehouse-connections-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Console Warehouse Connections API
  description: The "Console API" is the CRUD API for performing the actions offered on console.statsig.com without needing to go through the web UI.
  version: 20240601.0.0
  contact: {}
servers:
- url: https://statsigapi.net
tags:
- name: Warehouse Connections
paths:
  /console/v1/wh_connections:
    patch:
      summary: Update Warehouse Connection Parameters
      parameters: []
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/WhConnectionUpdateDto'
      responses:
        '200':
          description: Connection updated successfully
          content:
            application/json:
              schema:
                properties:
                  message:
                    type: string
                example:
                  message: Connection updated successfully
              example:
                message: Connection updated successfully
        '403':
          description: Insufficient permissions.
          content:
            application/json:
              schema:
                type: object
                properties:
                  status:
                    type: integer
                    enum:
                    - 403
                  message:
                    type: string
                required:
                - status
                - message
              examples:
                Forbidden resource:
                  value:
                    status: 403
                    message: Forbidden. The request was valid, but the server is refusing action. You might not have the necessary permissions to access the resource.
      tags:
      - Warehouse Connections
      security:
      - STATSIG-API-KEY: []
      operationId: patchConsoleV1WhConnections
      x-operation-id-source: derived
components:
  schemas:
    WhConnectionUpdateDto:
      type: object
      properties:
        databricks:
          type: object
          properties:
            host:
              type: string
            path:
              type: string
            accessToken:
              type: string
            stagingDatabase:
              type: string
              description: 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:
              type:
              - string
              - 'null'
            consoleComputePath:
              type:
              - string
              - 'null'
              description: An optional separate path that Statsig will use to run interactive queries made from the Console.
        snowflake:
          type: object
          properties:
            accountName:
              type: string
            serviceUserName:
              type: string
            serviceUserPassword:
              type: string
            privateKey:
              type:
              - string
              - 'null'
            keyPassPhrase:
              type:
              - string
              - 'null'
            stagingDatabaseName:
              type: string
              description: The database containing the staging schema
            stagingSchemaName:
              type: string
              description: 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:
              type: string
              description: The warehouse that Statsig will use to run queries. Must be a warehouse that the service user has access to.
            consoleComputeWarehouse:
              type:
              - string
              - 'null'
              description: An optional warehouse that Statsig will use to run interactive queries made from the Console.
        bigquery:
          type: object
          properties:
            privateKey:
              type: string
              description: Private key for a first-party service account to use for the BigQuery connection.
            project:
              type: string
              description: The project that Statsig will use to run queries.
            consoleComputeProject:
              type: string
              description: An optional project that Statsig will use to run interactive queries made from the Console.
            stagingDataset:
              type: string
              description: 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:
          type: object
          properties:
            host:
              type: string
              description: The name of the Redshift cluster.
            port:
              type: number
              description: The port of the Redshift cluster.
              format: double
            database:
              type: string
              description: The database of the Redshift cluster.
            username:
              type: string
              description: The username of the admin of the Redshift cluster.
            password:
              type: string
              description: The password of the admin.
            stagingSchema:
              type: string
              description: The schema to use for staging tables.
            useSshTunnel:
              type: boolean
            sshUsername:
              type: string
            sshPort:
              type: number
              format: double
            sshHost:
              type: string
            sshPrivateKey:
              type: string
            sshPublicKey:
              type: string
            verifyCA:
              type: boolean
              description: Whether to verify CA over SSL.
            useAssumeRole:
              type: boolean
              description: Whether to use an IAM role to connect to the Redshift cluster.
            roleArn:
              type: string
            region:
              type: string
              description: The AWS region of your Redshift cluster. Needed if using an IAM Role to connect.
        athena:
          type: object
          properties:
            region:
              type: string
              description: The AWS region of your resources.
            bucket:
              type: string
              description: The name of your S3 bucket.
            dataCatalog:
              type: string
              description: The name of your Athena Data Source/Catalog.
            useCatalogInQueryContext:
              type: boolean
              description: 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:
              type: string
              description: The name of the database to use for staging tables.
            queryResultLocation:
              type: string
              description: The S3 location for Athena query results.
            workgroup:
              type: string
              description: The name of the Athena Workgroup to use for query results.
            roleArn:
              type: string
  securitySchemes:
    STATSIG-API-KEY:
      type: apiKey
      name: STATSIG-API-KEY
      in: header