> ## 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 Snowflake account

> Get a single Snowflake account by id.



## OpenAPI

````yaml https://api.select.dev/v2/openapi.json get /snowflake-accounts/{snowflake_account_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: []
tags:
  - name: metrics
    description: >-
      Query cost and usage data across Snowflake, BigQuery, Databricks and
      Tableau. Each route is `POST /v2/metrics/<model>/query` for one semantic
      model. Every route takes the same body shape and returns the same response
      shape. Each route page gives guidance on when to use the route, and worked
      examples.


      ## Body shape


      | Field | Meaning |

      | --- | --- |

      | `measures` | Aggregates to compute, for example `sum_spend`. |

      | `dimensions` | Fields to group by. Each one is returned on every row. |

      | `filter_expression` | An `and`/`or` tree of filters on dimensions,
      applied before aggregation. |

      | `measure_filters` | Filters on measures, applied after aggregation. |

      | `sort` | The order of the rows: `[{"field": "sum_spend", "direction":
      "desc"}]`. |

      | `limit` | The maximum number of rows. Results are not paginated: `limit`
      cuts the result short, and there is no next page. Omit `limit` to get all
      rows. |

      | `aggregate` | Set `false` to list the rows with no grouping. See
      "Listing rows". |


      v2 accepts only `filter_expression`. The body refuses the legacy `filters`
      list.


      ## Filter on dates


      Filter on the `day` field. Use two filters (both bounds are inclusive):


      ```json

      {"operator": "and", "filters": [
        {"field": "day", "operator": ">=", "value": "2026-08-01"},
        {"field": "day", "operator": "<=", "value": "2026-08-31"}], "limit": 1000}
      ```


      Or use one relative filter: `{"field": "day", "operator": "in range",
      "value": "30D"}`. The values are `{N}D` and `{N}M` (the last N days or
      months, today included), `WTD`, `MTD`, `QTD`, `YTD`, and `LMTD` (the whole
      previous calendar month).


      - Do not filter on `hour`, `week`, `month` or `quarter` to bound a range.
      Filter on `day`, and use the coarser fields as dimensions.

      - A timestamp such as `start_time <= "2026-08-31"` compares to midnight
      and drops most of that day. Use `day`, or `start_time < "2026-09-01"`.

      - A snapshot route (for example `snowflake-storage-summary`) describes the
      current state, and a `day` filter does not bound its size and cost fields.
      On routes that join the snapshot to activity, `day` bounds only the
      activity fields. Each route page says which fields these are.


      ## Which measure is cost


      - `sum_spend` (or `spend`, or `cost` on some routes) is the dollar cost in
      the filtered period. Use it for "how much did we spend".

      - `*_annualized` measures extend the spend of the filtered period to a
      year: a `7D` range gives that week's spend times 365 / 7. They are
      projections, not spend.

      - On snapshot routes, `annual_cost`, `*_monthly_cost` and `*_annual_cost`
      are the current rate extended to a month or a year. A date range does not
      bound them.

      - Do not present any of these run-rates as spend in a period.

      - Databricks routes also give DBUs (for example `sum_task_usage`). DBUs
      are not dollars.


      The `spend` route is the consolidated cost of every platform. Use it for
      totals, trends and breakdowns by service. Use a platform route to explain
      what inside the platform caused the cost.


      ## Text values are case-sensitive


      Filter values must match the stored case. A value in the wrong case
      matches no rows, with no error. For example:


      - On `spend`, `connection_type` is `Snowflake`, `Bigquery` or
      `Databricks`, and `"snowflake"` matches nothing.

      - On `search`, `data-freshness` and `workload-metadata-suggestions`,
      `connection_type` is lowercase: `snowflake`, `bigquery`, `databricks`.

      - On `snowflake-workloads`, most `resource_type` values are lowercase keys
      (`query_pattern`, `dbt`), but the AI types are title case (`Cortex
      Analyst`).


      ## Usage groups


      A usage group set divides cost into named groups, such as departments or
      teams. To group by the groups of one set, name the set in `path`:


      ```json

      {"dimensions": [{"field": "usage_group", "path": ["Department"]}],
      "limit": 1000}

      ```


      `path[0]` is the name of the set, not its ID. A plain `"usage_group"`
      dimension groups by every set at once. The same `{"field": ..., "path":
      [...]}` form reads keys of other semi-structured fields, for example
      workload metadata.


      ## Period over period


      Some routes publish `<measure>_previous_period`, `change_<measure>` and
      `percent_change_<measure>`. These measures need one bounded date range on
      `day`, at the top level of `filter_expression`:


      - Use two bounds on `day`, or one `in range` filter. Do not mix the two
      forms.

      - Do not nest the date filter in a sub-expression, and do not bound the
      range with `month` or `quarter`.

      - The previous period is the same number of days, just before the range.
      For `QTD` on 2026-09-28 (2026-07-01 to 2026-09-28, 90 days), the previous
      period is 2026-04-02 to 2026-06-30, not the previous calendar quarter.


      ## Listing rows


      Set `"aggregate": false` and name only `dimensions` to get the rows as
      they are, for example the individual queries that ran longer than ten
      minutes. If the body also names `measures` or `measure_filters`, the route
      aggregates, with no error. Always set a `limit` on a listing.


      ## Default scoping filters


      Some tables hold more than one kind of row, and the SELECT app filters to
      one kind by default. Each route page names these filters. For example:


      - `snowflake-query-patterns`: `{"field": "resource_type", "operator":
      "in", "values": ["query_pattern"]}`. `bigquery-query-patterns` filters
      `workload_type` to `bigquery_query_pattern`, and
      `databricks-query-patterns` filters `resource_type` to
      `databricks_query_pattern`.

      - `snowflake-dbt`: `{"field": "dbt_node_resource_type", "operator": "=",
      "value": "model"}`. Without it, tests, seeds and snapshots rank with
      models. The same filter applies to `bigquery-dbt-queries` and
      `databricks-dbt-queries`.


      ## Teams


      Send `X-Team-Id` to evaluate a query as a team you belong to. The rows are
      then limited to what the team's roles can reach.


      ## Which route answers which question


      | Question | Route |

      | --- | --- |

      | Total spend, spend trend, spend by platform, service or usage group |
      `spend` |

      | Most expensive Snowflake warehouses | `snowflake-workloads` (or
      `snowflake-warehouses` for metering spend) |

      | Warehouse utilization, idle spend, cluster usage |
      `snowflake-warehouses`, `snowflake-warehouse-clusters` |

      | Query latency, spillage and bytes scanned on a warehouse |
      `snowflake-warehouse-query-performance` |

      | Most expensive recurring queries | `snowflake-query-patterns` |

      | Individual queries | `snowflake-queries` |

      | Cost of dbt models, and of dbt runs | `snowflake-dbt`,
      `snowflake-dbt-invocations` |

      | Cost of tasks, stored procedures, dynamic tables | `snowflake-tasks`,
      `snowflake-stored-procedures`, `snowflake-dynamic-tables` |

      | Cost of BI tools (Looker, Mode, Hex, Sigma, Periscope, Tableau) |
      `snowflake-looker`, `snowflake-mode`, `snowflake-hex`, `snowflake-sigma`,
      `snowflake-periscope`, `tableau-queries` |

      | Cost of Fivetran, and of workloads defined by query tags |
      `snowflake-fivetran`, `snowflake-custom-workloads` |

      | Serverless, automatic clustering and Snowpipe cost |
      `snowflake-serverless`, `snowflake-automatic-clustering`,
      `snowflake-snowpipe` |

      | Storage cost in a period | `snowflake-storage`, `bigquery-storage-spend`
      |

      | Largest or unused tables now | `snowflake-storage-summary`,
      `bigquery-storage-summary` |

      | Which workloads read or write a table | `lineage-workloads`,
      `lineage-tables`, `lineage-edges` |

      | BigQuery cost by project, job or query pattern | `bigquery-projects`,
      `bigquery-jobs`, `bigquery-query-patterns` |

      | BigQuery reservations and commitments | `bigquery-reservation-timeline`,
      `bigquery-commitments`, `bigquery-commitment-scopes` |

      | Databricks cost by job, query, SQL warehouse or cluster |
      `databricks-jobs`, `databricks-queries`, `databricks-sql-warehouses`,
      `databricks-clusters` |

      | Savings from SELECT actions | `action-realized-savings` |

      | How current the data is | `data-freshness` |
