Update Integration Source Table

curl --request PUT \
  --url https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "description": "<string>",
  "is_active": true,
  "priority": 123,
  "type": "<string>",
  "row_count": 123,
  "skip_embedding": false,
  "null_pct_overall": 123,
  "column_null_pct": {},
  "column_distinct_pct": {},
  "earliest_timestamp": "2023-11-07T05:31:56Z",
  "latest_timestamp": "2023-11-07T05:31:56Z",
  "date_grain": "<string>",
  "last_load_timestamp": "2023-11-07T05:31:56Z",
  "load_frequency": "<string>",
  "data_latency_minutes": 123,
  "is_staging_table": true,
  "description_generated_at": "2023-11-07T05:31:56Z",
  "description_version": 123
}
'

import requests

url = "https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}"

payload = {
    "description": "<string>",
    "is_active": True,
    "priority": 123,
    "type": "<string>",
    "row_count": 123,
    "skip_embedding": False,
    "null_pct_overall": 123,
    "column_null_pct": {},
    "column_distinct_pct": {},
    "earliest_timestamp": "2023-11-07T05:31:56Z",
    "latest_timestamp": "2023-11-07T05:31:56Z",
    "date_grain": "<string>",
    "last_load_timestamp": "2023-11-07T05:31:56Z",
    "load_frequency": "<string>",
    "data_latency_minutes": 123,
    "is_staging_table": True,
    "description_generated_at": "2023-11-07T05:31:56Z",
    "description_version": 123
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.put(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'PUT',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    description: '<string>',
    is_active: true,
    priority: 123,
    type: '<string>',
    row_count: 123,
    skip_embedding: false,
    null_pct_overall: 123,
    column_null_pct: {},
    column_distinct_pct: {},
    earliest_timestamp: '2023-11-07T05:31:56Z',
    latest_timestamp: '2023-11-07T05:31:56Z',
    date_grain: '<string>',
    last_load_timestamp: '2023-11-07T05:31:56Z',
    load_frequency: '<string>',
    data_latency_minutes: 123,
    is_staging_table: true,
    description_generated_at: '2023-11-07T05:31:56Z',
    description_version: 123
  })
};

