> ## 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 Data Connection

> Get data connection



## OpenAPI

````yaml /openapi/em-runtime-assets-v2.yaml get /assets/data/{resource_uri}
openapi: 3.1.0
info:
  title: em_runtime_assets
  version: 5.27.0
servers: []
security: []
paths:
  /assets/data/{resource_uri}:
    get:
      tags:
        - data_connections
      summary: Get Data Connection
      description: Get data connection
      operationId: get_data_connection
      parameters:
        - name: resource_uri
          in: path
          required: true
          schema:
            type: string
            description: >-
              Data connection resource URI (e.g.,
              'data:acme-corp:ml-project:customer-db')
            title: Resource Uri
          description: >-
            Data connection resource URI (e.g.,
            'data:acme-corp:ml-project:customer-db')
        - name: X-Project-ID
          in: header
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            title: X-Project-Id
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataConnectionDetail'
        '400':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
          description: Bad Request
        '401':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
          description: Unauthorized
        '404':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
          description: Not Found
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
        '500':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
          description: Internal Server Error
      security:
        - HTTPBearer: []
components:
  schemas:
    DataConnectionDetail:
      properties:
        resource_uri:
          type: string
          title: Resource Uri
        name:
          type: string
          title: Name
        type:
          type: string
          title: Type
          default: data
        connection_type:
          $ref: '#/components/schemas/DataConnectionType'
        status:
          $ref: '#/components/schemas/DataConnectionStatus'
        status_message:
          anyOf:
            - type: string
            - type: 'null'
          title: Status Message
        organization_id:
          type: string
          title: Organization Id
        project_id:
          anyOf:
            - type: string
            - type: 'null'
          title: Project Id
        owner_id:
          type: string
          title: Owner Id
          description: >-
            Deprecated: use created_by instead. Will be removed in a future
            release.
          deprecated: true
        description:
          anyOf:
            - type: string
            - type: 'null'
          title: Description
        tags:
          items:
            type: string
          type: array
          title: Tags
          default: []
        database_config:
          anyOf:
            - $ref: '#/components/schemas/DatabaseConnectionConfig'
            - type: 'null'
        storage_config:
          anyOf:
            - $ref: '#/components/schemas/StorageConnectionConfig'
            - type: 'null'
        filesystem_config:
          anyOf:
            - $ref: '#/components/schemas/FileSystemConnectionConfig'
            - type: 'null'
        secret_names:
          items:
            type: string
          type: array
          title: Secret Names
          default: []
        created_at:
          type: string
          format: date-time
          title: Created At
        updated_at:
          type: string
          format: date-time
          title: Updated At
        created_by:
          type: string
          title: Created By
        updated_by:
          type: string
          title: Updated By
      type: object
      required:
        - resource_uri
        - name
        - connection_type
        - status
        - organization_id
        - project_id
        - owner_id
        - created_at
        - updated_at
        - created_by
        - updated_by
      title: DataConnectionDetail
      description: Full data connection representation.
    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
    DataConnectionType:
      type: string
      enum:
        - postgres
        - redshift
        - mysql
        - bigquery
        - snowflake
        - databricks
        - couchbase
        - oracle
        - hive
        - mongodb
        - s3
        - gcs
        - minio
        - nfs
        - smb
      title: DataConnectionType
      description: Data connection types.
    DataConnectionStatus:
      type: string
      enum:
        - PENDING
        - ACTIVE
        - ERROR
        - DISABLED
      title: DataConnectionStatus
      description: Status of a data connection.
    DatabaseConnectionConfig:
      properties:
        host:
          type: string
          title: Host
        port:
          type: integer
          title: Port
        database:
          anyOf:
            - type: string
            - type: 'null'
          title: Database
          description: >-
            Database name. If not provided, connects at server level to discover
            available databases.
        auth_type:
          type: string
          title: Auth Type
          default: basic
        ssl_mode:
          type: string
          title: Ssl Mode
          default: disable
        selected_tables:
          anyOf:
            - items:
                $ref: '#/components/schemas/Database'
              type: array
            - type: 'null'
          title: Selected Tables
          description: >-
            Tables to use in this connection, organized by schema. Format:
            [{database_name': 'orchestrator', 'schemas': [{'schema_name':
            'public', 'tables': ['table1', 'table2']}}]]. If not provided, all
            accessible tables can be used.
        options:
          anyOf:
            - additionalProperties: true
              type: object
            - type: 'null'
          title: Options
      type: object
      required:
        - host
        - port
      title: DatabaseConnectionConfig
      description: Configuration for database connections.
    StorageConnectionConfig:
      properties:
        provider:
          type: string
          title: Provider
        bucket:
          type: string
          title: Bucket
        region:
          anyOf:
            - type: string
            - type: 'null'
          title: Region
        endpoint_url:
          anyOf:
            - type: string
            - type: 'null'
          title: Endpoint Url
      type: object
      required:
        - provider
        - bucket
      title: StorageConnectionConfig
      description: Configuration for object storage connections.
    FileSystemConnectionConfig:
      properties:
        path:
          type: string
          title: Path
        protocol:
          type: string
          title: Protocol
        auth_required:
          type: boolean
          title: Auth Required
          default: false
      type: object
      required:
        - path
        - protocol
      title: FileSystemConnectionConfig
      description: Configuration for file system connections.
    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
    Database:
      properties:
        database_name:
          type: string
          title: Database Name
        schemas:
          items:
            $ref: '#/components/schemas/DatabaseSchema'
          type: array
          title: Schemas
      type: object
      required:
        - database_name
        - schemas
      title: Database
    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.
    DatabaseSchema:
      properties:
        schema_name:
          type: string
          title: Schema Name
        tables:
          items:
            type: string
          type: array
          title: Tables
        views:
          items:
            type: string
          type: array
          title: Views
          default: []
      type: object
      required:
        - schema_name
        - tables
      title: DatabaseSchema
  securitySchemes:
    HTTPBearer:
      type: http
      scheme: bearer

````