Create Integration Source Column

curl --request POST \ --url https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}/columns \ --header 'Authorization: Bearer <token>' \ --header 'Content-Type: application/json' \ --data ' { "name": "<string>", "description": "<string>", "data_type": "<string>", "is_primary_key": false, "is_nullable": true, "ordinal_position": 123, "semantic_type": "<string>", "semantic_type_confidence": 123, "sample_values": [ "<unknown>" ], "enum_cardinality": 123, "null_pct": 123, "distinct_pct": 123, "last_analyzed": "2023-11-07T05:31:56Z", "approx_distinct_count": 123, "minhash_signature": [ 123 ], "format_signature": {}, "length_stats": {}, "entropy": 123, "role": "<string>", "role_confidence": 123, "is_active": true, "description_source": "ai_generated", "description_generated_at": "2023-11-07T05:31:56Z", "skip_embedding": false } '

{ "name": "<string>", "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a", "table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a", "created_at": "2023-11-07T05:31:56Z", "updated_at": "2023-11-07T05:31:56Z", "description_version": 123, "description": "<string>", "data_type": "<string>", "is_primary_key": false, "is_nullable": true, "ordinal_position": 123, "semantic_type": "<string>", "semantic_type_confidence": 123, "sample_values": [ "<unknown>" ], "enum_cardinality": 123, "null_pct": 123, "distinct_pct": 123, "last_analyzed": "2023-11-07T05:31:56Z", "approx_distinct_count": 123, "minhash_signature": [ 123 ], "format_signature": {}, "length_stats": {}, "entropy": 123, "role": "<string>", "role_confidence": 123, "is_active": true, "description_source": "ai_generated", "description_generated_at": "2023-11-07T05:31:56Z" }

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

Distribution of detected value formats / regex patterns

Show child attributes

length_stats

Length Stats · object

Value length statistics (min, mean, p95)

Show child attributes

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

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

Distribution of detected value formats / regex patterns

Show child attributes

length_stats

Length Stats · object

Value length statistics (min, mean, p95)

Show child attributes

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

Organizations

Members & Roles

User Identification

Integration Sources

Databases & Catalog

SaaS Catalog

Relationships & Context

Create Integration Source Column

Authorizations

Path Parameters

Query Parameters

Body

Response

Organizations

Members & Roles

User Identification

Integration Sources

Databases & Catalog

SaaS Catalog

Relationships & Context

Documentation Index

Authorizations

Path Parameters

Query Parameters

Body

Response