label: "Release Compare Datasets"
connection: "snowflake_via_lookerappadmin"

include: "int_dbt_prod_release_compare_model_spotify_store.view.lkml"
include: "int_dbt_prod_release_compare_model_amazon_store.view.lkml"
include: "int_dbt_prod_release_compare_model_apple_store.view.lkml"
include: "int_dbt_prod_release_compare_model_apple_playlist.view.lkml"
include: "facts_prod_dim_track.view.lkml"
include: "facts_prod_dim_country.view.lkml"
include: "orch_app_ar_track.view.lkml"

explore: int_dbt_prod_release_compare_model_spotify_store {
  label: "Release Compare Model Spotify Store"
  case_sensitive: no
  hidden: yes

  join: facts_prod_dim_track {
    view_label: "Track"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_release_compare_model_spotify_store.Isrc} = ${facts_prod_dim_track.isrc} and ${int_dbt_prod_release_compare_model_spotify_store.Upc} = ${facts_prod_dim_track.upc};;
    fields: [
      track_name
    ]
  }

  join: facts_prod_dim_country {
    view_label: "Country"
    relationship: many_to_one
    sql_on:${int_dbt_prod_release_compare_model_spotify_store.Transaction_country_code} = ${facts_prod_dim_country.country_code}  ;;
    fields: [facts_prod_dim_country.country_name]
  }

  join: orch_app_ar_track {
    view_label: "Track"
    sql_on: ${int_dbt_prod_release_compare_model_spotify_store.Isrc} = ${orch_app_ar_track.isrc} and ${int_dbt_prod_release_compare_model_spotify_store.Upc} = ${orch_app_ar_track.upc};;
    fields: [
      orch_app_ar_track.position
    ]
  }

}

explore: int_dbt_prod_release_compare_model_amazon_store {
  label: "Release Compare Model Amazon Store"
  case_sensitive: no
  hidden: yes

  join: facts_prod_dim_track {
    view_label: "Track"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_release_compare_model_amazon_store.Isrc} = ${facts_prod_dim_track.isrc} and ${int_dbt_prod_release_compare_model_amazon_store.Upc} = ${facts_prod_dim_track.upc};;
    fields: [
      track_name
    ]
  }

  join: facts_prod_dim_country {
    view_label: "Country"
    relationship: many_to_one
    sql_on:${int_dbt_prod_release_compare_model_amazon_store.Transaction_country_code} = ${facts_prod_dim_country.country_code}  ;;
    fields: [facts_prod_dim_country.country_name]
  }

  join: orch_app_ar_track {
    view_label: "Track"
    sql_on: ${int_dbt_prod_release_compare_model_amazon_store.Isrc} = ${orch_app_ar_track.isrc} and ${int_dbt_prod_release_compare_model_amazon_store.Upc} = ${orch_app_ar_track.upc};;
    fields: [
      orch_app_ar_track.position
    ]
  }

}

explore: int_dbt_prod_release_compare_model_apple_store {
  label: "Release Compare Model Apple Store"
  case_sensitive: no
  hidden: yes

  join: facts_prod_dim_track {
    view_label: "Track"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_release_compare_model_apple_store.Isrc} = ${facts_prod_dim_track.isrc} and ${int_dbt_prod_release_compare_model_apple_store.Upc} = ${facts_prod_dim_track.upc};;
    fields: [
      track_name
    ]
  }

  join: facts_prod_dim_country {
    view_label: "Country"
    relationship: many_to_one
    sql_on:${int_dbt_prod_release_compare_model_apple_store.Transaction_country_code} = ${facts_prod_dim_country.country_code}  ;;
    fields: [facts_prod_dim_country.country_name]
  }

  join: orch_app_ar_track {
    view_label: "Track"
    sql_on: ${int_dbt_prod_release_compare_model_apple_store.Isrc} = ${orch_app_ar_track.isrc} and ${int_dbt_prod_release_compare_model_apple_store.Upc} = ${orch_app_ar_track.upc};;
    fields: [
      orch_app_ar_track.position
    ]
  }

}

explore: int_dbt_prod_release_compare_model_apple_playlist {
  label: "Release Compare Model Apple Playlist"
  case_sensitive: no
  hidden: yes

  join: facts_prod_dim_track {
    view_label: "Track"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_release_compare_model_apple_playlist.Isrc} = ${facts_prod_dim_track.isrc} and ${int_dbt_prod_release_compare_model_apple_playlist.Upc} = ${facts_prod_dim_track.upc};;
    fields: [
      track_name
    ]
  }

  join: facts_prod_dim_country {
    view_label: "Country"
    relationship: many_to_one
    sql_on:${int_dbt_prod_release_compare_model_apple_playlist.Transaction_country_code} = ${facts_prod_dim_country.country_code}  ;;
    fields: [facts_prod_dim_country.country_name]
  }

  join: orch_app_ar_track {
    view_label: "Track"
    sql_on: ${int_dbt_prod_release_compare_model_apple_playlist.Isrc} = ${orch_app_ar_track.isrc} and ${int_dbt_prod_release_compare_model_apple_playlist.Upc} = ${orch_app_ar_track.upc};;
    fields: [
      orch_app_ar_track.position
    ]
  }

}