openapi: 3.1.0 info: title: Fast ACCOUNT_COSTS QUERIES API version: 0.1.0 tags: - name: QUERIES paths: /query/: get: tags: - QUERIES summary: Get All Queries operationId: get_all_queries_query__get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - 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: 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: executionCostFilter in: query required: false schema: anyOf: - type: number - type: 'null' default: 0 title: Executioncostfilter - 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: 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_QueryFetchAllPageResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get All Queries Query Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get All Queries Query Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/last_fetched_time: get: tags: - QUERIES summary: Get Last Fetch Time operationId: get_last_fetch_time_query_last_fetched_time_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: type: object additionalProperties: true title: Response Get Last Fetch Time Query Last Fetched Time Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Last Fetch Time Query Last Fetched Time Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get Last Fetch Time Query Last Fetched Time Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/download: get: tags: - QUERIES summary: Download All Queries operationId: download_all_queries_query_download_get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - 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: 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: executionCostFilter in: query required: false schema: anyOf: - type: number - type: 'null' default: 0 title: Executioncostfilter - 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: x-tenant in: header required: true schema: type: string title: X-Tenant responses: '200': description: Successful Response '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Download All Queries Query Download Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Download All Queries Query Download Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/items/{query_id}: get: tags: - QUERIES summary: Get Query operationId: get_query_query_items__query_id__get 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: $ref: '#/components/schemas/QueryFetchResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get Query Query 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 Items Query Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/filters/: get: tags: - QUERIES summary: Get All Filters operationId: get_all_filters_query_filters__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: query_hash in: query required: false schema: anyOf: - type: string - type: 'null' title: Query Hash - name: filter_type in: query required: false schema: anyOf: - type: string - type: 'null' title: Filter Type - 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 Filters Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get All Filters Query Filters Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/custom/{query_id}: post: tags: - QUERIES summary: Upsert Custom Query Tag operationId: upsert_custom_query_tag_query_custom__query_id__post 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 requestBody: required: true content: application/json: schema: $ref: '#/components/schemas/QueryUpsertCustomTagRequest' responses: '200': description: Successful Response content: application/json: schema: $ref: '#/components/schemas/QueryUpsertCustomTagResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Upsert Custom Query Tag Query Custom Query Id Post '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Upsert Custom Query Tag Query Custom Query Id Post '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/groups: get: tags: - QUERIES summary: Get All Query Groups operationId: get_all_query_groups_query_groups_get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: sort_key in: query required: false schema: anyOf: - type: string - type: 'null' default: annualized_cost title: Sort Key - name: sort_order in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sort Order - name: tags in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Tags - name: users in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Users - name: warehouses in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Warehouses - name: query_hash in: query required: false schema: anyOf: - type: string - type: 'null' title: Query Hash - 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_QueryGroupPageItem_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get All Query Groups Query 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 Groups Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/groups/{query_hash}: get: tags: - QUERIES summary: Get Query Group Details operationId: get_query_group_details_query_groups__query_hash__get 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 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 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 Groups Query Hash Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' patch: tags: - QUERIES summary: Update Query Group Name operationId: update_query_group_name_query_groups__query_hash__patch 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/UpdateQueryGroupRequest' responses: '200': description: Successful Response content: application/json: schema: $ref: '#/components/schemas/StandardResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Update Query Group Name Query Groups Query Hash Patch '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Update Query Group Name Query Groups Query Hash Patch '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/groups/graph_data/{query_hash}: get: tags: - QUERIES summary: Graph Data Query Groups operationId: graph_data_query_groups_query_groups_graph_data__query_hash__get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: query_hash in: path required: true schema: type: string title: Query Hash - name: period in: query required: false schema: $ref: '#/components/schemas/Period' default: 30 - 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/QueryGraphDataResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Graph Data Query Groups Query Groups Graph Data Query Hash Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Graph Data Query Groups Query Groups Graph Data Query Hash Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/jobs/graph_data/{job_id}: get: tags: - QUERIES summary: Graph Data Query Jobs operationId: graph_data_query_jobs_query_jobs_graph_data__job_id__get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: job_id in: path required: true schema: type: string title: Job Id - name: period in: query required: false schema: $ref: '#/components/schemas/Period' default: 30 - 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/QueryGraphDataResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Graph Data Query Jobs Query Jobs Graph Data Job Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Graph Data Query Jobs Query Jobs Graph Data Job Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/download/groups: get: tags: - QUERIES summary: Download All Groups operationId: download_all_groups_query_download_groups_get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: sort_key in: query required: false schema: anyOf: - type: string - type: 'null' default: annualized_cost title: Sort Key - name: sort_order in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sort Order - name: tags in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Tags - name: users in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Users - name: warehouses in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Warehouses - name: query_hash in: query required: false schema: anyOf: - type: string - type: 'null' title: Query Hash - name: x-tenant in: header required: true schema: type: string title: X-Tenant responses: '200': description: Successful Response '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Download All Groups Query Download Groups Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Download All Groups Query Download Groups Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/jobs: get: tags: - QUERIES summary: Get All Jobs operationId: get_all_jobs_query_jobs_get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: limit in: query required: false schema: anyOf: - type: integer - type: 'null' title: Limit - name: sort_key in: query required: false schema: anyOf: - type: string - type: 'null' default: annualized_cost title: Sort Key - name: sort_order in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sort Order - name: annualized_cost in: query required: false schema: anyOf: - type: number - type: 'null' default: 0 title: Annualized Cost - name: warehouses in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Warehouses - name: job_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Job Id - name: auto_tune in: query required: false schema: anyOf: - type: boolean - type: 'null' default: false title: Auto Tune - name: environments in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Environments - 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_QueryJobProcessedResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get All Jobs Query Jobs Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get All Jobs Query Jobs Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/jobs/executions/{job_id}: get: tags: - QUERIES summary: Get All Job Executions operationId: get_all_job_executions_query_jobs_executions__job_id__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: job_id in: path required: true schema: type: string title: Job Id - name: limit in: query required: false schema: anyOf: - type: integer - type: 'null' title: Limit - name: sort_key in: query required: false schema: anyOf: - type: string - type: 'null' default: timestamp title: Sort Key - name: sort_order in: query required: false schema: anyOf: - type: string - type: 'null' default: desc title: Sort Order - 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: executionCostFilter in: query required: false schema: anyOf: - type: number - type: 'null' default: 0 title: Executioncostfilter - name: warehouse_sizes in: query required: false schema: anyOf: - type: array items: type: string - type: 'null' title: Warehouse Sizes - 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_QueryJobExecutionProcessedResponse_' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get All Job Executions Query Jobs Executions Job Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get All Job Executions Query Jobs Executions Job Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/jobs/definitions/{job_id}: get: tags: - QUERIES summary: Get All Job Definitions operationId: get_all_job_definitions_query_jobs_definitions__job_id__get deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: job_id in: path required: true schema: type: string title: Job 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: $ref: '#/components/schemas/QueryJobDefinitionProcessedResponse' title: Response Get All Job Definitions Query Jobs Definitions Job Id Get '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get All Job Definitions Query Jobs Definitions Job Id Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get All Job Definitions Query Jobs Definitions Job Id Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/job/edit_name/{job_id}: post: tags: - QUERIES summary: Update Job Name operationId: update_job_name_query_job_edit_name__job_id__post deprecated: true security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: job_id in: path required: true schema: type: string title: Job Id - name: x-tenant in: header required: true schema: type: string title: X-Tenant requestBody: required: true content: application/json: schema: $ref: '#/components/schemas/UpdateQueryJobNameRequest' responses: '200': description: Successful Response content: application/json: schema: $ref: '#/components/schemas/StandardResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Update Job Name Query Job Edit Name Job Id Post '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Update Job Name Query Job Edit Name Job Id Post '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/job/filters/: get: tags: - QUERIES summary: Get All Job Filters operationId: get_all_job_filters_query_job_filters__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: job_id in: query required: false schema: anyOf: - type: string - type: 'null' title: Job Id - name: filter_type in: query required: false schema: anyOf: - type: string - type: 'null' title: Filter Type - 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/QueryJobFiltersFetchAllResponse' '400': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 400 Get All Job Filters Query Job Filters Get '403': description: Not supported for public user content: application/json: schema: type: object additionalProperties: true title: Response 403 Get All Job Filters Query Job Filters Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/query_group/query_text/{query_hash}: get: tags: - QUERIES summary: Get Query Text operationId: get_query_text_query_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 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 Query Group Query Text Query Hash Get '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' /query/query_group/stats/{query_hash}: get: tags: - QUERIES summary: Get Hash Metrics operationId: get_hash_metrics_query_query_group_stats__query_hash__get security: - HTTPBearer: [] - HTTPBearer: [] parameters: - name: query_hash in: path required: true schema: type: string title: Query Hash - name: period in: query required: false schema: $ref: '#/components/schemas/Period' default: 30 - 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 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 Query Group Stats Query Hash 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 QueryJobFiltersFetchAllResponse: properties: 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 environments: anyOf: - items: anyOf: - type: string - type: 'null' type: array - type: 'null' title: Environments warehouse_sizes: anyOf: - items: anyOf: - type: string - type: 'null' type: array - type: 'null' title: Warehouse Sizes 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: QueryJobFiltersFetchAllResponse QueryJobProcessedResponse: properties: job_id: type: string title: Job Id job_name: anyOf: - type: string - type: 'null' title: Job Name number_of_runs: anyOf: - type: integer - type: 'null' title: Number Of Runs annualized_cost: anyOf: - type: string - type: 'null' title: Annualized Cost number_of_steps: anyOf: - type: integer - type: 'null' title: Number Of Steps warehouses: anyOf: - items: type: string type: array - type: 'null' title: Warehouses insights: anyOf: - items: type: string type: array - type: 'null' title: Insights avg_total_execution_time: anyOf: - type: string - type: 'null' title: Avg Total Execution Time median_total_execution_time: anyOf: - type: string - type: 'null' title: Median Total Execution Time max_total_execution_time: anyOf: - type: string - type: 'null' title: Max Total Execution Time p90_total_execution_time: anyOf: - type: string - type: 'null' title: P90 Total Execution Time job_frequency: anyOf: - type: string - type: 'null' title: Job Frequency environment: anyOf: - type: string - type: 'null' title: Environment avg_local_spill: anyOf: - type: string - type: 'null' title: Avg Local Spill avg_remote_spill: anyOf: - type: string - type: 'null' title: Avg Remote Spill type: object required: - job_id title: QueryJobProcessedResponse UpdateQueryGroupRequest: properties: group_name: type: string title: Group Name type: object required: - group_name title: UpdateQueryGroupRequest QueryHashTextResponse: properties: query_text: anyOf: - type: string - type: 'null' title: Query Text type: object title: QueryHashTextResponse 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 HTTPValidationError: properties: detail: items: $ref: '#/components/schemas/ValidationError' type: array title: Detail type: object title: HTTPValidationError QueryUpsertCustomTagRequest: properties: reason: type: string title: Reason type: object required: - reason title: QueryUpsertCustomTagRequest UpdateQueryJobNameRequest: properties: job_name: type: string title: Job Name type: object required: - job_name title: UpdateQueryJobNameRequest 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 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] QueryUpsertCustomTagResponse: properties: 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: QueryUpsertCustomTagResponse 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 Period: type: integer enum: - 365 - 29 - 30 - 7 - 1 - 28 title: Period QueryJobExecutionProcessedResponse: properties: job_id: type: string title: Job Id session_id: type: integer title: Session Id start_time: type: string format: date-time title: Start Time end_time: type: string format: date-time title: End Time insights: anyOf: - items: type: string type: array - type: 'null' title: Insights warehouse_name: type: string title: Warehouse Name warehouse_size: anyOf: - type: string - type: 'null' title: Warehouse Size user_name: type: string title: User Name job_execution_time: type: string title: Job Execution Time cost: type: string title: Cost total_data_scanned: type: string title: Total Data Scanned total_data_sent_over_network: type: string title: Total Data Sent Over Network total_local_spill: type: string title: Total Local Spill total_remote_spill: type: string title: Total Remote Spill type: object required: - job_id - session_id - start_time - end_time - warehouse_name - user_name - job_execution_time - cost - total_data_scanned - total_data_sent_over_network - total_local_spill - total_remote_spill title: QueryJobExecutionProcessedResponse 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] 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 QueryJobDefinitionProcessedResponse: properties: job_id: type: string title: Job Id step_id: type: string title: Step Id query_parameterized_hash: type: string title: Query Parameterized Hash query_text: type: string title: Query Text query_name: type: string title: Query Name query_trimmed: type: string title: Query Trimmed avg_cost: type: string title: Avg Cost avg_execution_time: type: string title: Avg Execution Time p90_execution_time: type: string title: P90 Execution Time avg_data_scanned: type: string title: Avg Data Scanned avg_data_sent_over_network: type: string title: Avg Data Sent Over Network avg_local_spill: type: string title: Avg Local Spill avg_remote_spill: type: string title: Avg Remote Spill type: object required: - job_id - step_id - query_parameterized_hash - query_text - query_name - query_trimmed - avg_cost - avg_execution_time - p90_execution_time - avg_data_scanned - avg_data_sent_over_network - avg_local_spill - avg_remote_spill title: QueryJobDefinitionProcessedResponse 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 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 Page_QueryJobExecutionProcessedResponse_: properties: items: items: $ref: '#/components/schemas/QueryJobExecutionProcessedResponse' 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[QueryJobExecutionProcessedResponse] StandardResponse: properties: ok: type: boolean title: Ok type: object required: - ok title: StandardResponse 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 QueryGraphDataResponse: properties: data: items: additionalProperties: true type: object type: array title: Data type: object required: - data title: QueryGraphDataResponse Page_QueryJobProcessedResponse_: properties: items: items: $ref: '#/components/schemas/QueryJobProcessedResponse' 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[QueryJobProcessedResponse] 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 securitySchemes: HTTPBearer: type: http scheme: bearer