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

# List Integration Source Columns

> List all columns for an integration source table.



## OpenAPI

````yaml https://config.heyhumm.ai/api/openapi.json get /api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}/columns
openapi: 3.1.0
info:
  title: Configuration API
  description: >-
    API for managing configuration and queues for various services. This service
    consolidates the API functionality previously provided by dd_rag_api and
    code_rag_api.
  version: 1.0.0
servers:
  - url: https://config.heyhumm.ai
security: []
paths:
  /api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}/columns:
    get:
      tags:
        - Integration Sources
      summary: List Integration Source Columns
      description: List all columns for an integration source table.
      operationId: >-
        list_integration_source_columns_api_integration_sources__source_id__databases__database_id__schemas__schema_id__tables__table_id__columns_get
      parameters:
        - name: source_id
          in: path
          required: true
          schema:
            anyOf:
              - type: string
                format: uuid
              - type: 'null'
            title: Source Id
        - name: database_id
          in: path
          required: true
          schema:
            type: string
            format: uuid
            title: Database Id
        - name: schema_id
          in: path
          required: true
          schema:
            type: string
            format: uuid
            title: Schema Id
        - name: table_id
          in: path
          required: true
          schema:
            type: string
            format: uuid
            title: Table Id
        - name: organization_id
          in: query
          required: false
          schema:
            anyOf:
              - type: string
                format: uuid
              - type: 'null'
            title: Organization Id
        - name: resource_id
          in: query
          required: false
          schema:
            anyOf:
              - type: string
                format: uuid
              - type: 'null'
            title: Resource Id
        - name: integration_source_id
          in: query
          required: false
          schema:
            anyOf:
              - type: string
                format: uuid
              - type: 'null'
            title: Integration Source Id
        - name: data_source_id
          in: query
          required: false
          schema:
            anyOf:
              - type: string
                format: uuid
              - type: 'null'
            title: Data Source Id
        - name: context_source_id
          in: query
          required: false
          schema:
            anyOf:
              - type: string
                format: uuid
              - type: 'null'
            title: Context Source Id
        - name: job_id
          in: query
          required: false
          schema:
            anyOf:
              - type: string
                format: uuid
              - type: 'null'
            title: Job Id
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/IntegrationSourceColumnResponse'
                title: >-
                  Response List Integration Source Columns Api Integration
                  Sources  Source Id  Databases  Database Id  Schemas  Schema
                  Id  Tables  Table Id  Columns Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
      security:
        - HTTPBearer: []
components:
  schemas:
    IntegrationSourceColumnResponse:
      properties:
        name:
          type: string
          title: Name
          description: Column name
        description:
          anyOf:
            - type: string
            - type: 'null'
          title: Description
          description: Optional description of the column
        data_type:
          anyOf:
            - type: string
            - type: 'null'
          title: Data Type
          description: Data type (e.g., VARCHAR, INTEGER, TIMESTAMP)
        is_primary_key:
          type: boolean
          title: Is Primary Key
          description: Whether this column is a primary key
          default: false
        is_nullable:
          type: boolean
          title: Is Nullable
          description: Whether this column allows null values
          default: true
        ordinal_position:
          anyOf:
            - type: integer
            - type: 'null'
          title: Ordinal Position
          description: Position of the column in the table (1-based)
        semantic_type:
          anyOf:
            - type: string
            - type: 'null'
          title: Semantic Type
          description: Semantic type of the column (e.g., email, phone, date)
        semantic_type_confidence:
          anyOf:
            - type: number
            - type: 'null'
          title: Semantic Type Confidence
          description: Confidence score for the detected semantic type
        sample_values:
          anyOf:
            - items: {}
              type: array
            - type: 'null'
          title: Sample Values
          description: Sample values from the column
        enum_cardinality:
          anyOf:
            - type: integer
            - type: 'null'
          title: Enum Cardinality
          description: Number of distinct values (for enum-like columns)
        null_pct:
          anyOf:
            - type: number
            - type: 'null'
          title: Null Pct
          description: Percentage of null values in this column
        distinct_pct:
          anyOf:
            - type: number
            - type: 'null'
          title: Distinct Pct
          description: Percentage of distinct values in this column
        last_analyzed:
          anyOf:
            - type: string
              format: date-time
            - type: 'null'
          title: Last Analyzed
          description: When this column was last analyzed for metadata
        approx_distinct_count:
          anyOf:
            - type: integer
            - type: 'null'
          title: Approx Distinct Count
          description: Approximate number of distinct values (HyperLogLog)
        minhash_signature:
          anyOf:
            - items:
                type: integer
              type: array
            - type: 'null'
          title: Minhash Signature
          description: MinHash signature used for estimating Jaccard similarity
        format_signature:
          anyOf:
            - additionalProperties:
                type: number
              type: object
            - type: 'null'
          title: Format Signature
          description: Distribution of detected value formats / regex patterns
        length_stats:
          anyOf:
            - additionalProperties:
                type: number
              type: object
            - type: 'null'
          title: Length Stats
          description: Value length statistics (min, mean, p95)
        entropy:
          anyOf:
            - type: number
            - type: 'null'
          title: Entropy
          description: Shannon entropy approximation for value distribution
        role:
          anyOf:
            - type: string
            - type: 'null'
          title: Role
          description: Inferred column role (e.g., PRIMARY_KEY_CANDIDATE)
        role_confidence:
          anyOf:
            - type: number
            - type: 'null'
          title: Role Confidence
          description: Confidence score for the inferred column role
        is_active:
          type: boolean
          title: Is Active
          description: Whether this column is active for analysis
          default: true
        description_source:
          anyOf:
            - type: string
              enum:
                - ai_generated
                - manual_edit
                - imported
                - information_schema
            - type: 'null'
          title: Description Source
          description: >-
            How description was created: 'ai_generated' | 'manual_edit' |
            'imported' | 'information_schema'
        description_generated_at:
          anyOf:
            - type: string
              format: date-time
            - type: 'null'
          title: Description Generated At
          description: When description was last modified
        id:
          type: string
          format: uuid
          title: Id
        table_id:
          type: string
          format: uuid
          title: Table Id
        created_at:
          type: string
          format: date-time
          title: Created At
        updated_at:
          type: string
          format: date-time
          title: Updated At
        description_version:
          type: integer
          title: Description Version
      type: object
      required:
        - name
        - id
        - table_id
        - created_at
        - updated_at
        - description_version
      title: IntegrationSourceColumnResponse
      description: Response model for integration source columns.
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: '#/components/schemas/ValidationError'
          type: array
          title: Detail
      type: object
      title: HTTPValidationError
    ValidationError:
      properties:
        loc:
          items:
            anyOf:
              - type: string
              - type: integer
          type: array
          title: Location
        msg:
          type: string
          title: Message
        type:
          type: string
          title: Error Type
      type: object
      required:
        - loc
        - msg
        - type
      title: ValidationError
  securitySchemes:
    HTTPBearer:
      type: http
      scheme: bearer

````