view: dt_max_accountingperiodid {
  derived_table: {
    sql: SELECT MAX(accountingperiodid) AS max_accountingperiodid FROM royalty_accounting.prod.workstation_fact_sales_unified_dbt ;;
  }

  ## Not replaced by DT cause table is null

  dimension: max_accountingperiodid {
    type: number
    sql: ${TABLE}.max_accountingperiodid ;;
    hidden: yes
  }
}