> ## 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. # Batch-fetch latest column profiles by table and/or column FQN > Return the latest column profile for every column matched by table_fqns and/or column_fqns. At least one filter is required (validated in the request model). Returns an empty list when nothing is profiled — does NOT 404. ## OpenAPI ````yaml /openapi/em-data-readiness-v2.yaml post /api/data-readiness/data-assets/profiles/columns/batch openapi: 3.1.0 info: title: EM Data Readiness Service description: Data Readiness Service API for managing workflows, metrics, and data quality version: 4.3.0-dev1 servers: [] security: - BearerAuth: [] tags: - name: Health description: Service health monitoring. Check service status and version information. - name: Root description: Root endpoint providing service information and navigation links. - name: Configuration description: Service configuration endpoints. View current configuration values. - name: Workflows description: >- Workflow configuration and execution management. Create, configure, and run data quality workflows including definitions, configurations, runs, and tasks. - name: Data Assets description: >- Data catalog entity management. Manage databases, schemas, and tables metadata. - name: Metrics description: >- Data quality metrics and scorecards. Calculate scores, view trends, and analyze dimensions. - name: Violations description: >- Data quality violation management. View, acknowledge, and remediate detected violations. - name: Glossary description: >- Business glossary management. Create, verify, and organize business terms and definitions. paths: /api/data-readiness/data-assets/profiles/columns/batch: post: tags: - Data Assets summary: Batch-fetch latest column profiles by table and/or column FQN description: >- Return the latest column profile for every column matched by table_fqns and/or column_fqns. At least one filter is required (validated in the request model). Returns an empty list when nothing is profiled — does NOT 404. operationId: get_column_profiles_batch requestBody: content: application/json: schema: $ref: '#/components/schemas/ColumnProfileBatchRequest' required: true responses: '200': description: Successful Response content: application/json: schema: $ref: '#/components/schemas/ColumnProfileBatchResponse' '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' '500': description: Internal Server Error content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' security: - BearerAuth: [] components: schemas: ColumnProfileBatchRequest: properties: table_fqns: anyOf: - items: type: string type: array - type: 'null' title: Table Fqns column_fqns: anyOf: - items: type: string type: array - type: 'null' title: Column Fqns type: object title: ColumnProfileBatchRequest description: >- Request body for POST /profiles/columns/batch. At least one of table_fqns / column_fqns must be non-empty. The sum of identifiers across both fields must not exceed 200. ColumnProfileBatchResponse: properties: profiles: items: $ref: '#/components/schemas/ColumnProfileResponse' type: array title: Profiles type: object required: - profiles title: ColumnProfileBatchResponse description: Response body for POST /profiles/columns/batch. HTTPValidationError: properties: detail: items: $ref: '#/components/schemas/ValidationError' type: array title: Detail type: object title: HTTPValidationError ErrorResponse: properties: error: $ref: '#/components/schemas/ErrorInfo' description: >- Error information object containing code, message, and optional details request_id: anyOf: - type: string - type: 'null' title: Request Id description: Request ID for debugging and support examples: - req_abc123xyz type: object required: - error title: ErrorResponse description: >- Standard error response model for API errors. Matches the structure returned by _handle_service_error in workflows/routes.py. The actual API response format is: { "error": { "code": "ERROR_CODE", "message": "Error message", "details": {...} }, "request_id": "optional-request-id" } ColumnProfileResponse: properties: id: type: string format: uuid title: Id description: Profile UUID asset_fqn: type: string title: Asset Fqn description: Fully qualified column name service: type: string title: Service description: Data service name database_name: anyOf: - type: string - type: 'null' title: Database Name description: Database name schema_name: anyOf: - type: string - type: 'null' title: Schema Name description: Schema name of the column table_name: anyOf: - type: string - type: 'null' title: Table Name description: Table name column_name: anyOf: - type: string - type: 'null' title: Column Name description: Column name asset_version: type: string title: Asset Version description: Asset version values_count: anyOf: - type: integer - type: 'null' title: Values Count description: Total values count non_null_count: anyOf: - type: integer - type: 'null' title: Non Null Count description: Non-null values count duplicate_count: anyOf: - type: integer - type: 'null' title: Duplicate Count description: Duplicate values count null_count: anyOf: - type: integer - type: 'null' title: Null Count description: Null values count null_proportion: anyOf: - type: number - type: 'null' title: Null Proportion description: Proportion of null values (0.0-1.0) distinct_count: anyOf: - type: integer - type: 'null' title: Distinct Count description: Distinct values count min_value: anyOf: - type: string - type: 'null' title: Min Value description: Minimum value (as string) max_value: anyOf: - type: string - type: 'null' title: Max Value description: Maximum value (as string) histogram: anyOf: - additionalProperties: true type: object - type: 'null' title: Histogram description: Value distribution histogram created_at: type: string title: Created At description: ISO 8601 timestamp when profile was captured workflow_run_id: type: string format: uuid title: Workflow Run Id description: Workflow run that produced this profile type: object required: - id - asset_fqn - service - asset_version - created_at - workflow_run_id title: ColumnProfileResponse description: Response model for the latest column profile. ValidationError: properties: loc: items: anyOf: - type: string - type: integer type: array title: Location msg: type: string title: Message type: type: string title: Error Type type: object required: - loc - msg - type title: ValidationError ErrorInfo: properties: code: type: string title: Code description: >- Error code identifier (e.g., 'WORKFLOW_NOT_FOUND', 'VALIDATION_ERROR') examples: - WORKFLOW_NOT_FOUND message: type: string title: Message description: Human-readable error message examples: - >- Workflow configuration with id '123e4567-e89b-12d3-a456-426614174000' not found details: anyOf: - additionalProperties: true type: object - type: 'null' title: Details description: >- Additional error details as a dictionary (flexible structure for business logic errors) examples: - workflow_id: 123e4567-e89b-12d3-a456-426614174000 type: object required: - code - message title: ErrorInfo description: >- Nested error information object. Note: This model uses an untyped dict for `details` to match the flexible error structure used throughout the service layer (see WorkflowServiceError and similar). This is distinct from ErrorDetail, which is used for structured validation errors. securitySchemes: BearerAuth: type: http scheme: bearer bearerFormat: JWT description: >- JWT Bearer token authentication. Include the token in the Authorization header as: `Authorization: Bearer `. The JWT must contain valid client_id, and project_id claims for tenant isolation and SDK routing. ````