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: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.352590' title: End Date - name: workflow_type in: query required: false schema: anyOf: - type: string - type: 'null' title: Workflow Type - name: workflows in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Workflows - name: warehouses in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Warehouses - name: teams in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Teams - name: apps in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Apps - 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: 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' title: Executiontimefiltermode - name: costFilter in: query required: false schema: anyOf: - type: number - type: 'null' default: 0 title: Costfilter - name: costFilterMode in: query required: false schema: anyOf: - type: string - type: 'null' title: Costfiltermode - name: instance_id in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Instance Id - name: integration_names in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Integration Names - name: integration_environments in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Integration Environments - 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_SnowflakeJobFetchAllPageResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Jobs Query V2 Snowflake Jobs Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Jobs Query V2 Snowflake Jobs Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/graph_data: get: tags: - QUERIES_V2 summary: Get Snowflake Jobs Listing Graph Data operationId: get_snowflake_jobs_listing_graph_data_query_v2_snowflake_jobs_graph_data_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_type in: query required: false schema: anyOf: - type: string - type: 'null' title: Workflow Type - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:36.446353' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:36.446402' title: End Date - name: aggregate_by in: query required: false schema: type: string default: project_id title: Aggregate By - name: workflows in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Workflows - name: warehouses in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Warehouses - name: teams in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Teams - name: apps in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Apps - 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' title: Executiontimefiltermode - name: costFilter in: query required: false schema: anyOf: - type: number - type: 'null' default: 0 title: Costfilter - name: costFilterMode in: query required: false schema: anyOf: - type: string - type: 'null' title: Costfiltermode - name: instance_id in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Instance Id - name: aggregate_date_interval in: query required: false schema: type: string default: day title: Aggregate Date Interval - name: integration_names in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Integration Names - name: integration_environments in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Integration Environments - 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: type: array items: type: object additionalProperties: true title: Response Get Snowflake Jobs Listing Graph Data Query V2 Snowflake Jobs Graph Data Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Jobs Listing Graph Data Query V2 Snowflake Jobs Graph Data Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Jobs Listing Graph Data Query V2 Snowflake Jobs Graph Data Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/graph_summary: get: tags: - QUERIES_V2 summary: Get Snowflake Jobs Listing Graph Summary description: Returns total cost summary for the given filters. operationId: get_snowflake_jobs_listing_graph_summary_query_v2_snowflake_jobs_graph_summary_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_type in: query required: false schema: anyOf: - type: string - type: 'null' title: Workflow Type - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:36.446353' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:36.446402' title: End Date - name: aggregate_by in: query required: false schema: type: string default: project_id title: Aggregate By - name: workflows in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Workflows - name: warehouses in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Warehouses - name: teams in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Teams - name: apps in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Apps - 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' title: Executiontimefiltermode - name: costFilter in: query required: false schema: anyOf: - type: number - type: 'null' default: 0 title: Costfilter - name: costFilterMode in: query required: false schema: anyOf: - type: string - type: 'null' title: Costfiltermode - name: instance_id in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Instance Id - name: aggregate_date_interval in: query required: false schema: type: string default: day title: Aggregate Date Interval - name: integration_names in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Integration Names - name: integration_environments in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Integration Environments - 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: type: object additionalProperties: true title: Response Get Snowflake Jobs Listing Graph Summary Query V2 Snowflake Jobs Graph Summary Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Jobs Listing Graph Summary Query V2 Snowflake Jobs Graph Summary Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Jobs Listing Graph Summary Query V2 Snowflake Jobs Graph Summary Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/summary/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Snowflake Jobs Summary operationId: get_snowflake_jobs_summary_query_v2_snowflake_jobs_summary__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow 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: workflow_type in: query required: false schema: type: string title: Workflow Type - name: x-tenant in: header required: true schema: type: string title: X-Tenant responses: '200': description: Successful Response content: application/json: schema: type: object additionalProperties: true title: Response Get Snowflake Jobs Summary Query V2 Snowflake Jobs Summary Workflow Id Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Jobs Summary Query V2 Snowflake Jobs Summary Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Jobs Summary Query V2 Snowflake Jobs Summary Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/dbt_filters/jobs/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Dbt Jobs Filter operationId: get_dbt_jobs_filter_query_v2_snowflake_jobs_dbt_filters_jobs__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: page in: query required: false schema: anyOf: - type: integer - type: 'null' default: 1 title: Page - name: size in: query required: false schema: anyOf: - type: integer - type: 'null' default: 50 title: Size - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: End Date - name: command in: query required: false schema: anyOf: - type: string - type: 'null' title: Command - 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/DbtJobFilterResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Dbt Jobs Filter Query V2 Snowflake Jobs Dbt Filters Jobs Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/dbt_filters/tags/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Dbt Tags Filter operationId: get_dbt_tags_filter_query_v2_snowflake_jobs_dbt_filters_tags__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: page in: query required: false schema: anyOf: - type: integer - type: 'null' default: 1 title: Page - name: size in: query required: false schema: anyOf: - type: integer - type: 'null' default: 50 title: Size - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: End Date - name: command in: query required: false schema: anyOf: - type: string - type: 'null' title: Command - 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/DbtTagFilterResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Dbt Tags Filter Query V2 Snowflake Jobs Dbt Filters Tags Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/dbt_jobs/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Dbt Jobs operationId: get_dbt_jobs_query_v2_snowflake_jobs_dbt_jobs__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - 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: 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: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: End Date - name: command in: query required: false schema: anyOf: - type: string - type: 'null' title: Command - 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_DbtJobListingPageResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Dbt Jobs Query V2 Snowflake Jobs Dbt Jobs Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Dbt Jobs Query V2 Snowflake Jobs Dbt Jobs Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/dbt_jobs_graph/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Dbt Jobs Graph operationId: get_dbt_jobs_graph_query_v2_snowflake_jobs_dbt_jobs_graph__workflow_id__get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: End Date - name: command in: query required: false schema: anyOf: - type: string - type: 'null' title: Command - 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: type: array items: {} title: Response Get Dbt Jobs Graph Query V2 Snowflake Jobs Dbt Jobs Graph Workflow Id Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Dbt Jobs Graph Query V2 Snowflake Jobs Dbt Jobs Graph Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/dbt_jobs_summary/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Dbt Jobs Summary operationId: get_dbt_jobs_summary_query_v2_snowflake_jobs_dbt_jobs_summary__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: End Date - name: command in: query required: false schema: anyOf: - type: string - type: 'null' title: Command - 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: type: object additionalProperties: true title: Response Get Dbt Jobs Summary Query V2 Snowflake Jobs Dbt Jobs Summary Workflow Id Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Dbt Jobs Summary Query V2 Snowflake Jobs Dbt Jobs Summary Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/graph_data/{workflow_id}: post: tags: - QUERIES_V2 summary: Get Snowflake Jobs Graph Data operationId: get_snowflake_jobs_graph_data_query_v2_snowflake_jobs_graph_data__workflow_id__post deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:37.459149' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.459231' title: End Date - name: task_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Task Id - name: x-tenant in: header required: true schema: type: string title: X-Tenant requestBody: required: true content: application/json: schema: $ref: '#/components/schemas/SnowflakeJobGraphDataRequest' responses: '200': description: Successful Response content: application/json: schema: type: array items: {} title: Response Get Snowflake Jobs Graph Data Query V2 Snowflake Jobs Graph Data Workflow Id Post '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Jobs Graph Data Query V2 Snowflake Jobs Graph Data Workflow Id Post '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Jobs Graph Data Query V2 Snowflake Jobs Graph Data Workflow Id Post '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/runs/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Snowflake Job Runs operationId: get_snowflake_job_runs_query_v2_snowflake_jobs_runs__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - 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:36.448063' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:36.448113' title: End Date - name: task_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Task Id - name: instance_id in: query required: false schema: type: string title: Instance Id - name: sort_key in: query required: false schema: anyOf: - type: string - type: 'null' default: run_id title: Sort Key - name: sort_order in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sort Order - name: run_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Run Id - name: run_status in: query required: false schema: anyOf: - type: string - type: 'null' title: Run Status - name: command in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Command - 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_SnowflakeJobRunPageResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Job Runs Query V2 Snowflake Jobs Runs Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Job Runs Query V2 Snowflake Jobs Runs Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/runs_graph/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Snowflake Job Runs Graph operationId: get_snowflake_job_runs_graph_query_v2_snowflake_jobs_runs_graph__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:36.448063' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:36.448113' title: End Date - name: task_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Task Id - name: instance_id in: query required: false schema: type: string title: Instance Id - name: sort_key in: query required: false schema: anyOf: - type: string - type: 'null' default: run_id title: Sort Key - name: sort_order in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sort Order - name: run_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Run Id - name: run_status in: query required: false schema: anyOf: - type: string - type: 'null' title: Run Status - name: command in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Command - name: page in: query required: false schema: anyOf: - type: integer - type: 'null' default: 1 title: Page - name: size in: query required: false schema: anyOf: - type: integer - type: 'null' default: 10000 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: type: array items: $ref: '#/components/schemas/JobRunGraphResponse' title: Response Get Snowflake Job Runs Graph Query V2 Snowflake Jobs Runs Graph Workflow Id Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Job Runs Graph Query V2 Snowflake Jobs Runs Graph Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Job Runs Graph Query V2 Snowflake Jobs Runs Graph Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/tasks/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Snowflake Job Tasks operationId: get_snowflake_job_tasks_query_v2_snowflake_jobs_tasks__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:36.448373' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:36.448413' title: End Date - 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: run_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Run Id - name: command in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Command - name: tag in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Tag - name: task_type in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Task Type - name: sortAttribute in: query required: false schema: anyOf: - type: string - type: 'null' default: timestamp title: Sortattribute - name: sortOrder in: query required: false schema: anyOf: - type: string - type: 'null' default: DESC title: Sortorder - 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_SnowflakeJobTaskAggregatePageResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Job Tasks Query V2 Snowflake Jobs Tasks Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Job Tasks Query V2 Snowflake Jobs Tasks Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/dbt-jobs/tasks/summary/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Dbt Job Tasks Summary operationId: get_dbt_job_tasks_summary_query_v2_dbt_jobs_tasks_summary__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: task_id in: query required: false schema: type: string title: Task Id - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:37.528691' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.528749' title: End Date - name: task_type in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Task Type - name: run_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Run Id - 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/DbtJobTasksSummaryResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Dbt Job Tasks Summary Query V2 Dbt Jobs Tasks Summary Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/tasks_by_run/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Snowflake Job Run Tasks operationId: get_snowflake_job_run_tasks_query_v2_snowflake_jobs_tasks_by_run__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: run_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Run Id - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:37.538868' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.538934' title: End Date - 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: sort_key in: query required: false schema: anyOf: - type: string - type: 'null' default: query_cost title: Sort Key - name: sort_order in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sort Order - 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_Dict_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Job Run Tasks Query V2 Snowflake Jobs Tasks By Run Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Job Run Tasks Query V2 Snowflake Jobs Tasks By Run Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/latest_run/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Snowflake Job Run Tasks operationId: get_snowflake_job_run_tasks_query_v2_snowflake_jobs_latest_run__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: x-tenant in: header required: true schema: type: string title: X-Tenant responses: '200': description: Successful Response content: application/json: schema: type: array items: {} title: Response Get Snowflake Job Run Tasks Query V2 Snowflake Jobs Latest Run Workflow Id Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Job Run Tasks Query V2 Snowflake Jobs Latest Run Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Job Run Tasks Query V2 Snowflake Jobs Latest Run Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/settings: get: tags: - QUERIES_V2 summary: Get Snowflake Job Settings operationId: get_snowflake_job_settings_query_v2_snowflake_jobs_settings_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - 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/SnowflakeJobSettings' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Job Settings Query V2 Snowflake Jobs Settings Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Job Settings Query V2 Snowflake Jobs Settings Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' post: tags: - QUERIES_V2 summary: Upsert Snowflake Job Settings operationId: upsert_snowflake_job_settings_query_v2_snowflake_jobs_settings_post deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: x-tenant in: header required: true schema: type: string title: X-Tenant requestBody: required: true content: application/json: schema: $ref: '#/components/schemas/SnowflakeJobSettings' responses: '200': description: Successful Response content: application/json: schema: $ref: '#/components/schemas/SnowflakeJobSettings' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Upsert Snowflake Job Settings Query V2 Snowflake Jobs Settings Post '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Upsert Snowflake Job Settings Query V2 Snowflake Jobs Settings Post '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/filters/: get: tags: - QUERIES_V2 summary: Get All Snowflake Job Filters description: "Bulk bounded-facet filters (AI-6471).\n\nReturns the small/bounded filter facets in one call. Unbounded facets\nare served from per-facet paginated endpoints — call those separately\nwhen the user opens the corresponding dropdown:\n\n - /snowflake_jobs/filters/workflow_ids (CUSTOM, DBT)\n - /snowflake_jobs/filters/workflow_ids_with_labels (TABLEAU)\n - /snowflake_jobs/filters/teams (CUSTOM)\n - /snowflake_jobs/filters/apps (CUSTOM)\n - /snowflake_jobs/filters/custom_tags/{tag_key}\n\nBehavior by workflow_type:\n - CUSTOM: warehouses, custom_tag_keys\n - TABLEAU: warehouses, teams, apps\n - DBT: warehouses, integration_names, integration_environments,\n integrations_with_environments\n - None (omitted): warehouses only; all workflow_type-scoped fields\n are empty. Useful for screens that don't pin a\n workflow_type yet but need the warehouse picker." operationId: get_all_snowflake_job_filters_query_v2_snowflake_jobs_filters__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:37.558856' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.558939' title: End Date - name: workflow_type in: query required: false schema: anyOf: - type: string - type: 'null' title: Workflow Type - 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/SnowflakeJobFilters' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get All Snowflake Job Filters Query V2 Snowflake Jobs Filters Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get All Snowflake Job Filters Query V2 Snowflake Jobs Filters Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/filters/teams: get: tags: - QUERIES_V2 summary: Get Snowflake Job Filter Teams description: 'Paginated teams (CUSTOM only). For TABLEAU/DBT, read teams from the bulk /snowflake_jobs/filters/ response instead.' operationId: get_snowflake_job_filter_teams_query_v2_snowflake_jobs_filters_teams_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: true schema: type: string format: date-time title: Start Date - name: end_date in: query required: true schema: type: string format: date-time title: End Date - name: workflow_type in: query required: true schema: type: string title: Workflow Type - name: search in: query required: false schema: anyOf: - type: string - type: 'null' title: Search - name: page in: query required: false schema: type: integer maximum: 1000000 minimum: 1 default: 1 title: Page - name: size in: query required: false schema: type: integer maximum: 500 minimum: 1 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/PaginatedStringValuesResponse' '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/filters/apps: get: tags: - QUERIES_V2 summary: Get Snowflake Job Filter Apps description: 'Paginated apps (CUSTOM only). For TABLEAU/DBT, read apps from the bulk /snowflake_jobs/filters/ response instead.' operationId: get_snowflake_job_filter_apps_query_v2_snowflake_jobs_filters_apps_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: true schema: type: string format: date-time title: Start Date - name: end_date in: query required: true schema: type: string format: date-time title: End Date - name: workflow_type in: query required: true schema: type: string title: Workflow Type - name: search in: query required: false schema: anyOf: - type: string - type: 'null' title: Search - name: page in: query required: false schema: type: integer maximum: 1000000 minimum: 1 default: 1 title: Page - name: size in: query required: false schema: type: integer maximum: 500 minimum: 1 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/PaginatedStringValuesResponse' '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/filters/workflow_ids: get: tags: - QUERIES_V2 summary: Get Snowflake Job Filter Workflow Ids description: Workflow IDs (label == value). For TABLEAU, use /workflow_ids_with_labels. operationId: get_snowflake_job_filter_workflow_ids_query_v2_snowflake_jobs_filters_workflow_ids_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: true schema: type: string format: date-time title: Start Date - name: end_date in: query required: true schema: type: string format: date-time title: End Date - name: workflow_type in: query required: true schema: type: string title: Workflow Type - name: search in: query required: false schema: anyOf: - type: string - type: 'null' title: Search - name: page in: query required: false schema: type: integer maximum: 1000000 minimum: 1 default: 1 title: Page - name: size in: query required: false schema: type: integer maximum: 500 minimum: 1 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/PaginatedStringValuesResponse' '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/filters/workflow_ids_with_labels: get: tags: - QUERIES_V2 summary: Get Snowflake Job Filter Workflow Ids With Labels description: Labeled workflow IDs — currently TABLEAU only (dashboard names as labels). operationId: get_snowflake_job_filter_workflow_ids_with_labels_query_v2_snowflake_jobs_filters_workflow_ids_with_labels_get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: true schema: type: string format: date-time title: Start Date - name: end_date in: query required: true schema: type: string format: date-time title: End Date - name: workflow_type in: query required: true schema: type: string title: Workflow Type - name: search in: query required: false schema: anyOf: - type: string - type: 'null' title: Search - name: page in: query required: false schema: type: integer maximum: 1000000 minimum: 1 default: 1 title: Page - name: size in: query required: false schema: type: integer maximum: 500 minimum: 1 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/PaginatedLabeledValuesResponse' '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/filters/custom_tags/{tag_key}: get: tags: - QUERIES_V2 summary: Get Snowflake Job Filter Custom Tag Values operationId: get_snowflake_job_filter_custom_tag_values_query_v2_snowflake_jobs_filters_custom_tags__tag_key__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: tag_key in: path required: true schema: type: string title: Tag Key - name: start_date in: query required: true schema: type: string format: date-time title: Start Date - name: end_date in: query required: true schema: type: string format: date-time title: End Date - name: workflow_type in: query required: false schema: anyOf: - type: string - type: 'null' title: Workflow Type - name: search in: query required: false schema: anyOf: - type: string - type: 'null' title: Search - name: page in: query required: false schema: type: integer maximum: 1000000 minimum: 1 default: 1 title: Page - name: size in: query required: false schema: type: integer maximum: 500 minimum: 1 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/PaginatedStringValuesResponse' '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/compare: post: tags: - QUERIES_V2 summary: Post Compare Snowflake Job Runs operationId: post_compare_snowflake_job_runs_query_v2_snowflake_jobs_compare_post security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:37.608272' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.608356' title: End Date - name: x-tenant in: header required: true schema: type: string title: X-Tenant requestBody: required: true content: application/json: schema: $ref: '#/components/schemas/SnowflakeJobRunCompareRequest' responses: '200': description: Successful Response content: application/json: schema: type: array items: $ref: '#/components/schemas/RunDiff' title: Response Post Compare Snowflake Job Runs Query V2 Snowflake Jobs Compare Post '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Post Compare Snowflake Job Runs Query V2 Snowflake Jobs Compare Post '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Post Compare Snowflake Job Runs Query V2 Snowflake Jobs Compare Post '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/definition/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Snowflake Job Definition Workflow Id operationId: get_snowflake_job_definition_workflow_id_query_v2_snowflake_jobs_definition__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:37.614671' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.614749' title: End Date - 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/SnowflakeJobDefinitionResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Job Definition Workflow Id Query V2 Snowflake Jobs Definition Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Job Definition Workflow Id Query V2 Snowflake Jobs Definition Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/tasks_summary/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Task Summary operationId: get_task_summary_query_v2_snowflake_jobs_tasks_summary__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: task_id in: query required: false schema: type: string title: Task Id - name: startDate in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:37.619250' title: Startdate - name: endDate in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.619310' title: Enddate - 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/TaskSummaryResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Task Summary Query V2 Snowflake Jobs Tasks Summary Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Task Summary Query V2 Snowflake Jobs Tasks Summary Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/run_list/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Snowflake Job Runs operationId: get_snowflake_job_runs_query_v2_snowflake_jobs_run_list__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - 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: startDate in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:36.448562' title: Startdate - name: endDate in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:36.448610' title: Enddate - name: task_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Task Id - name: sort_key in: query required: false schema: anyOf: - type: string - type: 'null' default: query_cost title: Sort Key - name: sort_order in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sort Order - name: execution_status in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Execution Status - name: warehouse_name in: query required: false schema: anyOf: - type: string - type: 'null' title: Warehouse Name - 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_SnowflakeIndividualJobRunPageResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Job Runs Query V2 Snowflake Jobs Run List Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Job Runs Query V2 Snowflake Jobs Run List Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/snowflake_jobs/run_list_graph/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Snowflake Job Runs Graph operationId: get_snowflake_job_runs_graph_query_v2_snowflake_jobs_run_list_graph__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: startDate in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:36.448838' title: Startdate - name: endDate in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:36.448884' title: Enddate - name: task_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Task Id - name: sort_key in: query required: false schema: anyOf: - type: string - type: 'null' default: query_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: anyOf: - type: integer - type: 'null' default: 1 title: Page - name: size in: query required: false schema: anyOf: - type: integer - type: 'null' default: 10000 title: Size - name: execution_status in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Execution Status - name: warehouse_name in: query required: false schema: anyOf: - type: string - type: 'null' title: Warehouse Name - name: x-tenant in: header required: true schema: type: string title: X-Tenant responses: '200': description: Successful Response content: application/json: schema: type: array items: $ref: '#/components/schemas/SnowflakeIndividualJobRunPageResponse' title: Response Get Snowflake Job Runs Graph Query V2 Snowflake Jobs Run List Graph Workflow Id Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Snowflake Job Runs Graph Query V2 Snowflake Jobs Run List Graph Workflow Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Snowflake Job Runs Graph Query V2 Snowflake Jobs Run List Graph Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/is_dbt_model/{query_id}: get: tags: - QUERIES_V2 summary: Check Workflow Type operationId: check_workflow_type_query_v2_is_dbt_model__query_id__get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: query_id in: path required: true schema: type: string title: Query Id - name: x-tenant in: header required: true schema: type: string title: X-Tenant responses: '200': description: Successful Response content: application/json: schema: type: object additionalProperties: true title: Response Check Workflow Type Query V2 Is Dbt Model Query Id Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Check Workflow Type Query V2 Is Dbt Model Query Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/project_details/{workflow_id}: get: tags: - QUERIES_V2 summary: Get Integration Details operationId: get_integration_details_query_v2_project_details__workflow_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workflow_id in: path required: true schema: type: string title: Workflow Id - name: x-tenant in: header required: true schema: type: string title: X-Tenant responses: '200': description: Successful Response content: application/json: schema: type: object additionalProperties: true title: Response Get Integration Details Query V2 Project Details Workflow Id Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Integration Details Query V2 Project Details Workflow Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads: get: tags: - QUERIES_V2 summary: Get Workloads description: 'Get workloads (notebook/streamlit) with optional filtering by type. Applies RBAC team filtering: when a team is selected, only workloads permitted for that user group are returned.' operationId: get_workloads_query_v2_workloads_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workload_type in: query required: false schema: anyOf: - $ref: '#/components/schemas/WorkloadType' - type: 'null' title: Workload Type - 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: sortAttribute in: query required: false schema: anyOf: - type: string - type: 'null' default: cost title: Sortattribute - name: sortOrder in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sortorder - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.663010' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.663063' 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/Page_WorkloadPageResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Workloads Query V2 Workloads Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Workloads Query V2 Workloads Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/jobs/{workload_hash}: get: tags: - QUERIES_V2 summary: Get Workload Jobs description: Get jobs for a specific workload hash. operationId: get_workload_jobs_query_v2_workloads_jobs__workload_hash__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workload_hash in: path required: true schema: type: string title: Workload Hash - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.676478' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.676569' title: End Date - name: navigationSource in: query required: false schema: anyOf: - type: string - type: 'null' title: Navigationsource - 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: 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_WorkloadJobResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Workload Jobs Query V2 Workloads Jobs Workload Hash Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Workload Jobs Query V2 Workloads Jobs Workload Hash Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/child_queries/{session_id}: get: tags: - QUERIES_V2 summary: Get Child Queries description: Get child queries for a specific session ID. operationId: get_child_queries_query_v2_workloads_child_queries__session_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: session_id in: path required: true schema: type: string title: Session Id - 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-19T12:35:37.687211' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.687265' 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/Page_WorkloadChildQueryResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Child Queries Query V2 Workloads Child Queries Session Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Child Queries Query V2 Workloads Child Queries Session Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/graph_data: get: tags: - QUERIES_V2 summary: Get Workloads Graph operationId: get_workloads_graph_query_v2_workloads_graph_data_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.694455' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.694537' title: End Date - name: workload_type in: query required: false schema: type: string title: Workload Type - 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/WorkloadGraphDataResponse' '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/graph_summary: get: tags: - QUERIES_V2 summary: Get Workloads Graph Summary description: Get workloads graph summary (total cost) for streamlit/notebook workloads operationId: get_workloads_graph_summary_query_v2_workloads_graph_summary_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.699941' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.700039' title: End Date - name: workload_type in: query required: false schema: type: string title: Workload Type - 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: type: object additionalProperties: true title: Response Get Workloads Graph Summary Query V2 Workloads Graph Summary Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/summary/{workload_hash}: get: tags: - QUERIES_V2 summary: Get Workloads Summary operationId: get_workloads_summary_query_v2_workloads_summary__workload_hash__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workload_hash in: path required: true schema: type: string title: Workload Hash - name: workload_type in: query required: false schema: type: string title: Workload Type - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.705320' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.705375' 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/WorkloadSummaryResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Workloads Summary Query V2 Workloads Summary Workload Hash Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Workloads Summary Query V2 Workloads Summary Workload Hash Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/stored-procedures/filters: get: tags: - QUERIES_V2 summary: Get Stored Procedures Workloads Filters operationId: get_stored_procedures_workloads_filters_query_v2_workloads_stored_procedures_filters_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-17T12:35:37.712097' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.712180' 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/StoredProceduresFilters' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Stored Procedures Workloads Filters Query V2 Workloads Stored Procedures Filters Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Stored Procedures Workloads Filters Query V2 Workloads Stored Procedures Filters Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/stored-procedures/list: get: tags: - QUERIES_V2 summary: Get Stored Procedures Workloads description: Get stored procedures workloads operationId: get_stored_procedures_workloads_query_v2_workloads_stored_procedures_list_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: sortAttribute in: query required: false schema: anyOf: - type: string - type: 'null' default: cost title: Sortattribute - name: sortOrder in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sortorder - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.718613' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.718666' title: End Date - name: warehouses in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Warehouses - name: databases in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Databases - 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_WorkloadPageResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Stored Procedures Workloads Query V2 Workloads Stored Procedures List Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Stored Procedures Workloads Query V2 Workloads Stored Procedures List Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/stored-procedures/graph_data: get: tags: - QUERIES_V2 summary: Get Stored Procedures Workloads Graph Data description: Get stored procedures workloads graph data operationId: get_stored_procedures_workloads_graph_data_query_v2_workloads_stored_procedures_graph_data_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.730613' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.730705' 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/WorkloadGraphDataResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Stored Procedures Workloads Graph Data Query V2 Workloads Stored Procedures Graph Data Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Stored Procedures Workloads Graph Data Query V2 Workloads Stored Procedures Graph Data Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/stored-procedures/graph_summary: get: tags: - QUERIES_V2 summary: Get Stored Procedures Workloads Graph Summary description: Get stored procedures workloads graph summary (total cost) operationId: get_stored_procedures_workloads_graph_summary_query_v2_workloads_stored_procedures_graph_summary_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.737787' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.737868' 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: type: object additionalProperties: true title: Response Get Stored Procedures Workloads Graph Summary Query V2 Workloads Stored Procedures Graph Summary Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Stored Procedures Workloads Graph Summary Query V2 Workloads Stored Procedures Graph Summary Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Stored Procedures Workloads Graph Summary Query V2 Workloads Stored Procedures Graph Summary Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/tasks/filters: get: tags: - QUERIES_V2 summary: Get Tasks Workloads Filters description: Get available filters (warehouses / databases / schemas) for Snowflake tasks. operationId: get_tasks_workloads_filters_query_v2_tasks_filters_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' 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/TaskWorkloadsFilters' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Tasks Workloads Filters Query V2 Tasks Filters Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Tasks Workloads Filters Query V2 Tasks Filters Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/tasks/list: get: tags: - QUERIES_V2 summary: Get Tasks Workloads description: 'Get Snowflake tasks from snowflake_tasks_aggregated, grouped by qualified task name plus warehouse and summed over the requested date range.' operationId: get_tasks_workloads_query_v2_tasks_list_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: sortAttribute in: query required: false schema: anyOf: - type: string - type: 'null' default: cost title: Sortattribute - name: sortOrder in: query required: false schema: anyOf: - type: string - type: 'null' default: DESC title: Sortorder - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: End Date - name: warehouses in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Warehouses - name: databases in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Databases - name: schemas in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Schemas - 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_TaskWorkloadResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Tasks Workloads Query V2 Tasks List Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Tasks Workloads Query V2 Tasks List Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/tasks/runs: get: tags: - QUERIES_V2 summary: Get Task Runs description: 'Individual runs of one Snowflake task (the drill-down opened when a task name is clicked), read from snowflake_task_history and filtered to the qualified (database_name, schema_name, name) triple. Summed metrics live on /tasks/list; this returns one row per run with derived per-run durations. The optional repeatable ``states`` query param narrows the per-run table to the given run states (e.g. ``?states=FAILED&states=EXECUTING``); absent or empty means "all states".' operationId: get_task_runs_query_v2_tasks_runs_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: database_name in: query required: true schema: type: string title: Database Name - name: schema_name in: query required: true schema: type: string title: Schema Name - name: name in: query required: true schema: type: string title: Name - 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: sortAttribute in: query required: false schema: anyOf: - type: string - type: 'null' default: scheduled_time title: Sortattribute - name: sortOrder in: query required: false schema: anyOf: - type: string - type: 'null' default: DESC title: Sortorder - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: End Date - name: states in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: States - 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_TaskRunResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Task Runs Query V2 Tasks Runs Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Task Runs Query V2 Tasks Runs Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/tasks/graph_data: get: tags: - QUERIES_V2 summary: Get Tasks Workloads Graph Data description: Get per-day total task cost time series. operationId: get_tasks_workloads_graph_data_query_v2_tasks_graph_data_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' 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/WorkloadGraphDataResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Tasks Workloads Graph Data Query V2 Tasks Graph Data Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Tasks Workloads Graph Data Query V2 Tasks Graph Data Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/tasks/graph_summary: get: tags: - QUERIES_V2 summary: Get Tasks Workloads Graph Summary description: Get total task cost (summary) for the requested window. operationId: get_tasks_workloads_graph_summary_query_v2_tasks_graph_summary_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' 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: type: object additionalProperties: true title: Response Get Tasks Workloads Graph Summary Query V2 Tasks Graph Summary Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Tasks Workloads Graph Summary Query V2 Tasks Graph Summary Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Tasks Workloads Graph Summary Query V2 Tasks Graph Summary Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/tasks/runs_graph_data: get: tags: - QUERIES_V2 summary: Get Task Runs Graph Data description: 'Per-day cost + runtime time series for ONE Snowflake task (the cost graph on the task-detail drill-down). Scoped to the qualified (database_name, schema_name, name) identity, summed across every warehouse the task ran on, read from snowflake_tasks_aggregated. ``start_date`` / ``end_date`` are optional (the UI date picker): when supplied the series is limited to that range; when omitted it covers the task''s full retained history. Warehouse RBAC is enforced inline (the rollup carries warehouse_name).' operationId: get_task_runs_graph_data_query_v2_tasks_runs_graph_data_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: database_name in: query required: true schema: type: string title: Database Name - name: schema_name in: query required: true schema: type: string title: Schema Name - name: name in: query required: true schema: type: string title: Name - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' 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/WorkloadGraphDataResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Task Runs Graph Data Query V2 Tasks Runs Graph Data Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Task Runs Graph Data Query V2 Tasks Runs Graph Data Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/tasks/runs_summary: get: tags: - QUERIES_V2 summary: Get Task Runs Summary description: 'Aggregate (summary cards) for ONE Snowflake task on the task-detail drill-down. Scoped to the qualified (database_name, schema_name, name) identity, summed across every warehouse the task ran on. ``start_date`` / ``end_date`` are optional (the UI date picker): when supplied the aggregate is limited to that range; when omitted it covers the task''s full retained history. Warehouse RBAC is enforced inline; a missing user_group_id on an RBAC tenant fails closed to a zeroed summary.' operationId: get_task_runs_summary_query_v2_tasks_runs_summary_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: database_name in: query required: true schema: type: string title: Database Name - name: schema_name in: query required: true schema: type: string title: Schema Name - name: name in: query required: true schema: type: string title: Name - name: start_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' title: Start Date - name: end_date in: query required: false schema: anyOf: - type: string format: date-time - type: 'null' 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/TaskRunsSummaryResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Task Runs Summary Query V2 Tasks Runs Summary Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Task Runs Summary Query V2 Tasks Runs Summary Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/stored-procedures/jobs_summary/{workload_hash}: get: tags: - QUERIES_V2 summary: Get Stored Procedures Workloads Summary operationId: get_stored_procedures_workloads_summary_query_v2_workloads_stored_procedures_jobs_summary__workload_hash__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workload_hash in: path required: true schema: type: string title: Workload Hash - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.805545' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.805632' 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/WorkloadSummaryResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Stored Procedures Workloads Summary Query V2 Workloads Stored Procedures Jobs Summary Workload Hash Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Stored Procedures Workloads Summary Query V2 Workloads Stored Procedures Jobs Summary Workload Hash Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/stored-procedures/jobs_graph_data/{workload_hash}: get: tags: - QUERIES_V2 summary: Get Stored Procedures Workload Jobs Graph Data description: Get jobs for a specific stored procedure workload hash. operationId: get_stored_procedures_workload_jobs_graph_data_query_v2_workloads_stored_procedures_jobs_graph_data__workload_hash__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workload_hash in: path required: true schema: type: string title: Workload Hash - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.812256' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.812342' title: End Date - name: num_of_records in: query required: false schema: type: integer default: 50 title: Num Of Records - 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: type: array items: $ref: '#/components/schemas/WorkloadStoredProcedureJobResponse' title: Response Get Stored Procedures Workload Jobs Graph Data Query V2 Workloads Stored Procedures Jobs Graph Data Workload Hash Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Stored Procedures Workload Jobs Graph Data Query V2 Workloads Stored Procedures Jobs Graph Data Workload Hash Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Stored Procedures Workload Jobs Graph Data Query V2 Workloads Stored Procedures Jobs Graph Data Workload Hash Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/stored-procedures/jobs/{workload_hash}: get: tags: - QUERIES_V2 summary: Get Stored Procedures Workload Jobs description: Get jobs for a specific stored procedure workload hash. operationId: get_stored_procedures_workload_jobs_query_v2_workloads_stored_procedures_jobs__workload_hash__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: workload_hash in: path required: true schema: type: string title: Workload Hash - name: start_date in: query required: false schema: type: string format: date-time default: '2026-06-19T12:35:37.823250' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.823336' title: End Date - 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: 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_WorkloadStoredProcedureJobResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Stored Procedures Workload Jobs Query V2 Workloads Stored Procedures Jobs Workload Hash Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Stored Procedures Workload Jobs Query V2 Workloads Stored Procedures Jobs Workload Hash Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/v2/workloads/stored-procedures/child_queries/{query_id}: get: tags: - QUERIES_V2 summary: Get Stored Procedures Child Queries description: Get child queries for a specific query id. operationId: get_stored_procedures_child_queries_query_v2_workloads_stored_procedures_child_queries__query_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: query_id in: path required: true schema: type: string title: Query Id - 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-19T12:35:37.834534' title: Start Date - name: end_date in: query required: false schema: type: string format: date-time default: '2026-07-17T12:35:37.834593' 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/Page_WorkloadStoredProcedureChildQueryResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Stored Procedures Child Queries Query V2 Workloads Stored Procedures Child Queries Query Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Stored Procedures Child Queries Query V2 Workloads Stored Procedures Child Queries Query Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' components: schemas: QueryTag: properties: tag_rk: type: string title: Tag Rk reason: type: string title: Reason reports: anyOf: - items: $ref: '#/components/schemas/Report' type: array - type: 'null' title: Reports tag_icon_text: anyOf: - type: string - type: 'null' title: Tag Icon Text description: anyOf: - type: string - type: 'null' title: Description type: object required: - tag_rk - reason title: QueryTag Page_WorkloadStoredProcedureChildQueryResponse_: properties: items: items: $ref: '#/components/schemas/WorkloadStoredProcedureChildQueryResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[WorkloadStoredProcedureChildQueryResponse] Page_SnowflakeJobTaskAggregatePageResponse_: properties: items: items: $ref: '#/components/schemas/SnowflakeJobTaskAggregatePageResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[SnowflakeJobTaskAggregatePageResponse] TaskSummaryResponse: properties: total_cost: type: number title: Total Cost avg_cost: type: number title: Avg Cost avg_execution_time: type: number title: Avg Execution Time max_execution_time: type: number title: Max Execution Time run_count: type: integer title: Run Count total_bytes_scanned: type: number title: Total Bytes Scanned avg_bytes_scanned: type: number title: Avg Bytes Scanned type: object required: - total_cost - avg_cost - avg_execution_time - max_execution_time - run_count - total_bytes_scanned - avg_bytes_scanned title: TaskSummaryResponse Page_TaskRunResponse_: properties: items: items: $ref: '#/components/schemas/TaskRunResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[TaskRunResponse] StoredProceduresFilters: properties: warehouses: items: type: string type: array title: Warehouses default: [] workflow_ids: items: type: string type: array title: Workflow Ids default: [] teams: items: type: string type: array title: Teams default: [] apps: items: type: string type: array title: Apps default: [] workflow_ids_with_labels: items: $ref: '#/components/schemas/app__schemas__queries__FilterResponse' type: array title: Workflow Ids With Labels default: [] databases: items: type: string type: array title: Databases default: [] type: object title: StoredProceduresFilters description: 'Filters for /workloads/stored-procedures/filters. Carried the pre-AI-6471 SnowflakeJobFilters shape (with workflow_ids and workflow_ids_with_labels) since the stored-procedures FE consumer expects those fields. Split off from SnowflakeJobFilters so the snowflake_jobs filter contract can evolve independently of this one. Only `warehouses` is ever populated for stored procedures today; the rest are kept as empty defaults for FE back-compat.' Page_DbtJobListingPageResponse_: properties: items: items: $ref: '#/components/schemas/DbtJobListingPageResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[DbtJobListingPageResponse] Page_WorkloadStoredProcedureJobResponse_: properties: items: items: $ref: '#/components/schemas/WorkloadStoredProcedureJobResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[WorkloadStoredProcedureJobResponse] PaginatedLabeledValuesResponse: properties: values: items: $ref: '#/components/schemas/app__schemas__queries__FilterResponse' type: array title: Values total: type: integer title: Total page: type: integer title: Page size: type: integer title: Size total_pages: type: integer title: Total Pages type: object required: - values - total - page - size - total_pages title: PaginatedLabeledValuesResponse SnowflakeJobRunCompareRequest: properties: workflow_id: type: string title: Workflow Id run1_id: type: string title: Run1 Id run2_id: type: string title: Run2 Id type: object required: - workflow_id - run1_id - run2_id title: SnowflakeJobRunCompareRequest SnowflakeJobDefinitionResponse: properties: run_id: type: string title: Run Id timestamp: type: string title: Timestamp definition: items: $ref: '#/components/schemas/SnowflakeJobDefinition' type: array title: Definition type: object required: - run_id - timestamp - definition title: SnowflakeJobDefinitionResponse DbtJobListingPageResponse: properties: command_display: type: string title: Command Display command_which: type: string title: Command Which query_cost: type: number title: Query Cost bytes_scanned: type: integer title: Bytes Scanned execution_time: type: number title: Execution Time run_count: type: integer title: Run Count success_count: type: integer title: Success Count last_runtime: anyOf: - type: string format: date-time - type: 'null' title: Last Runtime warehouses: items: type: string type: array title: Warehouses tags: anyOf: - items: type: string type: array - type: 'null' title: Tags dbt_cloud_job_id: anyOf: - type: string - type: 'null' title: Dbt Cloud Job Id type: object required: - command_display - command_which - query_cost - bytes_scanned - execution_time - run_count - success_count - warehouses title: DbtJobListingPageResponse description: 'Response for the dbt Jobs tab listing. A "Job" is a unique dbt command fingerprint (e.g., "dbt build --select model+ --target PROD"). All invocations with the same command are grouped together. Works for both dbt Core and dbt Cloud. The command_display field is the stable identifier for each job.' Page_TaskWorkloadResponse_: properties: items: items: $ref: '#/components/schemas/TaskWorkloadResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[TaskWorkloadResponse] QueryFetchAllPageResponse: properties: id: type: string title: Id query_id: type: string title: Query Id query_type: type: string title: Query Type query_hash: anyOf: - type: string - type: 'null' title: Query Hash query_parameterized_hash: anyOf: - type: string - type: 'null' title: Query Parameterized Hash bytes_scanned: anyOf: - type: string - type: 'null' title: Bytes Scanned session_id: anyOf: - type: integer - type: 'null' title: Session Id query_text: anyOf: - type: string - type: 'null' title: Query Text query_trimmed: anyOf: - type: string - type: 'null' title: Query Trimmed query_name: anyOf: - type: string - type: 'null' title: Query Name query_cost: anyOf: - type: number - type: 'null' title: Query Cost execution_time: anyOf: - type: string - type: 'null' title: Execution Time insights: anyOf: - items: type: string type: array - type: 'null' title: Insights start_time: anyOf: - type: string - type: 'null' title: Start Time end_time: anyOf: - type: string - type: 'null' title: End Time warehouse_name: anyOf: - type: string - type: 'null' title: Warehouse Name user_name: anyOf: - type: string - type: 'null' title: User Name role_name: anyOf: - type: string - type: 'null' title: Role Name warehouse_size: anyOf: - type: string - type: 'null' title: Warehouse Size partitions_scanned: anyOf: - type: string - type: 'null' title: Partitions Scanned partitions_total: anyOf: - type: string - type: 'null' title: Partitions Total percentage_scanned_from_cache: anyOf: - type: number - type: 'null' title: Percentage Scanned From Cache bytes_spilled_to_local_storage: anyOf: - type: string - type: 'null' title: Bytes Spilled To Local Storage bytes_spilled_to_remote_storage: anyOf: - type: string - type: 'null' title: Bytes Spilled To Remote Storage bytes_sent_over_network: anyOf: - type: string - type: 'null' title: Bytes Sent Over Network queued_overload_time: anyOf: - type: string - type: 'null' title: Queued Overload Time queued_provisioning_time: anyOf: - type: string - type: 'null' title: Queued Provisioning Time queued_repair_time: anyOf: - type: string - type: 'null' title: Queued Repair Time query_load_percent: anyOf: - type: string - type: 'null' title: Query Load Percent data_store_id: anyOf: - type: string - type: 'null' title: Data Store Id datasets: anyOf: - items: type: string type: array - type: 'null' title: Datasets instance_id: anyOf: - type: integer - type: 'null' title: Instance Id query_tag: anyOf: - additionalProperties: true type: object - type: 'null' title: Query Tag type: object required: - id - query_id - query_type title: QueryFetchAllPageResponse QueryGroupPageItem: properties: query_hash: type: string title: Query Hash trimmed_query: type: string title: Trimmed Query full_query: anyOf: - type: string - type: 'null' title: Full Query total_run: type: integer title: Total Run avg_exec_time: type: string title: Avg Exec Time avg_cost: type: number title: Avg Cost total_cost: type: number title: Total Cost annualized_cost: type: number title: Annualized Cost distinct_warehouses: type: integer title: Distinct Warehouses distinct_users: type: integer title: Distinct Users distinct_roles: anyOf: - type: integer - type: 'null' title: Distinct Roles tags: items: type: string type: array title: Tags users: items: type: string type: array title: Users warehouses: items: type: string type: array title: Warehouses roles: anyOf: - items: type: string type: array - type: 'null' title: Roles instance_id: anyOf: - type: integer - type: 'null' title: Instance Id type: object required: - query_hash - trimmed_query - total_run - avg_exec_time - avg_cost - total_cost - annualized_cost - distinct_warehouses - distinct_users - tags - users - warehouses title: QueryGroupPageItem QueryCustomTag: properties: reason: anyOf: - type: string - type: 'null' title: Reason user: anyOf: - type: integer - type: 'null' title: User type: object title: QueryCustomTag QueryIndicesResponse: properties: spans: additionalProperties: true type: object title: Spans query_text: type: string title: Query Text type: object required: - spans - query_text title: QueryIndicesResponse app__schemas__queries__QuerySqlLineageResponse: properties: is_lineage: type: boolean title: Is Lineage tableEdges: items: prefixItems: - type: string - type: string type: array maxItems: 2 minItems: 2 type: array title: Tableedges details: additionalProperties: true type: object title: Details nodePositions: anyOf: - additionalProperties: prefixItems: - type: number - type: number type: array maxItems: 2 minItems: 2 type: object - type: 'null' title: Nodepositions query_tags_meta: additionalProperties: true type: object title: Query Tags Meta tags: items: additionalProperties: true type: object type: array title: Tags default: [] is_error: type: boolean title: Is Error default: false type: object required: - is_lineage - tableEdges - details - query_tags_meta title: QuerySqlLineageResponse CustomTagValuesResponse: properties: values: items: type: string type: array title: Values total: type: integer title: Total page: type: integer title: Page size: type: integer title: Size type: object required: - values - total - page - size title: CustomTagValuesResponse description: Response schema for distinct custom tag values from query_tag JSON column. DbtJobFilterResponse: properties: items: items: $ref: '#/components/schemas/DbtJobFilterItem' type: array title: Items total: type: integer title: Total page: type: integer title: Page size: type: integer title: Size type: object required: - items - total - page - size title: DbtJobFilterResponse QueryHashTextResponse: properties: query_text: anyOf: - type: string - type: 'null' title: Query Text type: object title: QueryHashTextResponse app__schemas__queries__FilterResponse: properties: label: type: string title: Label value: type: string title: Value type: object required: - label - value title: FilterResponse SnowflakeIndividualJobRunPageResponse: properties: run_id: type: string title: Run Id query_id: anyOf: - type: string - type: 'null' title: Query Id query_cost: type: number title: Query Cost bytes_scanned: type: integer title: Bytes Scanned execution_time: type: number title: Execution Time start_time: type: string format: date-time title: Start Time execution_status: type: string title: Execution Status warehouse_name: type: string title: Warehouse Name timestamp: anyOf: - type: string format: date-time - type: 'null' title: Timestamp query_parameterized_hash: anyOf: - type: string - type: 'null' title: Query Parameterized Hash error_message: anyOf: - type: string - type: 'null' title: Error Message insights: items: type: string type: array title: Insights annotation: anyOf: - $ref: '#/components/schemas/RunEvents' - type: 'null' total_queries: anyOf: - type: integer - type: 'null' title: Total Queries type: object required: - run_id - query_cost - bytes_scanned - execution_time - start_time - execution_status - warehouse_name - timestamp title: SnowflakeIndividualJobRunPageResponse HTTPValidationError: properties: detail: items: $ref: '#/components/schemas/ValidationError' type: array title: Detail type: object title: HTTPValidationError IntegrationWithEnvironments: properties: name: type: string title: Name environments: items: type: string type: array title: Environments type: object required: - name - environments title: IntegrationWithEnvironments DbtTagFilterResponse: properties: items: items: $ref: '#/components/schemas/DbtTagFilterItem' type: array title: Items total: type: integer title: Total page: type: integer title: Page size: type: integer title: Size type: object required: - items - total - page - size title: DbtTagFilterResponse WorkloadStoredProcedureChildQueryResponse: properties: query_type: type: string title: Query Type query_tag: type: string title: Query Tag query_id: type: string title: Query Id rk: type: string title: Rk query_summary: type: string title: Query Summary start_time: type: string format: date-time title: Start Time end_time: type: string format: date-time title: End Time warehouse_name: type: string title: Warehouse Name execution_status: type: string title: Execution Status execution_time: type: number title: Execution Time bytes_scanned: type: number title: Bytes Scanned cost: type: number title: Cost hash: type: string title: Hash has_child_queries: type: boolean title: Has Child Queries type: object required: - query_type - query_tag - query_id - rk - query_summary - start_time - end_time - warehouse_name - execution_status - execution_time - bytes_scanned - cost - hash - has_child_queries title: WorkloadStoredProcedureChildQueryResponse TaskWorkloadResponse: properties: database_name: type: string title: Database Name schema_name: type: string title: Schema Name name: type: string title: Name warehouse_name: type: string title: Warehouse Name run_count: type: integer title: Run Count success_count: type: integer title: Success Count failure_count: type: integer title: Failure Count execution_time_ms: type: number title: Execution Time Ms queued_time_ms: type: number title: Queued Time Ms cost: type: number title: Cost compute_cost: type: number title: Compute Cost serverless_cost: type: number title: Serverless Cost credits_used: type: number title: Credits Used serverless_credits_used: type: number title: Serverless Credits Used type: object required: - database_name - schema_name - name - warehouse_name - run_count - success_count - failure_count - execution_time_ms - queued_time_ms - cost - compute_cost - serverless_cost - credits_used - serverless_credits_used title: TaskWorkloadResponse description: 'One aggregated Snowflake task row for /tasks/list. Rows are grouped by the qualified task name plus warehouse (``database_name``, ``schema_name``, ``name``, ``warehouse_name``) and summed across the requested date range — mirroring the stored-procedures listing shape. ``warehouse_name`` is empty for serverless tasks.' DbtJobFilterItem: properties: command_display: type: string title: Command Display type: object required: - command_display title: DbtJobFilterItem DbtJobTasksSummaryResponse: properties: total_cost: type: number minimum: 0.0 title: Total Cost description: Total cost across all DBT task types model_cost: type: number minimum: 0.0 title: Model Cost description: Cost for DBT model tasks test_cost: type: number minimum: 0.0 title: Test Cost description: Cost for DBT test tasks seed_cost: type: number minimum: 0.0 title: Seed Cost description: Cost for DBT seed tasks snapshot_cost: type: number minimum: 0.0 title: Snapshot Cost description: Cost for DBT snapshot tasks test_coverage: anyOf: - type: number maximum: 100.0 minimum: 0.0 - type: 'null' title: Test Coverage description: Test coverage percentage (0-100) type: object required: - total_cost - model_cost - test_cost - seed_cost - snapshot_cost title: DbtJobTasksSummaryResponse description: Response model for DBT job tasks summary with cost breakdown by task type. Page_SnowflakeJobRunPageResponse_: properties: items: items: $ref: '#/components/schemas/SnowflakeJobRunPageResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[SnowflakeJobRunPageResponse] QueryFiltersFetchAllResponse: properties: tags: anyOf: - items: $ref: '#/components/schemas/app__schemas__queries__TagObject' type: array - type: 'null' title: Tags warehouses: anyOf: - items: anyOf: - type: string - type: 'null' type: array - type: 'null' title: Warehouses users: anyOf: - items: anyOf: - type: string - type: 'null' type: array - type: 'null' title: Users query_types: anyOf: - items: anyOf: - type: string - type: 'null' type: array - type: 'null' title: Query Types roles: anyOf: - items: anyOf: - type: string - type: 'null' type: array - type: 'null' title: Roles ok: type: boolean title: Ok error_code: anyOf: - type: string - type: 'null' title: Error Code message: anyOf: - type: string - type: 'null' title: Message total: anyOf: - type: integer - type: 'null' title: Total page: anyOf: - type: integer - type: 'null' title: Page size: anyOf: - type: integer - type: 'null' title: Size total_pages: anyOf: - type: integer - type: 'null' title: Total Pages type: object required: - ok title: QueryFiltersFetchAllResponse TaskWorkloadsFilters: properties: warehouses: items: type: string type: array title: Warehouses default: [] databases: items: type: string type: array title: Databases default: [] schemas: items: type: string type: array title: Schemas default: [] type: object title: TaskWorkloadsFilters description: 'Filters for /tasks/filters. Available dropdown values for the Snowflake tasks listing, sourced from ``snowflake_tasks_aggregated``. Serverless tasks carry an empty ``warehouse_name``; blank values are dropped so the dropdowns stay clean.' Page_Dict_: properties: items: items: additionalProperties: true type: object type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[Dict] Page_QueryFetchAllPageResponse_: properties: items: items: $ref: '#/components/schemas/QueryFetchAllPageResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[QueryFetchAllPageResponse] TaskRunsSummaryResponse: properties: database_name: type: string title: Database Name schema_name: type: string title: Schema Name name: type: string title: Name total_cost: type: number title: Total Cost avg_cost: type: number title: Avg Cost run_count: type: integer title: Run Count success_count: type: integer title: Success Count failure_count: type: integer title: Failure Count execution_time_ms: type: number title: Execution Time Ms queued_time_ms: type: number title: Queued Time Ms avg_execution_time_ms: type: number title: Avg Execution Time Ms avg_queued_time_ms: type: number title: Avg Queued Time Ms compute_cost: type: number title: Compute Cost serverless_cost: type: number title: Serverless Cost credits_used: type: number title: Credits Used serverless_credits_used: type: number title: Serverless Credits Used last_run_date: anyOf: - type: string format: date - type: 'null' title: Last Run Date type: object required: - database_name - schema_name - name - total_cost - avg_cost - run_count - success_count - failure_count - execution_time_ms - queued_time_ms - avg_execution_time_ms - avg_queued_time_ms - compute_cost - serverless_cost - credits_used - serverless_credits_used title: TaskRunsSummaryResponse description: 'Window aggregate (summary cards) for ONE task on the task-detail page. Sourced from ``snowflake_tasks_aggregated`` and scoped to a single qualified task (``database_name``, ``schema_name``, ``name``), summed across every warehouse the task ran on. Mirrors the stored-procedures ``WorkloadSummaryResponse`` summary-cards shape for the task side. Counts and times default to zero (and ``last_run_date`` to ``None``) when no runs are visible in the window.' QueryGroupMetricsResponse: properties: num_runs: type: integer title: Num Runs total_cost: type: string title: Total Cost avg_execution_time: type: string title: Avg Execution Time last_run_time: type: string title: Last Run Time max_cost_savings: type: string title: Max Cost Savings max_time_savings: type: string title: Max Time Savings type: object required: - num_runs - total_cost - avg_execution_time - last_run_time - max_cost_savings - max_time_savings title: QueryGroupMetricsResponse SnowflakeJobFetchAllPageResponse: properties: workflow_id: type: string title: Workflow Id query_cost: type: number title: Query Cost bytes_scanned: type: integer title: Bytes Scanned execution_time: type: number title: Execution Time last_runtime: type: number title: Last Runtime max_runtime: type: number title: Max Runtime min_runtime: type: number title: Min Runtime runs: type: number title: Runs warehouse_names: items: type: string type: array title: Warehouse Names teams: items: type: string type: array title: Teams apps: items: type: string type: array title: Apps dbt_project_name: anyOf: - type: string - type: 'null' title: Dbt Project Name tableau_dashboard_name: anyOf: - type: string - type: 'null' title: Tableau Dashboard Name integration_name: anyOf: - type: string - type: 'null' title: Integration Name integration_environment: anyOf: - type: string - type: 'null' title: Integration Environment test_coverage: anyOf: - type: string - type: 'null' title: Test Coverage instance_id: anyOf: - type: integer - type: 'null' title: Instance Id type: object required: - workflow_id - query_cost - bytes_scanned - execution_time - last_runtime - max_runtime - min_runtime - runs - warehouse_names - teams - apps title: SnowflakeJobFetchAllPageResponse DbtTagFilterItem: properties: tag: type: string title: Tag type: object required: - tag title: DbtTagFilterItem WorkloadStoredProcedureJobResponse: properties: query_id: type: string title: Query Id query_summary: type: string title: Query Summary query_cost: type: number title: Query Cost execution_status: type: string title: Execution Status bytes_scanned: type: number title: Bytes Scanned execution_time: type: number title: Execution Time start_time: type: string format: date-time title: Start Time timestamp: type: string format: date-time title: Timestamp database_name: anyOf: - type: string - type: 'null' title: Database Name type: object required: - query_id - query_summary - query_cost - execution_status - bytes_scanned - execution_time - start_time - timestamp title: WorkloadStoredProcedureJobResponse WorkloadJobResponse: properties: session_id: type: integer title: Session Id query_summary: type: string title: Query Summary query_cost: type: number title: Query Cost execution_status: type: string title: Execution Status bytes_scanned: type: number title: Bytes Scanned execution_time: type: number title: Execution Time start_time: type: string format: date-time title: Start Time timestamp: type: string format: date-time title: Timestamp type: object required: - session_id - query_summary - query_cost - execution_status - bytes_scanned - execution_time - start_time - timestamp title: WorkloadJobResponse WorkloadSummaryResponse: properties: query_type: type: string title: Query Type total_cost: type: number title: Total Cost avg_cost: type: number title: Avg Cost avg_execution_time: type: number title: Avg Execution Time max_execution_time: type: number title: Max Execution Time min_execution_time: type: number title: Min Execution Time run_count: type: integer title: Run Count success_count: type: integer title: Success Count total_bytes_scanned: type: number title: Total Bytes Scanned avg_bytes_scanned: type: number title: Avg Bytes Scanned last_run_time: type: string format: date-time title: Last Run Time max_cost_savings: type: number title: Max Cost Savings max_time_savings: type: number title: Max Time Savings type: object required: - query_type - total_cost - avg_cost - avg_execution_time - max_execution_time - min_execution_time - run_count - success_count - total_bytes_scanned - avg_bytes_scanned - last_run_time - max_cost_savings - max_time_savings title: WorkloadSummaryResponse WorkloadGraphDataResponse: properties: data: items: additionalProperties: true type: object type: array title: Data type: object required: - data title: WorkloadGraphDataResponse WorkloadPageResponse: properties: hash: type: string title: Hash query_summary: type: string title: Query Summary job_count: type: integer title: Job Count cost: type: number title: Cost query_type: type: string title: Query Type bytes_scanned: type: number title: Bytes Scanned execution_time: type: number title: Execution Time warehouse_names: items: type: string type: array title: Warehouse Names database_names: items: type: string type: array title: Database Names type: object required: - hash - query_summary - job_count - cost - query_type - bytes_scanned - execution_time - warehouse_names - database_names title: WorkloadPageResponse SnowflakeJobSettings: properties: prefix: anyOf: - type: string - type: 'null' title: Prefix workflow_id: type: string title: Workflow Id run_id: anyOf: - type: string - type: 'null' title: Run Id task_id: anyOf: - type: string - type: 'null' title: Task Id project_id: type: string title: Project Id app_id: type: string title: App Id custom_tags: anyOf: - items: type: string type: array maxItems: 15 - type: 'null' title: Custom Tags description: List of custom tag keys for filtering (max 15 tags per workload) type: object required: - workflow_id - project_id - app_id title: SnowflakeJobSettings SnowflakeJobGraphDataRequest: properties: aggregate_by: type: string title: Aggregate By type: object required: - aggregate_by title: SnowflakeJobGraphDataRequest QueryObjectV2: properties: id: type: string title: Id query_id: type: string title: Query Id query_text: anyOf: - type: string - type: 'null' title: Query Text query_type: type: string title: Query Type query_hash: anyOf: - type: string - type: 'null' title: Query Hash tags: anyOf: - items: additionalProperties: true type: object type: array - type: 'null' title: Tags timestamp: anyOf: - type: string - type: 'null' title: Timestamp warehouse_name: anyOf: - type: string - type: 'null' title: Warehouse Name warehouse_size: anyOf: - type: string - type: 'null' title: Warehouse Size user_name: anyOf: - type: string - type: 'null' title: User Name execution_time: anyOf: - type: string - type: 'null' title: Execution Time currency: anyOf: - type: string - type: 'null' title: Currency cost: anyOf: - type: string - type: 'null' title: Cost percent_partition_scanned: anyOf: - type: string - type: 'null' title: Percent Partition Scanned bytes_spilled: anyOf: - type: string - type: 'null' title: Bytes Spilled data_store_id: anyOf: - type: integer - type: 'null' title: Data Store Id start_time: anyOf: - type: string - type: 'null' title: Start Time custom_tag: anyOf: - $ref: '#/components/schemas/QueryCustomTag' - type: 'null' percentage_scanned_from_cache: anyOf: - type: string - type: 'null' title: Percentage Scanned From Cache query_load_percent: anyOf: - type: string - type: 'null' title: Query Load Percent query_hash_count: anyOf: - type: integer - type: 'null' title: Query Hash Count opportunities: anyOf: - items: additionalProperties: true type: object type: array - type: 'null' title: Opportunities instance_id: anyOf: - type: integer - type: 'null' title: Instance Id type: object required: - id - query_id - query_type title: QueryObjectV2 JobRunGraphResponse: properties: run_id: anyOf: - type: string - type: 'null' title: Run Id timestamp: type: string format: date-time title: Timestamp start_time: anyOf: - type: string format: date-time - type: 'null' title: Start Time query_cost: type: number title: Query Cost execution_time: type: number title: Execution Time annotation: anyOf: - $ref: '#/components/schemas/RunEvents' - type: 'null' type: object required: - timestamp - query_cost - execution_time title: JobRunGraphResponse description: Lightweight response for runs graph — only fields needed for charting. WorkloadType: type: string enum: - NOTEBOOK - STREAMLIT - STORED_PROCEDURE - UNKNOWN title: WorkloadType RunDiff: properties: type: type: string title: Type task_id: type: string title: Task Id run1: $ref: '#/components/schemas/TaskInfo' run2: $ref: '#/components/schemas/TaskInfo' type: object required: - type - task_id - run1 - run2 title: RunDiff Page_WorkloadChildQueryResponse_: properties: items: items: $ref: '#/components/schemas/WorkloadChildQueryResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[WorkloadChildQueryResponse] Page_QueryGroupPageItem_: properties: items: items: $ref: '#/components/schemas/QueryGroupPageItem' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[QueryGroupPageItem] WorkloadChildQueryResponse: properties: query_type: type: string title: Query Type query_tag: type: string title: Query Tag session_id: type: integer title: Session Id rk: type: string title: Rk query_summary: type: string title: Query Summary start_time: type: string format: date-time title: Start Time end_time: type: string format: date-time title: End Time warehouse_name: type: string title: Warehouse Name execution_status: type: string title: Execution Status execution_time: type: number title: Execution Time bytes_scanned: type: number title: Bytes Scanned cost: type: number title: Cost hash: type: string title: Hash type: object required: - query_type - query_tag - session_id - rk - query_summary - start_time - end_time - warehouse_name - execution_status - execution_time - bytes_scanned - cost - hash title: WorkloadChildQueryResponse QueryIndicesRequest: properties: spans: items: type: string type: array title: Spans type: object required: - spans title: QueryIndicesRequest QueryFetchResponseV2: properties: query: anyOf: - $ref: '#/components/schemas/QueryObjectV2' - type: 'null' ok: type: boolean title: Ok error_code: anyOf: - type: string - type: 'null' title: Error Code message: anyOf: - type: string - type: 'null' title: Message type: object required: - ok title: QueryFetchResponseV2 Report: properties: query_span: anyOf: - type: string - type: 'null' title: Query Span description: anyOf: - type: string - type: 'null' title: Description indices: anyOf: - items: prefixItems: - prefixItems: - type: integer - type: integer type: array maxItems: 2 minItems: 2 - prefixItems: - type: integer - type: integer type: array maxItems: 2 minItems: 2 type: array maxItems: 2 minItems: 2 type: array - type: 'null' title: Indices metadata: anyOf: - additionalProperties: true type: object - type: 'null' title: Metadata type: object title: Report SnowflakeJobFilters: properties: warehouses: items: type: string type: array title: Warehouses default: [] custom_tag_keys: items: type: string type: array title: Custom Tag Keys default: [] teams: items: type: string type: array title: Teams default: [] apps: items: type: string type: array title: Apps default: [] integration_names: items: type: string type: array title: Integration Names default: [] integration_environments: items: type: string type: array title: Integration Environments default: [] integrations_with_environments: items: $ref: '#/components/schemas/IntegrationWithEnvironments' type: array title: Integrations With Environments default: [] type: object title: SnowflakeJobFilters description: 'Bulk bounded-facet filters (AI-6471). Returned by GET /query/v2/snowflake_jobs/filters/. Unbounded facets (workflow_ids, custom-tag values, etc.) are served from per-facet paginated endpoints — see the /snowflake_jobs/filters/ endpoints in app/api/queries_v2.py.' Page_WorkloadPageResponse_: properties: items: items: $ref: '#/components/schemas/WorkloadPageResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[WorkloadPageResponse] QueryObject: properties: id: type: string title: Id query_id: type: string title: Query Id query_text: anyOf: - type: string - type: 'null' title: Query Text query_type: type: string title: Query Type tags: anyOf: - items: $ref: '#/components/schemas/QueryTag' type: array - type: 'null' title: Tags timestamp: anyOf: - type: string - type: 'null' title: Timestamp warehouse_name: anyOf: - type: string - type: 'null' title: Warehouse Name warehouse_size: anyOf: - type: string - type: 'null' title: Warehouse Size user_name: anyOf: - type: string - type: 'null' title: User Name execution_time: anyOf: - type: string - type: 'null' title: Execution Time currency: anyOf: - type: string - type: 'null' title: Currency cost: anyOf: - type: string - type: 'null' title: Cost percent_partition_scanned: anyOf: - type: string - type: 'null' title: Percent Partition Scanned bytes_spilled: anyOf: - type: string - type: 'null' title: Bytes Spilled data_store_id: anyOf: - type: integer - type: 'null' title: Data Store Id start_time: anyOf: - type: string - type: 'null' title: Start Time custom_tag: anyOf: - $ref: '#/components/schemas/QueryCustomTag' - type: 'null' percentage_scanned_from_cache: anyOf: - type: string - type: 'null' title: Percentage Scanned From Cache query_load_percent: anyOf: - type: string - type: 'null' title: Query Load Percent query_hash_count: anyOf: - type: integer - type: 'null' title: Query Hash Count type: object required: - id - query_id - query_type title: QueryObject ValidationError: properties: loc: items: anyOf: - type: string - type: integer type: array title: Location msg: type: string title: Message type: type: string title: Error Type type: object required: - loc - msg - type title: ValidationError SnowflakeJobDefinition: properties: task_id: type: string title: Task Id query_cost: type: number title: Query Cost execution_time: type: number title: Execution Time run_count: type: integer title: Run Count success_count: type: integer title: Success Count insights: items: type: string type: array title: Insights default: [] hash: anyOf: - type: string - type: 'null' title: Hash type: object required: - task_id - query_cost - execution_time - run_count - success_count title: SnowflakeJobDefinition QueryFetchResponse: properties: query: anyOf: - $ref: '#/components/schemas/QueryObject' - type: 'null' ok: type: boolean title: Ok error_code: anyOf: - type: string - type: 'null' title: Error Code message: anyOf: - type: string - type: 'null' title: Message type: object required: - ok title: QueryFetchResponse TaskRunResponse: properties: run_id: type: integer title: Run Id attempt_number: type: integer title: Attempt Number name: type: string title: Name database_name: type: string title: Database Name schema_name: type: string title: Schema Name task_database_id: anyOf: - type: integer - type: 'null' title: Task Database Id task_schema_id: anyOf: - type: integer - type: 'null' title: Task Schema Id root_task_id: anyOf: - type: string - type: 'null' title: Root Task Id graph_version: anyOf: - type: integer - type: 'null' title: Graph Version graph_run_group_id: anyOf: - type: string - type: 'null' title: Graph Run Group Id state: type: string title: State scheduled_from: anyOf: - type: string - type: 'null' title: Scheduled From scheduled_time: type: string format: date-time title: Scheduled Time query_start_time: anyOf: - type: string format: date-time - type: 'null' title: Query Start Time completed_time: anyOf: - type: string format: date-time - type: 'null' title: Completed Time queued_time_ms: anyOf: - type: integer - type: 'null' title: Queued Time Ms execution_time_ms: anyOf: - type: integer - type: 'null' title: Execution Time Ms error_code: anyOf: - type: string - type: 'null' title: Error Code error_message: anyOf: - type: string - type: 'null' title: Error Message return_value: anyOf: - type: string - type: 'null' title: Return Value query_id: type: string title: Query Id condition_text: anyOf: - type: string - type: 'null' title: Condition Text config: anyOf: - type: string - type: 'null' title: Config backfill_info: anyOf: - type: string - type: 'null' title: Backfill Info type: object required: - run_id - attempt_number - name - database_name - schema_name - state - scheduled_time - query_id title: TaskRunResponse description: 'One individual Snowflake task run for /tasks/runs (the name-click drill-down). Sourced from ``snowflake_task_history`` and filtered to a single qualified task (``database_name``, ``schema_name``, ``name``); each row is one run. ``queued_time_ms`` and ``execution_time_ms`` are DERIVED from the run timestamps (the history table stores no duration columns) — ``queued_time_ms`` is ``query_start_time - scheduled_time`` and ``execution_time_ms`` is ``completed_time - query_start_time``; both are ``null`` when the run never started or never completed. ``query_id`` is the click-through target to the query-detail view.' Page_WorkloadJobResponse_: properties: items: items: $ref: '#/components/schemas/WorkloadJobResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[WorkloadJobResponse] PaginatedStringValuesResponse: properties: values: items: type: string type: array title: Values total: type: integer title: Total page: type: integer title: Page size: type: integer title: Size total_pages: type: integer title: Total Pages type: object required: - values - total - page - size - total_pages title: PaginatedStringValuesResponse app__schemas__queries__TagObject: properties: name: type: string title: Name description: type: string title: Description cost_savings: type: boolean title: Cost Savings time_savings: type: boolean title: Time Savings type: object required: - name - description - cost_savings - time_savings title: TagObject TaskInfo: properties: execution_time: anyOf: - type: number - type: 'null' title: Execution Time query_cost: anyOf: - type: number - type: 'null' title: Query Cost execution_status: anyOf: - type: string - type: 'null' title: Execution Status error_message: anyOf: - type: string - type: 'null' title: Error Message warehouse_name: anyOf: - type: string - type: 'null' title: Warehouse Name warehouse_size: anyOf: - type: string - type: 'null' title: Warehouse Size query_hash: anyOf: - type: string - type: 'null' title: Query Hash type: object title: TaskInfo Page_SnowflakeIndividualJobRunPageResponse_: properties: items: items: $ref: '#/components/schemas/SnowflakeIndividualJobRunPageResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[SnowflakeIndividualJobRunPageResponse] QueryGroupResponse: properties: query_hash: type: string title: Query Hash query_name: anyOf: - type: string - type: 'null' title: Query Name trimmed_query: type: string title: Trimmed Query full_query: anyOf: - type: string - type: 'null' title: Full Query total_run: type: string title: Total Run avg_exec_time: type: string title: Avg Exec Time avg_cost: type: string title: Avg Cost total_cost: type: string title: Total Cost annualized_cost: type: string title: Annualized Cost distinct_warehouses: type: integer title: Distinct Warehouses distinct_users: type: integer title: Distinct Users distinct_roles: anyOf: - type: integer - type: 'null' title: Distinct Roles tags: items: type: string type: array title: Tags type: object required: - query_hash - trimmed_query - total_run - avg_exec_time - avg_cost - total_cost - annualized_cost - distinct_warehouses - distinct_users - tags title: QueryGroupResponse SnowflakeJobRunPageResponse: properties: run_id: type: string title: Run Id query_cost: type: number title: Query Cost bytes_scanned: type: integer title: Bytes Scanned execution_time: type: number title: Execution Time timestamp: type: string format: date-time title: Timestamp start_time: type: string format: date-time title: Start Time success_count: type: integer title: Success Count total_count: type: integer title: Total Count warehouses: items: type: string type: array title: Warehouses annotation: anyOf: - $ref: '#/components/schemas/RunEvents' - type: 'null' query_parameterized_hashes: items: type: string type: array title: Query Parameterized Hashes error_messages: items: type: string type: array title: Error Messages execution_statuses: items: type: string type: array title: Execution Statuses command_display: anyOf: - type: string - type: 'null' title: Command Display type: object required: - run_id - query_cost - bytes_scanned - execution_time - timestamp - start_time - success_count - total_count - warehouses - query_parameterized_hashes - error_messages - execution_statuses title: SnowflakeJobRunPageResponse Page_SnowflakeJobFetchAllPageResponse_: properties: items: items: $ref: '#/components/schemas/SnowflakeJobFetchAllPageResponse' type: array title: Items total: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Total page: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Page size: anyOf: - type: integer minimum: 1.0 - type: 'null' title: Size pages: anyOf: - type: integer minimum: 0.0 - type: 'null' title: Pages type: object required: - items - total - page - size title: Page[SnowflakeJobFetchAllPageResponse] RunEvents: properties: warehouse_change: anyOf: - type: string - type: 'null' title: Warehouse Change code_change: anyOf: - type: string - type: 'null' title: Code Change execution_status: anyOf: - type: string - type: 'null' title: Execution Status type: object title: RunEvents SnowflakeJobTaskAggregatePageResponse: properties: task_id: type: string title: Task Id task_name: anyOf: - type: string - type: 'null' title: Task Name task_type: anyOf: - type: string - type: 'null' title: Task Type integration_name: anyOf: - type: string - type: 'null' title: Integration Name integration_environment: anyOf: - type: string - type: 'null' title: Integration Environment integration_id: anyOf: - type: string - type: 'null' title: Integration Id dbt_model_present: type: boolean title: Dbt Model Present default: false query_cost: type: number title: Query Cost bytes_scanned: type: integer title: Bytes Scanned execution_time: type: number title: Execution Time timestamp: type: string format: date-time title: Timestamp start_time: type: string format: date-time title: Start Time success_count: type: integer title: Success Count total_count: type: integer title: Total Count warehouses: items: type: string type: array title: Warehouses annotation: anyOf: - $ref: '#/components/schemas/RunEvents' - type: 'null' query_parameterized_hashes: items: type: string type: array title: Query Parameterized Hashes error_messages: items: type: string type: array title: Error Messages execution_statuses: items: type: string type: array title: Execution Statuses insights: items: type: string type: array title: Insights commands: anyOf: - items: type: string type: array - type: 'null' title: Commands tags: anyOf: - items: type: string type: array - type: 'null' title: Tags type: object required: - task_id - query_cost - bytes_scanned - execution_time - timestamp - start_time - success_count - total_count - warehouses - query_parameterized_hashes - error_messages - execution_statuses title: SnowflakeJobTaskAggregatePageResponse securitySchemes: HTTPBearer: type: http scheme: bearer