connection: "snowflake_via_lookerappadmin"

include: "*.view.lkml"                # include all views in the views/ folder in this project


explore: dt_proper_changed_releases {

  hidden: yes

  join: orch_app_ar_releases {
    sql_on: ${dt_proper_changed_releases.CatalogNumber}=${orch_app_ar_releases.product_code} ;;
    relationship: many_to_one
  }

  join: int_prod_vw_restrictions_release_territory {
    sql_on: ${int_prod_vw_restrictions_release_territory.release_id} = ${orch_app_ar_releases.release_id} ;;
    view_label: "Release Restrictions"
  }

  join: int_prod_vw_restrictions_release_store {
    sql_on: ${int_prod_vw_restrictions_release_store.release_id} = ${orch_app_ar_releases.release_id} ;;
    view_label: "Release Restrictions"
  }

  join: dt_supply_chain_sale_start_dates {
    view_label: "Supply Chain Release info"
    sql_on: ${orch_app_ar_releases.release_id} = ${dt_supply_chain_sale_start_dates.product_id} ;;
    relationship: many_to_one
  }
}