Get latest column profile by FQN

Get the most recent profiling data for a column by its fully qualified name.

Args: fqn: Fully qualified name of the column. ctx: Request context for authentication. profile_service: Profile service instance.

Returns: Latest column profile data.

Raises: HTTPException: 404 if no profile found for the column.

GET /api/data-readiness/data-assets/profiles/columns/by-fqn

Get latest column profile by FQN

cURL

curl --request GET \
  --url https://api.example.com/api/data-readiness/data-assets/profiles/columns/by-fqn \
  --header 'Authorization: Bearer <token>'

200

{
  "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": {}
}

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

200

application/json

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