connection: "snowflake_via_lookerappadmin"
include: "*.view.lkml"

explore: dt_promusicae_certification_album {
  hidden: yes

#Joins to include additional metadata
  join: facts_prod_dim_release {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_album.upc} = ${facts_prod_dim_release.upc};;
    fields: [
      release_name
    ]
  }

  join: facts_prod_dim_artist {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_album.artistid} = ${facts_prod_dim_artist.artist_id} ;;
    fields: [
      artist_name
    ]
  }

  join: facts_prod_dim_label {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_album.labelid} = ${facts_prod_dim_label.label_id} ;;
    fields: [
      label_name
    ]
  }
}

explore: dt_promusicae_certification_single {
  hidden: yes
#Joins to include additional metadata
  join: facts_prod_dim_track {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_single.isrc} = ${facts_prod_dim_track.isrc};;
    fields: [
      track_name
    ]
  }

  join: facts_prod_dim_artist {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_single.artistid} = ${facts_prod_dim_artist.artist_id} ;;
    fields: [
      artist_name
    ]
  }

  join: facts_prod_dim_label {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_single.labelid} = ${facts_prod_dim_label.label_id} ;;
    fields: [
      label_name
    ]
  }
}

explore: dt_promusicae_certification_album_incl_youtube {
  hidden: yes

#Joins to include additional metadata
  join: facts_prod_dim_release {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_album_incl_youtube.upc} = ${facts_prod_dim_release.upc};;
    fields: [
      release_name
    ]
  }

  join: facts_prod_dim_artist {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_album_incl_youtube.artistid} = ${facts_prod_dim_artist.artist_id} ;;
    fields: [
      artist_name
    ]
  }

  join: facts_prod_dim_label {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_album_incl_youtube.labelid} = ${facts_prod_dim_label.label_id} ;;
    fields: [
      label_name
    ]
  }
}

explore: dt_promusicae_certification_single_incl_youtube {
  hidden: yes
#Joins to include additional metadata
  join: facts_prod_dim_track {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_single_incl_youtube.isrc} = ${facts_prod_dim_track.isrc};;
    fields: [
      track_name
    ]
  }

  join: facts_prod_dim_artist {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_single_incl_youtube.artistid} = ${facts_prod_dim_artist.artist_id} ;;
    fields: [
      artist_name
    ]
  }

  join: facts_prod_dim_label {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${dt_promusicae_certification_single_incl_youtube.labelid} = ${facts_prod_dim_label.label_id} ;;
    fields: [
      label_name
    ]
  }
}