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

# Create BI Table

> Creates a new [Peaka BI Table](https://docs.peaka.com/connecting-your-data/peaka-bi-table) with the given name in the specified project. Peaka BI Table uses a column-oriented storage approach optimized for large datasets of over one million records, offering fast filtering and grouping performance without additional indexing. It is particularly well-suited for event data and bulk insertions. Note that JSON data type is not supported. 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 post /data/projects/{projectId}/bitable/{tableName}
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/{tableName}:
    post:
      tags:
        - Data -- Internal Tables
      summary: Create BI Table
      description: >-
        Creates a new [Peaka BI
        Table](https://docs.peaka.com/connecting-your-data/peaka-bi-table) with
        the given name in the specified project. Peaka BI Table uses a
        column-oriented storage approach optimized for large datasets of over
        one million records, offering fast filtering and grouping performance
        without additional indexing. It is particularly well-suited for event
        data and bulk insertions. Note that JSON data type is not supported. 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: createInternalBiTable
      parameters:
        - name: projectId
          in: path
          description: ID of the Project
          required: true
          schema:
            type: string
          example: mtKDhe1U
        - name: tableName
          in: path
          description: Name of the BI table to create
          required: true
          schema:
            type: string
          example: events
      responses:
        '200':
          description: Table created successfully
          content:
            '*/*':
              schema:
                $ref: '#/components/schemas/Table'
              example:
                catalogId: '1'
                catalogName: peaka
                schemaName: bitable
                tableName: testtable
                isCacheable: false
                isDynamicTable: false
                isCached: false
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

````