view: int_dev_fact_yt_traffic_source_by_asset {
  sql_table_name: intelligence.dev.fact_youtube_traffic_source_by_asset ;;

  dimension: activitycountryid {
    type: number
    sql: ${TABLE}.activitycountryid ;;
  }

  dimension: artistid {
    type: number
    sql: ${TABLE}.artistid ;;
  }

  dimension: assetid {
    type: string
    sql: ${TABLE}.assetid ;;
  }

  dimension: assettype {
    type: string
    sql: ${TABLE}.assettype ;;
  }

  dimension: average_view_duration_percentage {
    type: number
    sql: ${TABLE}.average_view_duration_percentage ;;
  }

  dimension: average_view_duration_seconds {
    type: number
    sql: ${TABLE}.average_view_duration_seconds ;;
  }

  dimension: catalogid {
    type: number
    sql: ${TABLE}.catalogid ;;
  }

  dimension: channelid {
    type: string
    sql: ${TABLE}.channelid ;;
  }

  dimension: contentowner {
    type: string
    sql: ${TABLE}.contentowner ;;
  }

  dimension: dayid {
    type: number
    sql: ${TABLE}.dayid ;;
  }

  dimension: download_activity_date {
    type: date
    sql: ${TABLE}.download_activity_date ;;
  }

  dimension: genreid {
    type: number
    sql: ${TABLE}.genreid ;;
  }

  dimension: imprintid {
    type: number
    sql: ${TABLE}.imprintid ;;
  }

  dimension: isrcid {
    type: number
    sql: ${TABLE}.isrcid ;;
  }

  dimension: labelid {
    type: number
    sql: ${TABLE}.labelid ;;
  }

  dimension: liveorondemand {
    type: string
    sql: ${TABLE}.liveorondemand ;;
  }

  dimension: processeddaytime {
    type: date_time
    sql: ${TABLE}.processeddaytime ;;
  }

  dimension: red_views {
    type: number
    sql: ${TABLE}.red_views ;;
  }

  dimension: red_watch_time_minutes {
    type: number
    sql: ${TABLE}.red_watch_time_minutes ;;
  }

  dimension: releaseid {
    type: number
    sql: ${TABLE}.releaseid ;;
  }

  dimension: storeid {
    type: number
    sql: ${TABLE}.storeid ;;
  }

  dimension: subaccountid {
    type: number
    sql: ${TABLE}.subaccountid ;;
  }

  dimension: trackid {
    type: number
    sql: ${TABLE}.trackid ;;
  }

  dimension: trafficsourcedetail {
    type: string
    sql: ${TABLE}.trafficsourcedetail ;;
  }

  dimension: trafficsourceid {
    type: number
    sql: ${TABLE}.trafficsourceid ;;
  }

  dimension: uploadertype {
    type: string
    sql: ${TABLE}.uploadertype ;;
  }

  dimension: videoid {
    type: string
    sql: ${TABLE}.videoid ;;
  }

  dimension: views {
    type: number
    sql: ${TABLE}.views ;;
  }

  dimension: watch_time_minutes {
    type: number
    sql: ${TABLE}.watch_time_minutes ;;
  }
}