connection: "snowflake_via_lookerappadmin"

include: "int_dbt_prod_millward_brown_upc_list.view.lkml"
include: "orch_app_ar_releases.view.lkml"
include: "dt_label_manager_insights.view.lkml"

explore: int_dbt_prod_millward_brown_upc_list {
  label: "Millward Brown Report"
  case_sensitive: no
  hidden: yes

  join: orch_app_ar_releases {
    view_label: "Release"
    relationship: one_to_one
    sql_on: ${int_dbt_prod_millward_brown_upc_list.upc} = ${orch_app_ar_releases.upc} ;;
    fields: [is_active]
  }

  join: dt_label_manager_insights {
    view_label:  "Label"
    relationship:  one_to_one
    sql_on: ${int_dbt_prod_millward_brown_upc_list.vendor_id} = ${dt_label_manager_insights.label_id} ;;
    fields: [label_manager]
  }

  }