view: dt_release_status {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_RELEASE_STATUS ;;
#   derived_table: {
#     sql: select release_id, min(date) as date
# from ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.RELEASE_STATUS
# where status = 'in_content'
# group by 1;;
#   }

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

  dimension: date {
    label: "Release In Content Date"
    type: date
    description: "Date a release first changed status to 'in_conent'"
    sql: ${TABLE}.date ;;
  }

}