label: "Data Squad - Master Calendar Models"
connection: "datasquad-looker"
include: "facts_prod_dim_day.view.lkml"
include: "facts_prod_dim_licensor.view.lkml"
include: "facts_prod_fact_analytics_for_master_calendar.view.lkml"

week_start_day: friday


# datagroup: internal_availability_datagroup_sme {
#   label: "Internal Availability Datagroup"
#   max_cache_age: "28 hours"
#   sql_trigger: SELECT COUNT(*) FROM (
#                 SELECT DISTINCT FEEDID FROM FACTS.PROD.FACT_ANALYTICS
#                 WHERE DOWNLOAD_ACTIVITY_DATE >= DATEADD('day', -1, CURRENT_DATE())
#                 AND LICENSORID iN (
#                   SELECT LICENSORID FROM FACTS.PROD.DIM_LICENSOR
#                   WHERE DISTRIBUTOR = 'sme'
#                 )
#               );;
#   interval_trigger: "5 hours"
# }


explore: facts_prod_dim_day {
  label: "dim_day_sme"
  # persist_with: internal_availability_datagroup_sme
  sql_always_where: ${facts_prod_fact_analytics_for_master_calendar.labelid} != 32551 AND ${facts_prod_fact_analytics_for_master_calendar.feedid} NOT IN (8)
    ;;
  case_sensitive: no
  symmetric_aggregates: no
  hidden: yes

  join: facts_prod_fact_analytics_for_master_calendar {
    view_label: "fact_analytics"
    sql_on: ${facts_prod_dim_day.dayid} = ${facts_prod_fact_analytics_for_master_calendar.dayid} ;;
    type: left_outer
    relationship: one_to_many
  }

  join: facts_prod_dim_licensor {
    view_label: "dim_licensor"
    sql_on: ${facts_prod_dim_licensor.licensorid} = ${facts_prod_fact_analytics_for_master_calendar.licensorid} ;;
    type: left_outer
    relationship: one_to_many
  }
}