connection: "orchard-strategy"

include: "/views/airtable_advertising_data/*.view.lkml"
include: "/views/intelligence_prod/*.view.lkml"
include: "/views/rm_dashboard/*.view.lkml"


week_start_day: friday
fiscal_month_offset: -9

explore: int_dbt_prod_advertising_monthly_requests_cleaned {

  label: "Advertising Monthly Requests"

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_advertising_monthly_requests_cleaned.label_id} = cast(${int_dbt_prod_awal_tier_groups.label_id} as varchar);;
    fields: [service_tier_name, label_name]
  }

  join: int_dbt_prod_rm_db_label_rm_mapping {
    relationship: many_to_many
    sql_on: ${int_dbt_prod_advertising_monthly_requests_cleaned.label_id} = cast(${int_dbt_prod_rm_db_label_rm_mapping.labelid} as varchar);;
    fields: [int_dbt_prod_rm_db_label_rm_mapping.relationship_manager]
  }
}