paths:
  /snowflake-accounts/{snowflake_account_id}:
    get:
      tags:
        - snowflake-accounts
      summary: Get a Snowflake account
      description: Get a single Snowflake account by id.
      operationId: >-
        get_snowflake_account_route_snowflake_accounts__snowflake_account_id__get
      parameters:
        - name: snowflake_account_id
          in: path
          required: true
          schema:
            type: string
            title: Snowflake Account 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/SnowflakeAccount'
        '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:
    SnowflakeAccount:
      properties:
        id:
          type: string
          title: Id
          description: >-
            The account's Snowflake identifier, in `ORGANIZATION-ACCOUNT` form.
            Set by the caller when the account is added and cannot be changed
            afterward.
        etag:
          type: string
          title: Etag
          description: >-
            Opaque strong ETag for this account's configuration. Matches the
            `ETag` response header, and is what `If-Match` requires on a write.
            It changes whenever a configurable field on the account changes.
          readOnly: true
          x-terraform-computed: true
        name:
          type: string
          title: Name
          description: Display name for the account, as shown throughout SELECT.
        snowflake_organization_name:
          type: string
          title: Snowflake Organization Name
          description: Name of the Snowflake organization the account belongs to.
          readOnly: true
          x-terraform-computed: true
        snowflake_account_name:
          type: string
          title: Snowflake Account Name
          description: The account's name within its Snowflake organization.
          readOnly: true
          x-terraform-computed: true
        locator:
          anyOf:
            - type: string
            - type: 'null'
          title: Locator
          description: The account's Snowflake locator, as returned by `current_account()`.
          readOnly: true
          x-terraform-computed: true
        account_region:
          anyOf:
            - type: string
            - type: 'null'
          title: Account Region
          description: The Snowflake region the account is hosted in.
          readOnly: true
          x-terraform-computed: true
        snowsight_url:
          anyOf:
            - type: string
            - type: 'null'
          title: Snowsight Url
          description: Link to the account in Snowsight.
          readOnly: true
          x-terraform-computed: true
        snowflake_reader_parent_account_name:
          anyOf:
            - type: string
            - type: 'null'
          title: Snowflake Reader Parent Account Name
          description: >-
            For a reader account, the name of the account that created it. Null
            for a regular account.
          readOnly: true
          x-terraform-computed: true
        role:
          anyOf:
            - type: string
            - type: 'null'
          title: Role
          description: The Snowflake role SELECT assumes when reading this account.
        warehouse:
          anyOf:
            - type: string
            - type: 'null'
          title: Warehouse
          description: The Snowflake warehouse SELECT runs its queries on.
        describe_object_sproc_name:
          anyOf:
            - type: string
            - type: 'null'
          title: Describe Object Sproc Name
          description: >-
            Fully qualified name of the stored procedure SELECT calls to
            describe objects it cannot read directly.
        export_storage_integration_name:
          anyOf:
            - type: string
            - type: 'null'
          title: Export Storage Integration Name
          description: >-
            Name of the Snowflake storage integration used to export data to
            SELECT. Mutually exclusive with `export_stage_name`.
        export_stage_name:
          anyOf:
            - type: string
            - type: 'null'
          title: Export Stage Name
          description: >-
            Fully qualified name of the Snowflake stage used to export data to
            SELECT, for accounts that export through a stage rather than a
            storage integration.
        compute_cost_per_credit:
          anyOf:
            - type: number
            - type: 'null'
          title: Compute Cost Per Credit
          description: >-
            Overrides the credit rate SELECT reads from Snowflake when costing
            compute. Null uses the rate on the account's contract.
        storage_cost_per_tb:
          anyOf:
            - type: number
            - type: 'null'
          title: Storage Cost Per Tb
          description: >-
            Overrides the rate SELECT uses when costing storage, per terabyte
            per month. Null uses the rate on the account's contract.
        customer_side_sanitization_database_schema:
          anyOf:
            - type: string
            - type: 'null'
          title: Customer Side Sanitization Database Schema
          description: >-
            `DATABASE.SCHEMA` hosting the customer's own sanitized copies of
            Snowflake's account usage views, which SELECT reads instead of the
            originals. Null disables the redirection.
        customer_side_sanitization_views:
          anyOf:
            - items:
                type: string
              type: array
            - type: 'null'
          title: Customer Side Sanitization Views
          description: >-
            The account usage views to redirect, such as `query_history`. Null
            redirects every view SELECT reads.
        excluded_users_filter_expression:
          anyOf:
            - type: string
            - type: 'null'
          title: Excluded Users Filter Expression
          description: >-
            JSON-encoded filter selecting Snowflake users whose activity is
            excluded from SELECT's cost and usage figures.
          x-doit-confidentiality: customer-data
          x-doit-pii: true
        fivetran_users:
          anyOf:
            - items:
                type: string
              type: array
            - type: 'null'
          title: Fivetran Users
          description: >-
            Snowflake users that Fivetran runs as, so their activity is
            attributed to Fivetran.
          x-doit-confidentiality: customer-data
          x-doit-pii: true
        mode_workspace:
          anyOf:
            - type: string
            - type: 'null'
          title: Mode Workspace
          description: The Mode workspace to attribute queries to.
        mode_token_id:
          anyOf:
            - type: string
            - type: 'null'
          title: Mode Token Id
          description: Identifier of the Mode API token SELECT uses.
        mode_credentials_configured:
          type: boolean
          title: Mode Credentials Configured
          description: >-
            Whether Mode BI credentials are configured for this account. The
            credentials themselves are never returned.
          readOnly: true
          x-terraform-computed: true
        connection_id:
          type: string
          title: Connection Id
          description: Identifier of the underlying connection this account reads through.
          readOnly: true
          x-terraform-computed: true
        sync_enabled:
          type: boolean
          title: Sync Enabled
          description: Whether SELECT is currently syncing data for this account.
        query_sanitization_enabled:
          type: boolean
          title: Query Sanitization Enabled
          description: Whether query text is sanitized before SELECT stores it.
        has_org_admin_access:
          type: boolean
          title: Has Org Admin Access
          description: >-
            Whether SELECT can read this account's Snowflake organization-level
            usage views, which is what makes organization-wide rates and spend
            available.
          readOnly: true
          x-terraform-computed: true
        has_data_share:
          type: boolean
          title: Has Data Share
          description: Whether the account reads SELECT's data share.
          readOnly: true
          x-terraform-computed: true
        has_manage_warehouses_grant:
          anyOf:
            - type: boolean
            - type: 'null'
          title: Has Manage Warehouses Grant
          description: >-
            Whether SELECT's role holds `manage warehouses` on the account,
            which smart suspension requires. Null until first checked.
          readOnly: true
          x-terraform-computed: true
        added_by_email:
          anyOf:
            - type: string
            - type: 'null'
          title: Added By Email
          description: Email address of the user who added the account.
          readOnly: true
          x-doit-confidentiality: customer-data
          x-doit-pii: true
          x-terraform-computed: true
        latest_sync_time:
          anyOf:
            - type: string
            - type: 'null'
          title: Latest Sync Time
          description: >-
            When SELECT last synced data for this account, as an RFC 3339 UTC
            timestamp.
          readOnly: true
          x-terraform-computed: true
        last_successful_sync_time:
          anyOf:
            - type: string
            - type: 'null'
          title: Last Successful Sync Time
          description: >-
            When the account's last sync succeeded, as an RFC 3339 UTC
            timestamp. Behind `latest_sync_time` if the most recent attempt
            failed.
          readOnly: true
          x-terraform-computed: true
        latest_hourly_spend_time:
          anyOf:
            - type: string
            - type: 'null'
          title: Latest Hourly Spend Time
          description: >-
            The most recent hour SELECT holds spend data for, as an RFC 3339 UTC
            timestamp.
          readOnly: true
          x-terraform-computed: true
        create_time:
          type: string
          title: Create Time
          description: When the account was added to SELECT, as an RFC 3339 UTC timestamp.
          readOnly: true
          x-terraform-computed: true
        update_time:
          type: string
          title: Update Time
          description: When the account was last changed, as an RFC 3339 UTC timestamp.
          readOnly: true
          x-terraform-computed: true
      type: object
      required:
        - id
        - etag
        - name
        - snowflake_organization_name
        - snowflake_account_name
        - mode_credentials_configured
        - connection_id
        - sync_enabled
        - query_sanitization_enabled
        - has_org_admin_access
        - has_data_share
        - create_time
        - update_time
      title: SnowflakeAccount
      description: A connection to one Snowflake 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:
          $ref: '#/components/schemas/ErrorCode'
        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
    ErrorCode:
      type: string
      enum:
        - validation_failed
        - unauthorized
        - invalid_token
        - forbidden
        - not_found
        - tenant_id_required
        - tenant_mismatch
        - conflict
        - delete_blocked_by_dependencies
        - query_profile_unavailable
        - insight_auto_closed
        - integration_credentials_rejected
        - describe_procedure_unavailable
        - missing_grant
        - monitor_run_without_period
        - template_render_failed
        - response_too_large
        - precondition_failed
        - precondition_required
        - quota_exceeded
        - rate_limited
        - filter_key_not_supported
        - pagination_token_expired
        - pagination_token_invalid
        - internal_error
        - service_unavailable
      title: ErrorCode
      description: >-
        The machine-readable identifier of an error.


        Clients branch on this, never on ``title`` or ``detail``. A published
        code keeps

        its meaning; new codes may be added.
  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

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.