label: "Certification Models"
connection: "snowflake_via_lookerappadmin"
include: "int_dbt_prod_promusicae_track_cert.view.lkml"
include: "int_dbt_prod_promusicae_album_cert.view.lkml"
include: "int_dbt_prod_promusicae_brazil_cert.view.lkml"
include: "int_dbt_prod_amprofon_track_cert.view.lkml"
include: "int_dbt_prod_amprofon_album_cert.view.lkml"
include: "int_dbt_prod_aria_album_cert.view.lkml"
include: "int_dbt_prod_aria_track_cert.view.lkml"
include: "int_dbt_prod_aria_album_cert_accounting.view.lkml"
include: "int_dbt_prod_aria_track_cert_accounting.view.lkml"
include: "int_dbt_prod_riaa_track_cert.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"
include: "int_dbt_prod_riaa_album_cert.view.lkml"

week_start_day: friday

explore: int_dbt_prod_promusicae_track_cert {
  label: "Promusicae Spain Track Certification"
  case_sensitive: no
  hidden: yes
}

explore: int_dbt_prod_promusicae_album_cert {
  label: "Promusicae Spain Album Certification"
  case_sensitive: no
  hidden: yes
}

explore: int_dbt_prod_promusicae_brazil_cert {
  label: "Promusicae Brazil Track Certification"
  case_sensitive: no
  hidden: yes
}

explore: int_dbt_prod_amprofon_track_cert {
  label: "Amprofon Mexico Track Certification"
  case_sensitive: no
  hidden: yes
}

explore: int_dbt_prod_amprofon_album_cert {
  label: "Amprofon Mexico Album Certification"
  case_sensitive: no
  hidden: yes
}

explore: int_dbt_prod_aria_track_cert {
  label: "ARIA Australia Track Certification"
  case_sensitive: no
  hidden: yes
}

explore: int_dbt_prod_aria_album_cert {
  label: "ARIA Australia Album Certification"
  case_sensitive: no
  hidden: yes
}

explore: int_dbt_prod_aria_album_cert_accounting {
  label: "ARIA Australia Album Certification (Accounting)"
  case_sensitive: no
  hidden: yes
}

explore: int_dbt_prod_aria_track_cert_accounting {
  label: "ARIA Australia Track Certification (Accounting)"
  case_sensitive: no
  hidden: yes
}

explore: int_dbt_prod_riaa_track_cert {
  label: "RIAA US Track Certification"
  case_sensitive: no

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_riaa_track_cert.label_id}= ${int_dbt_prod_awal_tier_groups.label_id};;
    fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
   }
}

explore: int_dbt_prod_riaa_album_cert {
  label: "RIAA US Album Certification"
  case_sensitive: no

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_riaa_album_cert.label_id}= ${int_dbt_prod_awal_tier_groups.label_id};;
    fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
  }
}