fetch('https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PUT",
  CURLOPT_POSTFIELDS => json_encode([
    'description' => '<string>',
    'is_active' => true,
    'priority' => 123,
    'type' => '<string>',
    'row_count' => 123,
    'skip_embedding' => false,
    'null_pct_overall' => 123,
    'column_null_pct' => [
        
    ],
    'column_distinct_pct' => [
        
    ],
    'earliest_timestamp' => '2023-11-07T05:31:56Z',
    'latest_timestamp' => '2023-11-07T05:31:56Z',
    'date_grain' => '<string>',
    'last_load_timestamp' => '2023-11-07T05:31:56Z',
    'load_frequency' => '<string>',
    'data_latency_minutes' => 123,
    'is_staging_table' => true,
    'description_generated_at' => '2023-11-07T05:31:56Z',
    'description_version' => 123
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}"

	payload := strings.NewReader("{\n  \"description\": \"<string>\",\n  \"is_active\": true,\n  \"priority\": 123,\n  \"type\": \"<string>\",\n  \"row_count\": 123,\n  \"skip_embedding\": false,\n  \"null_pct_overall\": 123,\n  \"column_null_pct\": {},\n  \"column_distinct_pct\": {},\n  \"earliest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"latest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"date_grain\": \"<string>\",\n  \"last_load_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"load_frequency\": \"<string>\",\n  \"data_latency_minutes\": 123,\n  \"is_staging_table\": true,\n  \"description_generated_at\": \"2023-11-07T05:31:56Z\",\n  \"description_version\": 123\n}")

	req, _ := http.NewRequest("PUT", url, payload)

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.put("https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"description\": \"<string>\",\n  \"is_active\": true,\n  \"priority\": 123,\n  \"type\": \"<string>\",\n  \"row_count\": 123,\n  \"skip_embedding\": false,\n  \"null_pct_overall\": 123,\n  \"column_null_pct\": {},\n  \"column_distinct_pct\": {},\n  \"earliest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"latest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"date_grain\": \"<string>\",\n  \"last_load_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"load_frequency\": \"<string>\",\n  \"data_latency_minutes\": 123,\n  \"is_staging_table\": true,\n  \"description_generated_at\": \"2023-11-07T05:31:56Z\",\n  \"description_version\": 123\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Put.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"description\": \"<string>\",\n  \"is_active\": true,\n  \"priority\": 123,\n  \"type\": \"<string>\",\n  \"row_count\": 123,\n  \"skip_embedding\": false,\n  \"null_pct_overall\": 123,\n  \"column_null_pct\": {},\n  \"column_distinct_pct\": {},\n  \"earliest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"latest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"date_grain\": \"<string>\",\n  \"last_load_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"load_frequency\": \"<string>\",\n  \"data_latency_minutes\": 123,\n  \"is_staging_table\": true,\n  \"description_generated_at\": \"2023-11-07T05:31:56Z\",\n  \"description_version\": 123\n}"

response = http.request(request)
puts response.read_body

{
  "name": "<string>",
  "integration_source_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "schema_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>",
  "is_active": true,
  "priority": 99,
  "type": "<string>",
  "row_count": 123,
  "null_pct_overall": 123,
  "column_null_pct": {},
  "column_distinct_pct": {},
  "earliest_timestamp": "2023-11-07T05:31:56Z",
  "latest_timestamp": "2023-11-07T05:31:56Z",
  "date_grain": "<string>",
  "last_load_timestamp": "2023-11-07T05:31:56Z",
  "load_frequency": "<string>",
  "data_latency_minutes": 123,
  "is_staging_table": true,
  "description_generated_at": "2023-11-07T05:31:56Z",
  "column_count": 123
}

{
  "detail": [
    {
      "loc": [
        "<string>"
      ],
      "msg": "<string>",
      "type": "<string>"
    }
  ]
}

PUT

api

integration-sources

{source_id}

databases

{database_id}

schemas

{schema_id}

tables

{table_id}

Update Integration Source Table

curl --request PUT \
  --url https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "description": "<string>",
  "is_active": true,
  "priority": 123,
  "type": "<string>",
  "row_count": 123,
  "skip_embedding": false,
  "null_pct_overall": 123,
  "column_null_pct": {},
  "column_distinct_pct": {},
  "earliest_timestamp": "2023-11-07T05:31:56Z",
  "latest_timestamp": "2023-11-07T05:31:56Z",
  "date_grain": "<string>",
  "last_load_timestamp": "2023-11-07T05:31:56Z",
  "load_frequency": "<string>",
  "data_latency_minutes": 123,
  "is_staging_table": true,
  "description_generated_at": "2023-11-07T05:31:56Z",
  "description_version": 123
}
'

import requests

url = "https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}"

payload = {
    "description": "<string>",
    "is_active": True,
    "priority": 123,
    "type": "<string>",
    "row_count": 123,
    "skip_embedding": False,
    "null_pct_overall": 123,
    "column_null_pct": {},
    "column_distinct_pct": {},
    "earliest_timestamp": "2023-11-07T05:31:56Z",
    "latest_timestamp": "2023-11-07T05:31:56Z",
    "date_grain": "<string>",
    "last_load_timestamp": "2023-11-07T05:31:56Z",
    "load_frequency": "<string>",
    "data_latency_minutes": 123,
    "is_staging_table": True,
    "description_generated_at": "2023-11-07T05:31:56Z",
    "description_version": 123
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.put(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'PUT',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    description: '<string>',
    is_active: true,
    priority: 123,
    type: '<string>',
    row_count: 123,
    skip_embedding: false,
    null_pct_overall: 123,
    column_null_pct: {},
    column_distinct_pct: {},
    earliest_timestamp: '2023-11-07T05:31:56Z',
    latest_timestamp: '2023-11-07T05:31:56Z',
    date_grain: '<string>',
    last_load_timestamp: '2023-11-07T05:31:56Z',
    load_frequency: '<string>',
    data_latency_minutes: 123,
    is_staging_table: true,
    description_generated_at: '2023-11-07T05:31:56Z',
    description_version: 123
  })
};

fetch('https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PUT",
  CURLOPT_POSTFIELDS => json_encode([
    'description' => '<string>',
    'is_active' => true,
    'priority' => 123,
    'type' => '<string>',
    'row_count' => 123,
    'skip_embedding' => false,
    'null_pct_overall' => 123,
    'column_null_pct' => [
        
    ],
    'column_distinct_pct' => [
        
    ],
    'earliest_timestamp' => '2023-11-07T05:31:56Z',
    'latest_timestamp' => '2023-11-07T05:31:56Z',
    'date_grain' => '<string>',
    'last_load_timestamp' => '2023-11-07T05:31:56Z',
    'load_frequency' => '<string>',
    'data_latency_minutes' => 123,
    'is_staging_table' => true,
    'description_generated_at' => '2023-11-07T05:31:56Z',
    'description_version' => 123
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}"

	payload := strings.NewReader("{\n  \"description\": \"<string>\",\n  \"is_active\": true,\n  \"priority\": 123,\n  \"type\": \"<string>\",\n  \"row_count\": 123,\n  \"skip_embedding\": false,\n  \"null_pct_overall\": 123,\n  \"column_null_pct\": {},\n  \"column_distinct_pct\": {},\n  \"earliest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"latest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"date_grain\": \"<string>\",\n  \"last_load_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"load_frequency\": \"<string>\",\n  \"data_latency_minutes\": 123,\n  \"is_staging_table\": true,\n  \"description_generated_at\": \"2023-11-07T05:31:56Z\",\n  \"description_version\": 123\n}")

	req, _ := http.NewRequest("PUT", url, payload)

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.put("https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"description\": \"<string>\",\n  \"is_active\": true,\n  \"priority\": 123,\n  \"type\": \"<string>\",\n  \"row_count\": 123,\n  \"skip_embedding\": false,\n  \"null_pct_overall\": 123,\n  \"column_null_pct\": {},\n  \"column_distinct_pct\": {},\n  \"earliest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"latest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"date_grain\": \"<string>\",\n  \"last_load_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"load_frequency\": \"<string>\",\n  \"data_latency_minutes\": 123,\n  \"is_staging_table\": true,\n  \"description_generated_at\": \"2023-11-07T05:31:56Z\",\n  \"description_version\": 123\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://config.heyhumm.ai/api/integration-sources/{source_id}/databases/{database_id}/schemas/{schema_id}/tables/{table_id}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Put.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"description\": \"<string>\",\n  \"is_active\": true,\n  \"priority\": 123,\n  \"type\": \"<string>\",\n  \"row_count\": 123,\n  \"skip_embedding\": false,\n  \"null_pct_overall\": 123,\n  \"column_null_pct\": {},\n  \"column_distinct_pct\": {},\n  \"earliest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"latest_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"date_grain\": \"<string>\",\n  \"last_load_timestamp\": \"2023-11-07T05:31:56Z\",\n  \"load_frequency\": \"<string>\",\n  \"data_latency_minutes\": 123,\n  \"is_staging_table\": true,\n  \"description_generated_at\": \"2023-11-07T05:31:56Z\",\n  \"description_version\": 123\n}"

response = http.request(request)
puts response.read_body

{
  "name": "<string>",
  "integration_source_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "schema_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>",
  "is_active": true,
  "priority": 99,
  "type": "<string>",
  "row_count": 123,
  "null_pct_overall": 123,
  "column_null_pct": {},
  "column_distinct_pct": {},
  "earliest_timestamp": "2023-11-07T05:31:56Z",
  "latest_timestamp": "2023-11-07T05:31:56Z",
  "date_grain": "<string>",
  "last_load_timestamp": "2023-11-07T05:31:56Z",
  "load_frequency": "<string>",
  "data_latency_minutes": 123,
  "is_staging_table": true,
  "description_generated_at": "2023-11-07T05:31:56Z",
  "column_count": 123
}

{
  "detail": [
    {
      "loc": [
        "<string>"
      ],
      "msg": "<string>",
      "type": "<string>"
    }
  ]
}

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 updating an integration source table.

description

string | null

is_active

boolean | null

priority

integer | null

type

string | null

row_count

integer | null

skip_embedding

boolean

default:false

Skip automatic embedding trigger for bulk operations

null_pct_overall

number | null

column_null_pct

Column Null Pct · object | null

Show child attributes

column_distinct_pct

Column Distinct Pct · object | null

Show child attributes

earliest_timestamp

string<date-time> | null

latest_timestamp

string<date-time> | null

date_grain

string | null

last_load_timestamp

string<date-time> | null

load_frequency

string | null

data_latency_minutes

integer | null

is_staging_table

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 tables.

name

string

required

Table name

integration_source_id

string<uuid>

required

string<uuid>

required

schema_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 table

is_active

boolean

default:true

Whether this table is active for analysis

priority

integer

default:99

Priority for processing (lower numbers processed first)

type

string | null

Table type (e.g., TABLE, VIEW, MATERIALIZED_VIEW)

row_count

integer | null

Number of rows in the table

null_pct_overall

number | null

Overall percentage of null values across all columns

column_null_pct

Column Null Pct · object | null

Null percentage per column

Show child attributes

column_distinct_pct

Column Distinct Pct · object | null

Distinct value percentage per column

Show child attributes

earliest_timestamp

string<date-time> | null

Earliest timestamp found in the table

latest_timestamp

string<date-time> | null

Latest timestamp found in the table

date_grain

string | null

Granularity of date data (daily, hourly, etc.)

last_load_timestamp

string<date-time> | null

When the table was last loaded/updated

load_frequency

string | null

How frequently the table is updated

data_latency_minutes

integer | null

Data latency in minutes

is_staging_table

boolean | null

Whether this is a staging/temporary table

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

column_count

integer | null

Number of columns in the table

Organizations

Members & Roles

User Identification

Integration Sources

Databases & Catalog

SaaS Catalog

Relationships & Context

Update Integration Source Table

Authorizations

Path Parameters

Query Parameters

Body

Response