
view: max_date {
  derived_table: {
    sql: SELECT max_partition_date AS max_date_minus_2
         FROM `concord-test.stagingservice_gcc.gcc_revenue_latest_partition_view`
         GROUP BY 1;;
  }
########## PRIMARY KEYS ############
  dimension: pk {
    description: "Primary key.  This table should only ever have one row, so any dimension should be the primary key."
    hidden: yes
    primary_key: yes
    sql: ${max_date_minus_2_raw} ;;
  }
########## DIMENSIONS ############
  dimension_group: max_date_minus_2 {
    description: "Calculates the latest date in the Revenue table and subtracts 2 days"
    hidden: yes
    type: time
    datatype: date
    timeframes: [raw, date, day_of_month, day_of_year, month, month_name, week]
    sql: CAST(${TABLE}.max_date_minus_2 AS DATE) ;;
    convert_tz: no
  }
  dimension: max_date_minus_2_day_of_quarter {
    hidden: yes
    description: "Day of quarter"
    type: number
    sql: DATE_DIFF(${max_date_minus_2_raw}, DATE_TRUNC(${max_date_minus_2_raw}, QUARTER), DAY) ;;
  }
}