> ## 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.

# Expand table selection via FK relationships

> Given a list of table FQNs, discover related tables via FK traversal (BFS).



## OpenAPI

````yaml /openapi/em-runtime-utils-v2.yaml post /utils/{resource_type}/{resource_uri}/fk-edges/expand
openapi: 3.1.0
info:
  title: em_runtime_utils
  version: 5.27.0
servers: []
security: []
paths:
  /utils/{resource_type}/{resource_uri}/fk-edges/expand:
    post:
      tags:
        - fk-graph
      summary: Expand table selection via FK relationships
      description: >-
        Given a list of table FQNs, discover related tables via FK traversal
        (BFS).
      operationId: expand_tables
      parameters:
        - name: resource_type
          in: path
          required: true
          schema:
            type: string
            title: Resource Type
        - name: resource_uri
          in: path
          required: true
          schema:
            type: string
            title: Resource Uri
        - name: X-Project-ID
          in: header
          required: true
          schema:
            type: string
            title: X-Project-Id
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ExpandTablesRequest'
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ExpandTablesResponse'
        '400':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
          description: Bad Request
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
        '403':
          description: Forbidden
          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:
        - HTTPBearer: []
components:
  schemas:
    ExpandTablesRequest:
      properties:
        table_fqns:
          items:
            type: string
          type: array
          maxItems: 100
          minItems: 1
          title: Table Fqns
          description: Table FQNs to expand from (max 100)
        max_hops:
          type: integer
          maximum: 10
          minimum: 1
          title: Max Hops
          description: Maximum BFS depth (1-10, default 2)
          default: 2
        include_input_tables:
          type: boolean
          title: Include Input Tables
          description: Include input tables in result
          default: true
      type: object
      required:
        - table_fqns
      title: ExpandTablesRequest
      description: Request to expand table selection via FK relationships.
    ExpandTablesResponse:
      properties:
        tables:
          items:
            type: string
          type: array
          title: Tables
          description: Expanded table FQNs (deduplicated)
        junction_tables:
          items:
            type: string
          type: array
          title: Junction Tables
          description: Junction tables discovered
        edges_examined:
          type: integer
          title: Edges Examined
          description: Number of FK edges examined during BFS
      type: object
      required:
        - tables
        - junction_tables
        - edges_examined
      title: ExpandTablesResponse
      description: Response for table expansion.
    ErrorResponse:
      properties:
        error:
          $ref: '#/components/schemas/ErrorBody'
      type: object
      required:
        - error
      title: ErrorResponse
      description: Standard error response model.
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: '#/components/schemas/ValidationError'
          type: array
          title: Detail
      type: object
      title: HTTPValidationError
    ErrorBody:
      properties:
        code:
          $ref: '#/components/schemas/ErrorCode'
        message:
          type: string
          title: Message
        details:
          additionalProperties: true
          type: object
          title: Details
        request_id:
          type: string
          title: Request Id
        timestamp:
          type: string
          format: date-time
          title: Timestamp
      type: object
      required:
        - code
        - message
        - request_id
        - timestamp
      title: ErrorBody
      description: Error body with structured details.
    ValidationError:
      properties:
        loc:
          items:
            anyOf:
              - type: string
              - type: integer
          type: array
          title: Location
        msg:
          type: string
          title: Message
        type:
          type: string
          title: Error Type
        input:
          title: Input
        ctx:
          type: object
          title: Context
      type: object
      required:
        - loc
        - msg
        - type
      title: ValidationError
    ErrorCode:
      type: string
      enum:
        - INVALID_REQUEST
        - INVALID_TOKEN
        - INSUFFICIENT_PERMISSIONS
        - RESOURCE_NOT_FOUND
        - RESOURCE_ALREADY_EXISTS
        - VALIDATION_ERROR
        - RATE_LIMIT_EXCEEDED
        - SERVICE_UNAVAILABLE
        - INTERNAL_ERROR
      title: ErrorCode
      description: Standard error codes for API responses.
  securitySchemes:
    HTTPBearer:
      type: http
      scheme: bearer

````