label: "Ad-Sales"
connection: "snowflake_via_lookerappadmin"

include: "/views/int_dbt_prod_artist_demographics.view.lkml"
include: "/views/int_dbt_prod_artist_streaming_trends.view.lkml"
include: "/views/int_dbt_prod_youtube_partnered_channels.view.lkml"


explore: int_dbt_prod_artist_streaming_trends {
  label: "Atrist Trends & Demographics"
  view_label: "Artist Streaming Trends"
  case_sensitive: no
  hidden: no

  join: int_dbt_prod_artist_demographics {
    view_label: "Artist Demographics"
    relationship: many_to_one #need to confirm this is correct
    sql_on: ${int_dbt_prod_artist_demographics.artist_name} = ${int_dbt_prod_artist_streaming_trends.artist_name} ;;
  }

  join: int_dbt_prod_youtube_partnered_channels {
    view_label:  "YouTube Partnered Channels"
    relationship: many_to_one #need to confirm this is correct
    sql_on: ${int_dbt_prod_youtube_partnered_channels.artist_name} = ${int_dbt_prod_artist_streaming_trends.artist_name} ;;
  }

}