Skip to main content
GET
/
api
/
data-readiness
/
data-assets
/
profiles
/
columns
/
by-fqn
Get latest column profile by FQN
curl --request GET \
  --url https://api.example.com/api/data-readiness/data-assets/profiles/columns/by-fqn \
  --header 'Authorization: Bearer <token>'
{
  "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "asset_fqn": "<string>",
  "service": "<string>",
  "asset_version": "<string>",
  "created_at": "<string>",
  "workflow_run_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "database_name": "<string>",
  "schema_name": "<string>",
  "table_name": "<string>",
  "column_name": "<string>",
  "values_count": 123,
  "non_null_count": 123,
  "duplicate_count": 123,
  "null_count": 123,
  "null_proportion": 123,
  "distinct_count": 123,
  "min_value": "<string>",
  "max_value": "<string>",
  "mean": 123,
  "median": 123,
  "stddev": 123,
  "histogram": {}
}

Documentation Index

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

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

Authorizations

Authorization
string
header
required

JWT Bearer token authentication. Include the token in the Authorization header as: Authorization: Bearer <token>. The JWT must contain valid client_id, and project_id claims for tenant isolation and SDK routing.

Query Parameters

fqn
string
required

Fully qualified name of the column (e.g., service.database.schema.table.column)

Minimum string length: 1

Response

Successful Response

Response model for the latest column profile.

id
string<uuid>
required

Profile UUID

asset_fqn
string
required

Fully qualified column name

service
string
required

Data service name

asset_version
string
required

Asset version

created_at
string
required

ISO 8601 timestamp when profile was captured

workflow_run_id
string<uuid>
required

Workflow run that produced this profile

database_name
string | null

Database name

schema_name
string | null

Schema name of the column

table_name
string | null

Table name

column_name
string | null

Column name

values_count
integer | null

Total values count

non_null_count
integer | null

Non-null values count

duplicate_count
integer | null

Duplicate values count

null_count
integer | null

Null values count

null_proportion
number | null

Proportion of null values (0.0-1.0)

distinct_count
integer | null

Distinct values count

min_value
string | null

Minimum value (as string)

max_value
string | null

Maximum value (as string)

mean
number | null

Mean value

median
number | null

Median value

stddev
number | null

Standard deviation

histogram
Histogram · object

Value distribution histogram