> ## Documentation Index
> Fetch the complete documentation index at: https://api-docs.select.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Get a Databricks connection

> One Databricks connection by id.



## OpenAPI

````yaml https://api.select.dev/v2/openapi.json get /databricks-connections/{databricks_connection_id}
openapi: 3.1.0
info:
  title: SELECT API (v2)
  version: 0.1.0
servers:
  - url: https://api.select.dev/v2
    description: SELECT API v2
security: []
paths:
  /databricks-connections/{databricks_connection_id}:
    get:
      tags:
        - databricks-connections
      summary: Get a Databricks connection
      description: One Databricks connection by id.
      operationId: >-
        get_databricks_connection_route_databricks_connections__databricks_connection_id__get
      parameters:
        - name: databricks_connection_id
          in: path
          required: true
          schema:
            type: string
            title: Databricks Connection Id
        - name: x-tenant-id
          in: header
          required: true
          schema:
            type: string
            description: The organization ID the request is scoped to.
            title: X-Tenant-Id
          description: The organization ID the request is scoped to.
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabricksConnection'
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '405':
          $ref: '#/components/responses/MethodNotAllowed'
        '408':
          $ref: '#/components/responses/RequestTimeout'
        '422':
          $ref: '#/components/responses/ValidationFailed'
        '429':
          $ref: '#/components/responses/RateLimited'
        '500':
          $ref: '#/components/responses/InternalError'
        '503':
          $ref: '#/components/responses/ServiceUnavailable'
      security:
        - HTTPBearer: []
components:
  schemas:
    DatabricksConnection:
      properties:
        id:
          type: string
          title: Id
          description: The unique identifier of the connection.
          readOnly: true
          x-terraform-computed: true
        etag:
          type: string
          title: Etag
          description: >-
            Opaque strong ETag for this connection's configuration. Matches the
            `ETag` response header, and is what `If-Match` requires on a write.
            It changes whenever a configurable field on the connection changes.
          readOnly: true
          x-terraform-computed: true
        name:
          type: string
          title: Name
          description: Display name for the connection, as shown throughout SELECT.
        connection_id:
          type: string
          title: Connection Id
          description: >-
            Identifier of the connection resource this Databricks connection
            belongs to (see `GET /v2/connections/{connection_id}`). Distinct
            from `id`, which identifies this Databricks connection specifically.
          readOnly: true
          x-terraform-computed: true
        databricks_account_id:
          type: string
          title: Databricks Account Id
          description: The Databricks account SELECT reads usage and spend for.
        primary_workspace_url:
          type: string
          title: Primary Workspace Url
          description: >-
            URL of the workspace SELECT connects through to read the account's
            system tables. One account can have several connections, one per
            region, each reading through a workspace in its own region.
        warehouse_id:
          type: string
          title: Warehouse Id
          description: The SQL warehouse in that workspace SELECT runs its queries on.
        metastore:
          anyOf:
            - type: string
            - type: 'null'
          title: Metastore
          description: >-
            The Unity Catalog metastore this connection reads, in
            `cloud:region:id` form. Null until the first successful validation
            resolves it.
          readOnly: true
          x-terraform-computed: true
        workspace_ids:
          items:
            type: string
          type: array
          title: Workspace Ids
          description: >-
            The workspaces SELECT has found activity in for this account and
            region. Accumulated as they are discovered, so a workspace that has
            gone quiet stays listed. Empty until the first successful discovery.
          readOnly: true
          x-terraform-computed: true
        sync_enabled:
          type: boolean
          title: Sync Enabled
          description: Whether SELECT is currently syncing data for this connection.
        query_sanitization_enabled:
          type: boolean
          title: Query Sanitization Enabled
          description: Whether query text is sanitized before SELECT stores it.
        added_by_email:
          anyOf:
            - type: string
            - type: 'null'
          title: Added By Email
          description: >-
            Email address of the person who added the connection. Null when it
            was not added by a person.
          readOnly: true
          x-doit-confidentiality: customer-data
          x-doit-pii: true
          x-terraform-computed: true
        last_successful_sync_time:
          anyOf:
            - type: string
            - type: 'null'
          title: Last Successful Sync Time
          description: >-
            When SELECT last completed a sync for this connection. Null before
            the first one succeeds.
          readOnly: true
          x-terraform-computed: true
        create_time:
          type: string
          title: Create Time
          description: When the connection was added.
          readOnly: true
          x-terraform-computed: true
        update_time:
          type: string
          title: Update Time
          description: When the connection was last changed.
          readOnly: true
          x-terraform-computed: true
      type: object
      required:
        - id
        - etag
        - name
        - connection_id
        - databricks_account_id
        - primary_workspace_url
        - warehouse_id
        - workspace_ids
        - sync_enabled
        - query_sanitization_enabled
        - create_time
        - update_time
      title: DatabricksConnection
      description: A connection to one Databricks account.
    ProblemDetail:
      additionalProperties: true
      description: >-
        RFC 9457-style error payload, served as ``application/problem+json``.


        ``code`` is the stable, machine-readable identifier — consumers branch
        on it,

        never on ``title``. ``type`` stays ``about:blank``: we keep no per-error

        documentation pages. There is no ``instance``/request-id member (we
        don't run

        access logs). See the flat error-code catalogue in §4 of the standards
        doc.
      properties:
        type:
          default: about:blank
          title: Type
          type: string
        title:
          type: string
          title: Title
        status:
          title: Status
          type: integer
        detail:
          title: Detail
          type: string
        code:
          title: Code
          type: string
        retryable:
          title: Retryable
          type: boolean
        details:
          anyOf:
            - items:
                additionalProperties: true
                type: object
              type: array
            - type: 'null'
          default: null
          title: Details
      required:
        - title
        - status
        - detail
        - code
        - retryable
      title: ProblemDetail
      type: object
  responses:
    BadRequest:
      description: Bad request
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
    Unauthorized:
      description: Unauthorized
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
      headers:
        WWW-Authenticate:
          description: Authentication challenge for the requested resource.
          required: true
          schema:
            type: string
    Forbidden:
      description: Forbidden
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
    NotFound:
      description: Not found
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
    MethodNotAllowed:
      description: Method not allowed
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
      headers:
        Allow:
          description: HTTP methods supported by the requested resource.
          required: true
          schema:
            type: string
    RequestTimeout:
      description: Request Timeout
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
    ValidationFailed:
      description: Validation failed
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
    RateLimited:
      description: Rate limited
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
      headers:
        Retry-After:
          description: Number of seconds to wait before retrying the request.
          required: true
          schema:
            type: integer
            minimum: 0
    InternalError:
      description: Internal error
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
    ServiceUnavailable:
      description: Service unavailable
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/ProblemDetail'
      headers:
        Retry-After:
          description: Number of seconds to wait before retrying the request.
          required: true
          schema:
            type: integer
            minimum: 0
  securitySchemes:
    HTTPBearer:
      type: http
      description: Organization API key (sl_…).
      scheme: bearer

````