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

# List a table's columns

> One table's columns with their types (a table outside the table allowlist is a 404).



## OpenAPI

````yaml /api/statisfy-api.openapi.json get /v1/integrations/{key}/discover/schemas/{schema_name}/tables/{table_name}/columns
openapi: 3.1.0
info:
  description: >-
    The agent-first Statisfy API. Authenticate with an API key (`Authorization:
    Bearer stfy_live_…`), then call `GET /v1/meta/capabilities` to discover
    every operation and its schemas.
  title: Statisfy API
  version: 1.0.0
servers:
  - url: https://api.statisfy.com
    description: Production
security: []
paths:
  /v1/integrations/{key}/discover/schemas/{schema_name}/tables/{table_name}/columns:
    get:
      tags:
        - integrations
      summary: List a table's columns
      description: >-
        One table's columns with their types (a table outside the table
        allowlist is a 404).
      operationId: integrations_discover_columns
      parameters:
        - description: The integration key, such as snowflake or salesforce
          in: path
          name: key
          required: true
          schema:
            type: string
        - in: path
          name: schema_name
          required: true
          schema:
            maxLength: 255
            minLength: 1
            type: string
        - in: path
          name: table_name
          required: true
          schema:
            maxLength: 255
            minLength: 1
            type: string
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ColumnsResponse'
          description: Successful Response
      security:
        - HTTPBearer: []
components:
  schemas:
    ColumnsResponse:
      properties:
        data:
          items:
            $ref: '#/components/schemas/ColumnInfo'
          title: Data
          type: array
      required:
        - data
      title: ColumnsResponse
      type: object
    ColumnInfo:
      description: 'Schema browser: column metadata.'
      properties:
        data_type:
          title: Data Type
          type: string
        is_nullable:
          default: true
          title: Is Nullable
          type: boolean
        is_primary_key:
          default: false
          title: Is Primary Key
          type: boolean
        name:
          title: Name
          type: string
      required:
        - name
        - data_type
      title: ColumnInfo
      type: object
  securitySchemes:
    HTTPBearer:
      scheme: bearer
      type: http
      description: >-
        An API key, sent as `Authorization: Bearer stfy_live_…`. See
        [Authentication](/rest-api/authentication) for how to get one and which
        scopes it needs.

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.