connection: "snowflake_via_lookerappadmin"

include: "tiktok_pitch_grid_us.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"
include: "orch_app_ar_track.view"

# # Select the views that should be a part of this model,
# # and define the joins that connect them together.
#
 explore: tiktok_pitch_grid_us {
    view_label: "TikTok Pitch Grid"
    label: "TikTok Pitch Grid"

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

  join: orch_app_ar_track {
    view_label: "TikTok Pitch Grid"
    relationship: many_to_one
    sql_on: ${orch_app_ar_track.upc}= ${tiktok_pitch_grid_us.UPC};;
    fields: [orch_app_ar_track.isrc]
  }
}