Altimate AI QUERIES_V2 API

openapi: 3.1.0
info:
  title: Fast ACCOUNT_COSTS QUERIES_V2 API
  version: 0.1.0
tags:
- name: QUERIES_V2
paths:
  /query/v2/:
    get:
      tags:
      - QUERIES_V2
      summary: Get All Queries
      operationId: get_all_queries_query_v2__get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: start_date
        in: query
        required: true
        schema:
          type: string
          description: Start date for filtering queries (ISO format)
          title: Start Date
        description: Start date for filtering queries (ISO format)
      - name: end_date
        in: query
        required: true
        schema:
          type: string
          description: End date for filtering queries (ISO format)
          title: End Date
        description: End date for filtering queries (ISO format)
      - name: sortAttribute
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          default: query_cost
          title: Sortattribute
      - name: sortOrder
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          default: DESC
          title: Sortorder
      - name: page
        in: query
        required: false
        schema:
          type: integer
          minimum: 1
          description: Page number
          default: 1
          title: Page
        description: Page number
      - name: size
        in: query
        required: false
        schema:
          type: integer
          maximum: 100
          minimum: 1
          description: Page size
          default: 50
          title: Size
        description: Page size
      - name: tags
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Tags
      - name: warehouses
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Warehouses
      - name: users
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Users
      - name: roles
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Roles
      - name: executionTimeFilter
        in: query
        required: false
        schema:
          anyOf:
          - type: number
          - type: 'null'
          default: 0
          title: Executiontimefilter
      - name: executionTimeFilterMode
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          default: gt
          title: Executiontimefiltermode
      - name: executionCostFilter
        in: query
        required: false
        schema:
          anyOf:
          - type: number
          - type: 'null'
          default: 0
          title: Executioncostfilter
      - name: executionCostFilterMode
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          default: gt
          title: Executioncostfiltermode
      - name: query_hash
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Query Hash
      - name: query_id
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Query Id
      - name: session_id
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Session Id
      - name: query_parameterized_hash
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Query Parameterized Hash
      - name: dataset
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Dataset
      - name: query_type
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Query Type
      - name: instance_ids
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Instance Ids
      - name: teams
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Teams
      - name: navigationSource
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Navigationsource
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Page_QueryFetchAllPageResponse_'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get All Queries Query V2  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get All Queries Query V2  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/items/{query_id}:
    get:
      tags:
      - QUERIES_V2
      summary: Get Query
      operationId: get_query_query_v2_items__query_id__get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: query_id
        in: path
        required: true
        schema:
          type: string
          title: Query Id
      - name: start_date
        in: query
        required: false
        schema:
          type: string
          format: date-time
          title: Start Date
      - name: end_date
        in: query
        required: false
        schema:
          type: string
          format: date-time
          title: End Date
      - name: navigationSource
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Navigationsource
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryFetchResponseV2'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get Query Query V2 Items  Query Id  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get Query Query V2 Items  Query Id  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/filters/:
    get:
      tags:
      - QUERIES_V2
      summary: Get All Filters
      operationId: get_all_filters_query_v2_filters__get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: entity_type
        in: query
        required: false
        schema:
          type: string
          default: ''
          title: Entity Type
      - name: prefix
        in: query
        required: false
        schema:
          type: string
          default: ''
          title: Prefix
      - name: page
        in: query
        required: false
        schema:
          type: integer
          default: 1
          title: Page
      - name: size
        in: query
        required: false
        schema:
          type: integer
          default: 50
          title: Size
      - name: navigationSource
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Navigationsource
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryFiltersFetchAllResponse'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get All Filters Query V2 Filters  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get All Filters Query V2 Filters  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/filters/custom-tag-values/:
    get:
      tags:
      - QUERIES_V2
      summary: Get Custom Tag Values
      description: 'Get distinct values for a custom tag key from the query_tag JSON column.


        This endpoint extracts distinct values for a specified JSON key from the query_tag

        column in the query usage data. It supports optional search filtering and pagination.


        Use cases:

        - Get all distinct values for ''dbt_snowflake_query_tags_version''

        - Get distinct values matching a search pattern (e.g., values starting with ''2.5'')

        - Retrieve entities/values for a custom tag key for filtering purposes


        Example usage:

        - GET /filters/custom-tag-values/?tag_key=dbt_snowflake_query_tags_version

        - GET /filters/custom-tag-values/?tag_key=dbt_snowflake_query_tags_version&search=2.5

        - GET /filters/custom-tag-values/?tag_key=project_name&prefix=custom_tags'
      operationId: get_custom_tag_values_query_v2_filters_custom_tag_values__get
      deprecated: true
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: tag_key
        in: query
        required: true
        schema:
          type: string
          description: The JSON key to extract values from query_tag
          title: Tag Key
        description: The JSON key to extract values from query_tag
      - name: prefix
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          description: Optional prefix path in the query_tag JSON (for nested JSON structures)
          title: Prefix
        description: Optional prefix path in the query_tag JSON (for nested JSON structures)
      - name: search
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          description: Optional search string to filter values (ILIKE pattern)
          title: Search
        description: Optional search string to filter values (ILIKE pattern)
      - name: page
        in: query
        required: false
        schema:
          type: integer
          minimum: 1
          description: Page number (1-indexed)
          default: 1
          title: Page
        description: Page number (1-indexed)
      - name: size
        in: query
        required: false
        schema:
          type: integer
          maximum: 500
          minimum: 1
          description: Number of items per page
          default: 50
          title: Size
        description: Number of items per page
      - name: navigationSource
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Navigationsource
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/CustomTagValuesResponse'
        '400':
          description: Invalid request parameters
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get Custom Tag Values Query V2 Filters Custom Tag Values  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get Custom Tag Values Query V2 Filters Custom Tag Values  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/sql_lineage/{query_id}:
    get:
      tags:
      - QUERIES_V2
      summary: Get Sql Lineage
      operationId: get_sql_lineage_query_v2_sql_lineage__query_id__get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: query_id
        in: path
        required: true
        schema:
          type: string
          title: Query Id
      - name: start_date
        in: query
        required: false
        schema:
          type: string
          format: date-time
          title: Start Date
      - name: end_date
        in: query
        required: false
        schema:
          type: string
          format: date-time
          title: End Date
      - name: enable_cache
        in: query
        required: false
        schema:
          type: boolean
          default: true
          title: Enable Cache
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/app__schemas__queries__QuerySqlLineageResponse'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get Sql Lineage Query V2 Sql Lineage  Query Id  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get Sql Lineage Query V2 Sql Lineage  Query Id  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/sql_lineage_group/{query_hash}:
    get:
      tags:
      - QUERIES_V2
      summary: Get Sql Lineage Group
      operationId: get_sql_lineage_group_query_v2_sql_lineage_group__query_hash__get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: query_hash
        in: path
        required: true
        schema:
          type: string
          title: Query Hash
      - name: start_date
        in: query
        required: false
        schema:
          type: string
          format: date-time
          title: Start Date
      - name: end_date
        in: query
        required: false
        schema:
          type: string
          format: date-time
          title: End Date
      - name: enable_cache
        in: query
        required: false
        schema:
          type: boolean
          default: true
          title: Enable Cache
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/app__schemas__queries__QuerySqlLineageResponse'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get Sql Lineage Group Query V2 Sql Lineage Group  Query Hash  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get Sql Lineage Group Query V2 Sql Lineage Group  Query Hash  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/group_latest_query/{query_hash}:
    get:
      tags:
      - QUERIES_V2
      summary: Get Latest Query For Query Group By Hash
      operationId: get_latest_query_for_query_group_by_hash_query_v2_group_latest_query__query_hash__get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: query_hash
        in: path
        required: true
        schema:
          type: string
          title: Query Hash
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryFetchResponse'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get Latest Query For Query Group By Hash Query V2 Group Latest Query  Query Hash  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get Latest Query For Query Group By Hash Query V2 Group Latest Query  Query Hash  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/indices/{query_hash}:
    post:
      tags:
      - QUERIES_V2
      summary: Get Latest Query For Query Group By Hash
      operationId: get_latest_query_for_query_group_by_hash_query_v2_indices__query_hash__post
      deprecated: true
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: query_hash
        in: path
        required: true
        schema:
          type: string
          title: Query Hash
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/QueryIndicesRequest'
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryIndicesResponse'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get Latest Query For Query Group By Hash Query V2 Indices  Query Hash  Post
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get Latest Query For Query Group By Hash Query V2 Indices  Query Hash  Post
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/groups:
    get:
      tags:
      - QUERIES_V2
      summary: Get All Query Groups
      operationId: get_all_query_groups_query_v2_groups_get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: start_date
        in: query
        required: false
        schema:
          type: string
          title: Start Date
      - name: end_date
        in: query
        required: false
        schema:
          type: string
          title: End Date
      - name: sort_key
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          default: total_cost
          title: Sort Key
      - name: sort_order
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          default: desc
          title: Sort Order
      - name: page
        in: query
        required: false
        schema:
          type: integer
          minimum: 1
          description: Page number
          default: 1
          title: Page
        description: Page number
      - name: size
        in: query
        required: false
        schema:
          type: integer
          maximum: 100
          minimum: 1
          description: Page size
          default: 50
          title: Size
        description: Page size
      - name: navigationSource
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Navigationsource
      - name: tags
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Tags
      - name: warehouses
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Warehouses
      - name: users
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Users
      - name: roles
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Roles
      - name: query_hash
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Query Hash
      - name: query_type
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Query Type
      - name: instance_ids
        in: query
        required: false
        schema:
          anyOf:
          - type: array
            items:
              type: string
          - type: 'null'
          title: Instance Ids
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Page_QueryGroupPageItem_'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get All Query Groups Query V2 Groups Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get All Query Groups Query V2 Groups Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/query_group/query_text/{query_hash}:
    get:
      tags:
      - QUERIES_V2
      summary: Get Query Text
      operationId: get_query_text_query_v2_query_group_query_text__query_hash__get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: query_hash
        in: path
        required: true
        schema:
          type: string
          title: Query Hash
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryHashTextResponse'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get Query Text Query V2 Query Group Query Text  Query Hash  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get Query Text Query V2 Query Group Query Text  Query Hash  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/query_group/stats/{query_hash}:
    get:
      tags:
      - QUERIES_V2
      summary: Get Hash Metrics
      operationId: get_hash_metrics_query_v2_query_group_stats__query_hash__get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: query_hash
        in: path
        required: true
        schema:
          type: string
          title: Query Hash
      - name: start_date
        in: query
        required: false
        schema:
          type: string
          format: date-time
          title: Start Date
      - name: end_date
        in: query
        required: false
        schema:
          type: string
          format: date-time
          title: End Date
      - name: navigationSource
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Navigationsource
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryGroupMetricsResponse'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get Hash Metrics Query V2 Query Group Stats  Query Hash  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get Hash Metrics Query V2 Query Group Stats  Query Hash  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/groups/{query_hash}:
    get:
      tags:
      - QUERIES_V2
      summary: Get Query Group Details
      operationId: get_query_group_details_query_v2_groups__query_hash__get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: query_hash
        in: path
        required: true
        schema:
          type: string
          title: Query Hash
      - name: start_date
        in: query
        required: false
        schema:
          type: string
          title: Start Date
      - name: end_date
        in: query
        required: false
        schema:
          type: string
          title: End Date
      - name: navigationSource
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Navigationsource
      - name: x-tenant
        in: header
        required: true
        schema:
          type: string
          title: X-Tenant
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryGroupResponse'
        '400':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 400 Get Query Group Details Query V2 Groups  Query Hash  Get
        '403':
          description: Not supported for public user
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response 403 Get Query Group Details Query V2 Groups  Query Hash  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /query/v2/snowflake_jobs:
    get:
      tags:
      - QUERIES_V2
      summary: Get Snowflake Jobs
      operationId: get_snowflake_jobs_query_v2_snowflake_jobs_get
      security:
      - HTTPBearer: []
      - HTTPBearer: []
      parameters:
      - name: page
        in: query
        required: false
        schema:
          type: integer
          minimum: 1
          description: Page number
          default: 1
          title: Page
        description: Page number
      - name: size
        in: query
        required: false
        schema:
          type: integer
          maximum: 100
          minimum: 1
          description: Page size
          default: 50
          title: Size
        description: Page size
      - name: start_date
        in: query
        required: false
        schema:
          type: string
          format: date-time
          default: '2026-06-17T12:35:37.352542'
          title: Star

# --- truncated at 32 KB (242 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/altimate-ai/refs/heads/main/openapi/altimate-ai-queries-v2-api-openapi.yml