connection: "youtube-looker"
label: "YouTube"
include: "/views/facts_prod_fact_youtube_video_demographics.view.lkml"
include: "/views/facts_prod_dim_trafficsource.view.lkml"
include: "/views/facts_prod_dim_os.view.lkml"
include: "/views/facts_prod_dim_playback.view.lkml"
include: "/views/facts_prod_dim_device.view.lkml"
include: "/views/facts_prod_dim_country.view.lkml"
include: "/views/facts_prod_dim_store.view.lkml"
include: "/views/facts_prod_dim_feed.view.lkml"
include: "/views/int_dev_skeels_youtube_channel_mappings.view.lkml"

explore: facts_prod_fact_youtube_video_demographics {
  hidden: no
  label: "YouTube Video Demographics"
  view_label: "Video"


  join: facts_prod_dim_trafficsource {
    sql_on: ${facts_prod_fact_youtube_video_demographics.trafficsourceid} =
      ${facts_prod_dim_trafficsource.trafficsourceid};;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_trafficsource.trafficsourcedesc]
  }

  join: facts_prod_dim_os {
    sql_on: ${facts_prod_fact_youtube_video_demographics.osid} =
      ${facts_prod_dim_os.osid};;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_os.osdesc]
  }

  join: facts_prod_dim_playback {
    sql_on: ${facts_prod_fact_youtube_video_demographics.playbackid} =
      ${facts_prod_dim_playback.playbackid};;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_playback.playbackdesc]
  }

  join: facts_prod_dim_device {
    sql_on: ${facts_prod_fact_youtube_video_demographics.deviceid} =
      ${facts_prod_dim_device.deviceid};;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_device.devicedesc]
  }

  join: facts_prod_dim_country {
    sql_on: ${facts_prod_fact_youtube_video_demographics.activitycountryid} =
      ${facts_prod_dim_country.country_id};;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_country.country_name]
  }

  join: facts_prod_dim_store {
    sql_on: ${facts_prod_fact_youtube_video_demographics.storeid} =
      ${facts_prod_dim_store.store_id} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_store.store_name]
  }

  join: facts_prod_dim_feed {
    sql_on: ${facts_prod_fact_youtube_video_demographics.feedid} =
      ${facts_prod_dim_feed.feedid} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_feed.feedname]
  }

  join: int_dev_skeels_youtube_channel_mappings {
    sql_on: ${facts_prod_fact_youtube_video_demographics.channelid} =
      ${int_dev_skeels_youtube_channel_mappings.channel_id} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [int_dev_skeels_youtube_channel_mappings.public_name]
  }


}