tables

Profile a table

Return per-column distributions, null rates, cardinality, basic numeric / date stats, and PII classification for one table. Requires the Build plan or higher. Quota: 1 capability unit.

get/v1/tables/{t}/profile

Request

  • Base URL: https://data.thinair.co
  • URL: https://data.thinair.co/v1/tables/{t}/profile
  • Auth: API key in header x-api-key

Path parameters

tstring required

Table name. Accepts table, schema.table, or database.schema.table forms — same wire shape the MCP data_profile tool accepts. Use ?connection= to override the tenant's default connection rather than prefixing the path.

Example:public.vehicles

Query parameters

connectionstring

Connection name (display) or id (uuid). Resolved via name match first, then id match. Call /v1/connections to list available names.

Example:fleet
sample_rowsinteger

Advisory upper bound on rows to scan. Today the underlying profiler decides sampling internally based on table size; the value is reserved for the post-migration profile micro-spec.

Example:50000
columnsstring

Comma-separated column allowlist. Today the profiler covers the first 50 columns; the value is reserved for the post-migration profile micro-spec.

Example:make,model,year

Response

Profile result.

summarystring

Changes

No recorded changes to this operation across all 1 revision of this API.