> ## 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.

# Get All Cache Statuses of a Schema

> Returns the status of all caches within a specific schema of a catalog. This is a narrower filter than the catalog-level status endpoint, useful when a single catalog contains many schemas and only a subset is of interest.

Each entry in the response array contains the same status information as the single cache status endpoint.

<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}/catalog/{catalogId}/schema/{schemaName}/cache/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}/catalog/{catalogId}/schema/{schemaName}/cache/status:
    get:
      tags:
        - Data -- Cache
      summary: Get All Cache Statuses of a Schema
      description: >-
        Returns the status of all caches within a specific schema of a catalog.
        This is a narrower filter than the catalog-level status endpoint, useful
        when a single catalog contains many schemas and only a subset is of
        interest.


        Each entry in the response array contains the same status information as
        the single cache status endpoint.
      operationId: getCacheStatusBySchema
      parameters:
        - name: projectId
          in: path
          description: The unique identifier of the project that owns the catalog
          required: true
          schema:
            type: string
          example: mtKDhe1U
        - name: catalogId
          in: path
          description: >-
            The unique identifier of the catalog (data source connection) that
            owns the schema
          required: true
          schema:
            type: string
          example: 627249916703408600
        - name: schemaName
          in: path
          description: The name of the schema to filter caches by
          required: true
          schema:
            type: string
          example: payment
      responses:
        '200':
          description: >-
            List of cache statuses for all caches in the schema. Returns an
            empty array if no caches exist for this schema.
          content:
            '*/*':
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/CacheStatus'
components:
  schemas:
    CacheStatus:
      type: object
      properties:
        id:
          type: string
          description: The ID of the cache.
        status:
          type: string
          description: |-
            The status of the cache.
             RUNNING, CANCELLED, FAILED, COMPLETED, DELETED, NOT_INITIALIZED
          enum:
            - RUNNING
            - CANCELLED
            - FAILED
            - COMPLETED
            - DELETED
            - NOT_INITIALIZED
        catalogId:
          type: string
          description: The ID of the catalog that the cache belongs to.
        schemaName:
          type: string
          description: The name of the schema that the cache belongs to.
        tableName:
          type: string
          description: The name of the table that the cache belongs to.
        lastIncrementalCacheExecution:
          $ref: '#/components/schemas/CacheExecutionInfo'
        lastFullRefreshCacheExecution:
          $ref: '#/components/schemas/CacheExecutionInfo'
        cacheActionLogs:
          type: array
          description: The list of cache action logs
          items:
            $ref: '#/components/schemas/CacheActionRecord'
        appId:
          type: string
          writeOnly: true
        projectId:
          type: string
          description: The ID of the project that the cache belongs to.
    CacheExecutionInfo:
      type: object
      properties:
        id:
          type: string
        executionMode:
          type: string
        status:
          type: string
        error:
          type: object
        progress:
          $ref: '#/components/schemas/CacheExecutionProgress'
        createdAt:
          type: string
          format: date-time
        updatedAt:
          type: string
          format: date-time
        finishedAt:
          type: string
          format: date-time
    CacheActionRecord:
      type: object
      properties:
        timestamp:
          type: string
          format: date-time
        action:
          type: string
        message:
          type: string
        cacheType:
          type: string
        isScheduled:
          type: boolean
    CacheExecutionProgress:
      type: object
      properties:
        numberOfCachedRecords:
          type: integer
          format: int32
        numberOfInsertedRecords:
          type: integer
          format: int32
        numberOfUpdatedRecords:
          type: integer
          format: int32
        numberOfDeletedRecords:
          type: integer
          format: int32
        lastOffset:
          type: string
        lastCacheTxId:
          type: string
  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

````