label: "Basic Models"
connection: "looker_high_performance"
include: "*.view.lkml"         # include all views in this project
# include: "*.dashboard.lookml"  # include all dashboards in this project

week_start_day: friday

explore: fact_analytics {
  label: "Analytics"
  hidden: yes

  access_filter: {
    field: dim_label.label_id
    user_attribute: label_id
  }


  join: dim_track {
    view_label: "Track"
    sql_on: ${fact_analytics.trackid}=${dim_track.trackid};;
    relationship: many_to_one
  }

  join: track_artist_snowflake_performer {
    from: track_artist_snowflake
    view_label: "Track"
    sql_on: ${track_artist_snowflake_performer.track_id} =${dim_track.track_unique_id}
      and ${track_artist_snowflake_performer.type}='performer';;
    relationship: many_to_one
    fields: [track_artist_snowflake_performer.track_artist_name_performer]
  }

  join: track_artist_snowflake_featuring {
    from: track_artist_snowflake
    view_label: "Track"
    sql_on: ${track_artist_snowflake_featuring.track_id} =${dim_track.track_unique_id}
      and ${track_artist_snowflake_featuring.type}='featuring';;
    relationship: many_to_one
    fields: [track_artist_snowflake_featuring.track_artist_name_featuring]
  }

  join: track_artist_snowflake_remixer {
    from: track_artist_snowflake
    view_label: "Track"
    sql_on: ${track_artist_snowflake_remixer.track_id} =${dim_track.track_unique_id}
      and ${track_artist_snowflake_remixer.type}='remixer';;
    relationship: many_to_one
    fields: [track_artist_snowflake_remixer.track_artist_name_remixer]
  }

  join: track_artist_snowflake_composer {
    from: track_artist_snowflake
    view_label: "Track"
    sql_on: ${track_artist_snowflake_composer.track_id} =${dim_track.track_unique_id}
      and ${track_artist_snowflake_composer.type}='composer';;
    relationship: many_to_one
    fields: [track_artist_snowflake_composer.track_artist_name_composer]
  }

  join: track_artist_snowflake_orchestra {
    from: track_artist_snowflake
    view_label: "Track"
    sql_on: ${track_artist_snowflake_orchestra.track_id} =${dim_track.track_unique_id}
      and ${track_artist_snowflake_orchestra.type}='orchestra';;
    relationship: many_to_one
    fields: [track_artist_snowflake_orchestra.track_artist_name_orchestra]
  }

  join: track_artist_snowflake_ensemble {
    from: track_artist_snowflake
    view_label: "Track"
    sql_on: ${track_artist_snowflake_ensemble.track_id} =${dim_track.track_unique_id}
      and ${track_artist_snowflake_ensemble.type}='ensemble';;
    relationship: many_to_one
    fields: [track_artist_snowflake_ensemble.track_artist_name_ensemble]
  }

  join: track_artist_snowflake_conductor {
    from: track_artist_snowflake
    view_label: "Track"
    sql_on: ${track_artist_snowflake_conductor.track_id} =${dim_track.track_unique_id}
      and ${track_artist_snowflake_conductor.type}='conductor';;
    relationship: many_to_one
    fields: [track_artist_snowflake_conductor.track_artist_name_conductor]
  }

  join: track_artist_snowflake_other {
    from: track_artist_snowflake
    view_label: "Track"
    sql_on: ${track_artist_snowflake_other.track_id} =${dim_track.track_unique_id}
      and ${track_artist_snowflake_other.type} not in ('performer', 'featuring', 'remixer', 'composer', 'orchestra', 'ensemble', 'conductor');;
    relationship: many_to_one
    fields: [track_artist_snowflake_other.track_artist_name_other]
  }
  join: dim_release {
    view_label: "Releases"
    sql_on: ${fact_analytics.upc}=${dim_release.upc} ;;
    relationship: many_to_one
  }

  join: releases_snowflake {
    view_label: "Releases"
    sql_on: ${releases_snowflake.release_id}=${dim_release.product_id} ;;
    relationship: many_to_one
    fields: [releases_snowflake.format]
  }

  join: dim_artist {
    view_label: "Artist"
    sql_on: ${fact_analytics.artist_id}=${dim_artist.artist_id} ;;
    relationship: many_to_one
    fields: [dim_artist.last_updated_date,dim_artist.artist_id, dim_artist.artist_name,
      dim_artist.date_created_date, dim_artist.number_of_artists]
  }
#
#   join: dim_country_artist {
#     from:  dim_country
#     view_label: "Artist"
#     sql_on: ${dim_artist.country_id}=${dim_country_artist.country_id} ;;
#     relationship: many_to_one
#     fields: [dim_country_artist.country_name,dim_country_artist.country_code,dim_country_artist.continent]
#   }

  join: dim_transactiontype {
    view_label: "Transaction Type"
    sql_on: ${fact_analytics.transaction_type_id}=${dim_transactiontype.transaction_type_id} ;;
    relationship: many_to_one
  }

  join: dim_country {
    view_label: "Territory"
    sql_on: ${fact_analytics.country_id}=${dim_country.country_id} ;;
    relationship: many_to_one
  }

  join: dim_label {
    view_label: "Label"
    sql_on: ${fact_analytics.label_id} = ${dim_label.label_id}  ;;
    relationship: many_to_one
  }

#   join: label_country {
#     from:  dim_country
#     view_label: "Label"
#     sql_on: ${dim_label.country_id} = ${label_country.country_id}  ;;
#     relationship: many_to_one
#     fields: [label_country.continent,label_country.country_code,
#       label_country.country_name]
#   }
#
#   join: dim_owner {
#     view_label: "Owner"
#     sql_on: ${dim_label.owner_id} = ${dim_owner.ownerid} ;;
#     relationship: many_to_one
#   }

  join: dim_imprint {
    view_label: "Imprint"
    sql_on:  ${fact_analytics.imprint_id} = ${dim_imprint.imprint_id}  ;;
    relationship: many_to_one
  }

  join: dim_subaccount {
    view_label: "Subaccount"
    sql_on: ${fact_analytics.subaccount_id}=${dim_subaccount.subaccount_id} ;;
    relationship: many_to_one
  }

  join: product_type_snowflake {
    view_label: "Product Type"
    sql_on: ${dim_release.product_type_id}= ${product_type_snowflake.id} ;;
    relationship: many_to_one
  }

#   join: mkt_priority_snowflake {
#     view_label: "Mkt Priority"
#     sql_on: ${mkt_priority_snowflake.upc}=${dim_release.upc} AND ${mkt_priority_snowflake.id} is not null ;;
#     relationship: many_to_one
#   }

  join: dim_store {
    view_label: "Store"
    sql_on:  ${fact_analytics.store_id} = ${dim_store.store_id} ;;
    relationship: many_to_one
  }

  join: dim_catalog {
    view_label: "Catalog"
    sql_on:  ${fact_analytics.catalog_id} = ${dim_catalog.catalog_id}  ;;
    relationship: many_to_one
    fields: [dim_catalog.catalog_id,dim_catalog.catalog_name, dim_catalog.catalog_number,
      dim_catalog.count_distinct_catalogs]
  }
#
#   join: product_physical_snowflake {
#     view_label: "Product Physical"
#     sql_on: ${product_physical_snowflake.release_id}=${dim_release.product_id} ;;
#     relationship: one_to_one
#   }
#
#   join: product_physical_packaging_snowflake {
#     view_label: "Product Physical Packaging"
#     sql_on: ${product_physical_snowflake.packaging_id}=${product_physical_packaging_snowflake.id} ;;
#     relationship: many_to_one
#   }
#
#   join: mkt_program_info_snowflake {
#     view_label: "Mkt Program"
#     sql_on: ${mkt_program_info_snowflake.info_for_id}=${dim_release.product_id} AND ${mkt_program_info_snowflake.info_for} ='release' ;;
#     relationship: many_to_one
#     fields: [mkt_program_info_snowflake.attachment,mkt_program_info_snowflake.client,mkt_program_info_snowflake.date_added,
#       mkt_program_info_snowflake.info_for,mkt_program_info_snowflake.description]
#   }
#
#   join: mkt_program_info_snowflake_mkt_drivers {
#     from: mkt_program_info_snowflake
#     view_label: "Mkt Program"
#     sql_on: ${mkt_program_info_snowflake_mkt_drivers.info_for_id}=${dim_release.product_id} AND ${mkt_program_info_snowflake_mkt_drivers.info_for} ='release' and ${mkt_program_info_snowflake_mkt_drivers.mkt_program_id}=12 ;;
#     relationship: many_to_one
#     fields: [mkt_program_info_snowflake_mkt_drivers.description_drivers]
#   }
#
#   join: mkt_program_info_snowflake_mkt_blurb {
#     from: mkt_program_info_snowflake
#     view_label: "Mkt Program"
#     sql_on: ${mkt_program_info_snowflake_mkt_blurb.info_for_id}=${dim_release.product_id} AND ${mkt_program_info_snowflake_mkt_drivers.info_for} ='release'  and ${mkt_program_info_snowflake_mkt_blurb.mkt_program_id}=15 ;;
#     relationship: many_to_one
#     fields: [mkt_program_info_snowflake_mkt_blurb.description_blurb]
#   }
#
#   join: mkt_program_info_snowflake_mkt_highlights {
#     from: mkt_program_info_snowflake
#     view_label: "Mkt Program"
#     sql_on: ${mkt_program_info_snowflake_mkt_highlights.info_for_id}=${dim_release.product_id} AND ${mkt_program_info_snowflake_mkt_drivers.info_for} ='release' and ${mkt_program_info_snowflake_mkt_highlights.mkt_program_id}=20;;
#     relationship: many_to_one
#     fields: [mkt_program_info_snowflake_mkt_highlights.description_highlights]
#   }

#   join: mkt_program_snowflake {
#     view_label: "Mkt Program"
#     sql_on: ${mkt_program_info_snowflake.mkt_program_id}=${mkt_program_snowflake.mkt_program_id} ;;
#     relationship: many_to_one
#   }

  join: dim_genre {
    view_label: "Release Genre"
    sql_on: ${fact_analytics.genre_id}= ${dim_genre.genreid} ;;
    relationship: many_to_one
  }

  join: release_subgenre_snowflake {
    view_label: "Release Subgenre"
    sql_on: ${dim_release.product_id} = ${release_subgenre_snowflake.release_id} ;;
    relationship: many_to_one
    fields: [release_subgenre_snowflake.subgenre_id, release_subgenre_snowflake.number_of_subgenres]
  }

  join: subgenre_snowflake {
    view_label: "Release Subgenre"
    sql_on: ${release_subgenre_snowflake.subgenre_id}= ${subgenre_snowflake.orchard_id} ;;
    relationship: many_to_one
    fields: [subgenre_snowflake.name]
  }

#   join: product_store_effective_price_code {
#     view_label: "Physical Price Code"
#     sql_on: ${dim_release.product_id}= ${product_store_effective_price_code.product_id}  ;;
#     relationship: many_to_one
#     fields: [product_store_effective_price_code.price_code,product_store_effective_price_code.store_pricing_tier_name]
#   }
#
#   join: customer_master_master_snowflake {
#     view_label: "Physical Price Code"
#     sql_on: ${product_store_effective_price_code.store_id}= ${customer_master_master_snowflake.customer_master_master_id} ;;
#     relationship: many_to_one
#     fields: [customer_master_master_snowflake.customer_name]
#   }





}