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

# Read Materialized Query Status

> Returns refresh status and schedule information for a single materialized query.

<span style={{display: "flex", gap: "10px", flexDirection: "row", alignItems: "center"}}>
  <img src="https://cdn.peaka.com/badges/partner-api-key-badge.png" />

  <img src="https://cdn.peaka.com/badges/project-api-key-badge.png" />
</span>


## OpenAPI

````yaml get /data/projects/{projectId}/materialized-queries/{queryId}/status
openapi: 3.0.1
info:
  title: Peaka Gateway API
  description: Peaka Gateway API Documentation
  version: '1.0'
servers:
  - url: https://partner.peaka.studio/api/v1
    description: Default Server URL (US Zone)
  - url: https://partner.eu.peaka.studio/api/v1
    description: EU Zone
security:
  - bearerAuth: []
paths:
  /data/projects/{projectId}/materialized-queries/{queryId}/status:
    get:
      tags:
        - Data -- Materialized Queries
      summary: Read Materialized Query Status
      description: >-
        Returns refresh status and schedule information for a single
        materialized query.
      operationId: readMaterializedQueryStatus
      parameters:
        - name: projectId
          in: path
          description: ID of the Project
          required: true
          schema:
            type: string
          example: mtKDhe1U
        - name: queryId
          in: path
          description: ID of the Query
          required: true
          schema:
            type: string
          example: 709922802836177300
      responses:
        '200':
          description: Materialized query status
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MaterializedQueryStatusView'
              example:
                queryId: '709922802836177297'
                queryName: samplequery
                scheduleSettings:
                  cronExpression: null
                  repeatDuration: PT6H
                  timezone: null
                  type: interval
                nextExecutionStartTime: '2025-01-15T16:00:00Z'
                status: COMPLETED
                lastExecutionStartTime: '2025-01-15T10:00:00Z'
                lastUpdateTime: '2025-01-15T10:05:00Z'
components:
  schemas:
    MaterializedQueryStatusView:
      type: object
      properties:
        queryId:
          type: string
          description: ID of the query
          example: '709922802836177297'
        queryName:
          type: string
          description: Name of the query
          example: samplequery
        scheduleSettings:
          $ref: '#/components/schemas/MaterializedQuerySchedule'
        nextExecutionStartTime:
          type: string
          description: >-
            Next scheduled execution start time (ISO 8601). Null when the
            schedule type is 'none' or cannot be computed.
          nullable: true
          example: '2025-01-15T16:00:00Z'
        status:
          type: string
          description: Status of the most recent refresh
          example: COMPLETED
        lastExecutionStartTime:
          type: string
          description: Start time of the last refresh (ISO 8601)
          nullable: true
          example: '2025-01-15T10:00:00Z'
        lastUpdateTime:
          type: string
          description: Time the status was last updated (ISO 8601)
          nullable: true
          example: '2025-01-15T10:05:00Z'
      description: Status and schedule information for a materialized query
    MaterializedQuerySchedule:
      type: object
      properties:
        type:
          type: string
          description: Type of schedule.
          enum:
            - interval
            - cron
            - none
        cronExpression:
          type: string
          description: Cron expression. Set only when the schedule type is 'cron'.
          nullable: true
        repeatDuration:
          type: string
          description: ISO-8601 duration. Set only when the schedule type is 'interval'.
          nullable: true
        timezone:
          type: string
          description: >-
            IANA timezone used to evaluate the cron expression. Set only when
            the schedule type is 'cron'.
          nullable: true
      description: >-
        Schedule configuration of a materialized query. Provide EITHER an
        interval schedule (`type=interval` with `repeatDuration`) OR a cron
        schedule (`type=cron` with `cronExpression` and optional `timezone`).
        Use `type=none` for no schedule. The fields that do not apply to the
        chosen type are omitted.
      nullable: true
      example:
        type: cron
        cronExpression: 0 0 * * *
        timezone: UTC
  securitySchemes:
    bearerAuth:
      type: http
      description: >-
        Use the Authorization header with the value 'Bearer <apiKey>' to
        authenticate. Partner API Keys have full access; Project API Keys are
        limited to their project scope. Learn more:
        https://docs.peaka.com/api-reference/authentication
      scheme: bearer
      bearerFormat: Api Key

````