> ## 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. # Get latest table profile by FQN > Get the most recent profiling data for a table by its fully qualified name. Args: fqn: Fully qualified name of the table. ctx: Request context for authentication. profile_service: Profile service instance. Returns: Latest table profile data. Raises: HTTPException: 404 if no profile found for the table. ## OpenAPI ````yaml /openapi/em-data-readiness-v2.yaml get /api/data-readiness/data-assets/profiles/tables/by-fqn 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/tables/by-fqn: get: tags: - Data Assets summary: Get latest table profile by FQN description: >- Get the most recent profiling data for a table by its fully qualified name. Args: fqn: Fully qualified name of the table. ctx: Request context for authentication. profile_service: Profile service instance. Returns: Latest table profile data. Raises: HTTPException: 404 if no profile found for the table. operationId: get_table_profile_by_fqn parameters: - name: fqn in: query required: true schema: type: string minLength: 1 description: >- Fully qualified name of the table (e.g., service.database.schema.table) title: Fqn description: >- Fully qualified name of the table (e.g., service.database.schema.table) responses: '200': description: Successful Response content: application/json: schema: $ref: '#/components/schemas/TableProfileResponse' '404': description: Table profile not found content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' '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: TableProfileResponse: properties: id: type: string format: uuid title: Id description: Profile UUID asset_fqn: type: string title: Asset Fqn description: Fully qualified table 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 table table_name: anyOf: - type: string - type: 'null' title: Table Name description: Table name asset_version: type: string title: Asset Version description: Asset version row_count: anyOf: - type: integer - type: 'null' title: Row Count description: Number of rows in the table column_count: anyOf: - type: integer - type: 'null' title: Column Count description: Number of columns in the table sample_data_rows: anyOf: - items: additionalProperties: true type: object type: array - type: 'null' title: Sample Data Rows description: Sample data rows size_bytes: anyOf: - type: integer - type: 'null' title: Size Bytes description: Table size in bytes 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: TableProfileResponse description: Response model for the latest table profile. 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" } HTTPValidationError: properties: detail: items: $ref: '#/components/schemas/ValidationError' type: array title: Detail type: object title: HTTPValidationError 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. 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 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. ````