sources:
  - name: s3
    config:
      group: create
    tables:
      - name: ddb_orpheus
        description: |
          Orpheus DynamoDB data on S3 containing user interaction and engagement data from the Orpheus system.
          This table stores data exported from DynamoDB to S3 for analytics and reporting purposes.
          Used to enable Dagster dependency on the ddb_orpheus asset and provides access to
          user behavior data, interaction patterns, and engagement metrics from the Orpheus platform.
        tags: ['verified']
        columns:
          - name: user_id
            description: "Unique user identifier"
          - name: interaction_id
            description: "Unique identifier for the interaction"
          - name: interaction_type
            description: "Type of user interaction"
          - name: timestamp
            description: "Timestamp when interaction occurred"
          - name: session_id
            description: "Session identifier"
          - name: platform
            description: "Platform where interaction occurred"
          - name: metadata
            description: "Additional interaction metadata in JSON format"
          - name: p_date
            description: "Partition date for table optimization"
        meta:
          dagster:
            asset_key: ['ddb_orpheus']