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

# List BI Tables

> Lists all [Peaka BI Tables](https://docs.peaka.com/connecting-your-data/peaka-bi-table) in the project. Peaka BI Table is a robust data management solution optimized for handling large datasets of over one million records. It uses a column-oriented data storage approach, resulting in exceptionally fast filtering and grouping performance without requiring additional indexing. It is particularly well-suited for event data and bulk insertions, though it does not support JSON data types. See also: [Differences of Peaka Table and Peaka BI Table](https://docs.peaka.com/connecting-your-data/differences-of-peaka-table-and-peaka-bi-table)

<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}/bitable
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}/bitable:
    get:
      tags:
        - Data -- Internal Tables
      summary: List BI Tables
      description: >-
        Lists all [Peaka BI
        Tables](https://docs.peaka.com/connecting-your-data/peaka-bi-table) in
        the project. Peaka BI Table is a robust data management solution
        optimized for handling large datasets of over one million records. It
        uses a column-oriented data storage approach, resulting in exceptionally
        fast filtering and grouping performance without requiring additional
        indexing. It is particularly well-suited for event data and bulk
        insertions, though it does not support JSON data types. See also:
        [Differences of Peaka Table and Peaka BI
        Table](https://docs.peaka.com/connecting-your-data/differences-of-peaka-table-and-peaka-bi-table)
      operationId: listBiTables
      parameters:
        - name: projectId
          in: path
          description: ID of the Project
          required: true
          schema:
            type: string
          example: mtKDhe1U
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/Table'
components:
  schemas:
    Table:
      type: object
      properties:
        catalogId:
          type: string
          description: The ID of the catalog that the table belongs to.
        catalogName:
          type: string
          description: The name of the catalog that the table belongs to.
        schemaName:
          type: string
          description: The name of the schema that the table belongs to.
        tableName:
          type: string
          description: The name of the table.
        isCacheable:
          type: boolean
          description: Indicates whether the table is cacheable or not.
        isDynamicTable:
          type: boolean
          description: >-
            Indicates whether the table has required query parameter columns or
            not.
             A query parameter column is prefixed with "_q_" e.g. "_q_date".
             These columns are used to filter the data in the table.
        isCached:
          type: boolean
          description: |-
            Indicates whether the table is cached or not.
             It is not the status of caching.
             <br>
             e.g. when a table is cached, you are no longer accessing the original data source.
             But the data may not be complete since an ongoing cache refresh is in progress.
      description: Represents a table in a schema.
  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

````