sources:
  - name: bi_podcasts
    description: ""
    database: facts
    schema: prod
    tables:
      - name: apple_podcasts_subscription_events
        description: "This table represents daily podcast subscription events at the subscriber level."
        columns:
          - name: report_date
            description: ""
          - name: storefront_name
            description: ""
          - name: event_date_legacy
            description: ""
          - name: channel_apple_id
            description: ""
          - name: channel_name
            description: ""
          - name: event_name
            description: ""
          - name: subscription_apple_id
            description: ""
          - name: subscription_name
            description: ""
          - name: subscription_sub_type
            description: ""
          - name: subscription_duration
            description: ""
          - name: subscription_start_date
            description: ""
          - name: device
            description: ""
          - name: prev_subscription_apple_id
            description: ""
          - name: prev_subscription_name
            description: ""
          - name: preserved_pricing
            description: ""
          - name: proceeds_reason
            description: ""
          - name: cancellation_reason
            description: ""
          - name: quantity
            description: ""
          - name: download_date
            description: ""
          - name: processed_daytime
            description: ""
          - name: event_date
            description: ""

      - name: apple_podcasts_subscription_events_weekly
        description: "This table represents weekly podcast subscription events at the subscriber level."
        columns:
          - name: report_date
            description: ""
          - name: storefront_name
            description: ""
          - name: event_date_legacy
            description: ""
          - name: channel_apple_id
            description: ""
          - name: channel_name
            description: ""
          - name: event_name
            description: ""
          - name: subscription_apple_id
            description: ""
          - name: subscription_name
            description: ""
          - name: subscription_sub_type
            description: ""
          - name: subscription_duration
            description: ""
          - name: subscription_start_date
            description: ""
          - name: device
            description: ""
          - name: prev_subscription_apple_id
            description: ""
          - name: prev_subscription_name
            description: ""
          - name: preserved_pricing
            description: ""
          - name: proceeds_reason
            description: ""
          - name: cancellation_reason
            description: ""
          - name: quantity
            description: ""
          - name: download_date
            description: ""
          - name: processed_daytime
            description: ""
          - name: event_date
            description: ""

      - name: apple_podcasts_subscription_events_monthly
        description: "This table represents monthly podcast subscription events at the subscriber level."
        columns:
          - name: report_date
            description: ""
          - name: storefront_name
            description: ""
          - name: event_date_legacy
            description: ""
          - name: channel_apple_id
            description: ""
          - name: channel_name
            description: ""
          - name: event_name
            description: ""
          - name: subscription_apple_id
            description: ""
          - name: subscription_name
            description: ""
          - name: subscription_sub_type
            description: ""
          - name: subscription_duration
            description: ""
          - name: subscription_start_date
            description: ""
          - name: device
            description: ""
          - name: prev_subscription_apple_id
            description: ""
          - name: prev_subscription_name
            description: ""
          - name: preserved_pricing
            description: ""
          - name: proceeds_reason
            description: ""
          - name: cancellation_reason
            description: ""
          - name: quantity
            description: ""
          - name: download_date
            description: ""
          - name: processed_daytime
            description: ""
          - name: event_date
            description: ""
          - name: source
            description: ""

      - name: apple_podcasts_subscription_snapshot
        description: "This provides a daily snapshot of the # of subscribers per country by date"
        columns:
          - name: report_date
            description: ""
          - name: storefront_name
            description: ""
          - name: channel_apple_id
            description: ""
          - name: channel_name
            description: ""
          - name: subscription_apple_id
            description: ""
          - name: subscription_name
            description: ""
          - name: subscription_state
            description: ""
          - name: subscription_sub_type
            description: ""
          - name: subscription_duration
            description: ""
          - name: device
            description: ""
          - name: customer_price
            description: ""
          - name: customer_currency
            description: ""
          - name: currency_of_proceeds
            description: ""
          - name: developer_proceeds
            description: ""
          - name: preserved_pricing
            description: ""
          - name: proceeds_reason
            description: ""
          - name: subscription_count
            description: ""
          - name: download_date
            description: ""
          - name: processed_daytime
            description: ""

      - name: apple_podcasts_subscription_snapshot_weekly
        description: "This provides a weekly snapshot of the # of subscribers per country by date"
        columns:
          - name: report_date
            description: ""
          - name: storefront_name
            description: ""
          - name: channel_apple_id
            description: ""
          - name: channel_name
            description: ""
          - name: subscription_apple_id
            description: ""
          - name: subscription_name
            description: ""
          - name: subscription_state
            description: ""
          - name: subscription_sub_type
            description: ""
          - name: subscription_duration
            description: ""
          - name: device
            description: ""
          - name: customer_price
            description: ""
          - name: customer_currency
            description: ""
          - name: currency_of_proceeds
            description: ""
          - name: developer_proceeds
            description: ""
          - name: preserved_pricing
            description: ""
          - name: proceeds_reason
            description: ""
          - name: subscription_count
            description: ""
          - name: download_date
            description: ""
          - name: processed_daytime
            description: ""

      - name: apple_podcasts_subscription_snapshot_monthly
        description: "This provides a monthly snapshot of the # of subscribers per country by date"
        columns:
          - name: report_date
            description: ""
          - name: storefront_name
            description: ""
          - name: channel_apple_id
            description: ""
          - name: channel_name
            description: ""
          - name: subscription_apple_id
            description: ""
          - name: subscription_name
            description: ""
          - name: subscription_state
            description: ""
          - name: subscription_sub_type
            description: ""
          - name: subscription_duration
            description: ""
          - name: device
            description: ""
          - name: customer_price
            description: ""
          - name: customer_currency
            description: ""
          - name: currency_of_proceeds
            description: ""
          - name: developer_proceeds
            description: ""
          - name: preserved_pricing
            description: ""
          - name: proceeds_reason
            description: ""
          - name: subscription_count
            description: ""
          - name: download_date
            description: ""
          - name: processed_daytime
            description: ""
          - name: source
            description: ""