Skip to main content
PUT
/
api
/
integration-sources
/
{source_id}
/
databases
/
{database_id}
/
schemas
/
{schema_id}
/
tables
/
{table_id}
/
columns
/
{column_id}
Update Integration Source Column
curl --request PUT \
  --url https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}/columns/{column_id} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "description": "<string>",
  "data_type": "<string>",
  "is_primary_key": true,
  "is_nullable": true,
  "ordinal_position": 123,
  "skip_embedding": false,
  "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",
  "description_version": 123
}
'
{
  "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"
}

Documentation Index

Fetch the complete documentation index at: https://heyhumm.ai/docs/llms.txt

Use this file to discover all available pages before exploring further.

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
​
column_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 updating an integration source column.

​
description
string | null
​
data_type
string | null
​
is_primary_key
boolean | null
​
is_nullable
boolean | null
​
ordinal_position
integer | null
​
skip_embedding
boolean
default:false

Skip automatic embedding trigger for bulk operations

​
semantic_type
string | null
​
semantic_type_confidence
number | null
​
sample_values
any[] | null
​
enum_cardinality
integer | null
​
null_pct
number | null
​
distinct_pct
number | null
​
last_analyzed
string<date-time> | null
​
approx_distinct_count
integer | null
​
minhash_signature
integer[] | null
​
format_signature
Format Signature · object
​
length_stats
Length Stats · object
​
entropy
number | null
​
role
string | null
​
role_confidence
number | null
​
is_active
boolean | null
​
description_source
enum<string> | null
Available options:
ai_generated,
manual_edit,
imported,
information_schema
​
description_generated_at
string<date-time> | null
​
description_version
integer | null

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

Distribution of detected value formats / regex patterns

​
length_stats
Length Stats · object

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