Skip to main content
POST
Create Integration Source Column

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

source_id
string<uuid> | null
required
database_id
string<uuid>
required
schema_id
string<uuid>
required
table_id
string<uuid>
required

Query Parameters

organization_id
string<uuid> | null
resource_id
string<uuid> | null
integration_source_id
string<uuid> | null
data_source_id
string<uuid> | null
context_source_id
string<uuid> | null
job_id
string<uuid> | null

Body

application/json

Model for creating a new integration source column.

name
string
required

Column name

description
string | null

Optional description of the column

data_type
string | null

Data type (e.g., VARCHAR, INTEGER, TIMESTAMP)

is_primary_key
boolean
default:false

Whether this column is a primary key

is_nullable
boolean
default:true

Whether this column allows null values

ordinal_position
integer | null

Position of the column in the table (1-based)

semantic_type
string | null

Semantic type of the column (e.g., email, phone, date)

semantic_type_confidence
number | null

Confidence score for the detected semantic type

sample_values
any[] | null

Sample values from the column

enum_cardinality
integer | null

Number of distinct values (for enum-like columns)

null_pct
number | null

Percentage of null values in this column

distinct_pct
number | null

Percentage of distinct values in this column

last_analyzed
string<date-time> | null

When this column was last analyzed for metadata

approx_distinct_count
integer | null

Approximate number of distinct values (HyperLogLog)

minhash_signature
integer[] | null

MinHash signature used for estimating Jaccard similarity

format_signature
Format Signature · object | null

Distribution of detected value formats / regex patterns

length_stats
Length Stats · object | null

Value length statistics (min, mean, p95)

entropy
number | null

Shannon entropy approximation for value distribution

role
string | null

Inferred column role (e.g., PRIMARY_KEY_CANDIDATE)

role_confidence
number | null

Confidence score for the inferred column role

is_active
boolean
default:true

Whether this column is active for analysis

description_source
enum<string> | null

How description was created: 'ai_generated' | 'manual_edit' | 'imported' | 'information_schema'

Available options:
ai_generated,
manual_edit,
imported,
information_schema
description_generated_at
string<date-time> | null

When description was last modified

skip_embedding
boolean
default:false

Skip automatic embedding trigger for bulk operations

Response

Successful Response

Response model for integration source columns.

name
string
required

Column name

id
string<uuid>
required
table_id
string<uuid>
required
created_at
string<date-time>
required
updated_at
string<date-time>
required
description_version
integer
required
description
string | null

Optional description of the column

data_type
string | null

Data type (e.g., VARCHAR, INTEGER, TIMESTAMP)

is_primary_key
boolean
default:false

Whether this column is a primary key

is_nullable
boolean
default:true

Whether this column allows null values

ordinal_position
integer | null

Position of the column in the table (1-based)

semantic_type
string | null

Semantic type of the column (e.g., email, phone, date)

semantic_type_confidence
number | null

Confidence score for the detected semantic type

sample_values
any[] | null

Sample values from the column

enum_cardinality
integer | null

Number of distinct values (for enum-like columns)

null_pct
number | null

Percentage of null values in this column

distinct_pct
number | null

Percentage of distinct values in this column

last_analyzed
string<date-time> | null

When this column was last analyzed for metadata

approx_distinct_count
integer | null

Approximate number of distinct values (HyperLogLog)

minhash_signature
integer[] | null

MinHash signature used for estimating Jaccard similarity

format_signature
Format Signature · object | null

Distribution of detected value formats / regex patterns

length_stats
Length Stats · object | null

Value length statistics (min, mean, p95)

entropy
number | null

Shannon entropy approximation for value distribution

role
string | null

Inferred column role (e.g., PRIMARY_KEY_CANDIDATE)

role_confidence
number | null

Confidence score for the inferred column role

is_active
boolean
default:true

Whether this column is active for analysis

description_source
enum<string> | null

How description was created: 'ai_generated' | 'manual_edit' | 'imported' | 'information_schema'

Available options:
ai_generated,
manual_edit,
imported,
information_schema
description_generated_at
string<date-time> | null

When description was last modified