connection: "snowflake_via_lookerappadmin"
label: "Demographics"

include: "int_dbt_prod_apple_music_demographic.view.lkml"
include: "int_dbt_prod_agg_apple_model.view.lkml"
include: "facts_prod_dim_label.view.lkml"
# include all views in the views/ folder in this project
# include: "/**/*.view.lkml"                 # include all views in this project
# include: "my_dashboard.dashboard.lookml"   # include a LookML dashboard called my_dashboard
week_start_day: friday

fiscal_month_offset: -9


explore: int_dbt_prod_apple_music_demographic {
  label: "Apple Music Demographic Model"
  case_sensitive: no

  hidden: no

  join: int_dbt_prod_agg_apple_model {
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_apple_music_demographic.Upc} = ${int_dbt_prod_agg_apple_model.upc} ;;
    fields: []
  }

  join: facts_prod_dim_label {
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_agg_apple_model.label_id} = ${facts_prod_dim_label.label_id} ;;
    fields: [
         label_id, label_name
    ]
  }
  }