view: dt_master_rights_audit{
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_MASTER_RIGHTS_AUDIT ;;

#     sql:
#     SELECT *
# FROM facts.prod.registry_audit
# WHERE opcode NOT IN('ADD')
# AND tuid IS NOT NULL;;
#   }

  dimension: ISRC {
    view_label: "Track"
    type: string
    sql: ${TABLE}.isrc ;;
    hidden: yes

  }

  dimension: tuid {
    view_label: "Track"
    type: string
    sql: ${TABLE}.tuid ;;
    hidden:  yes
  }

  dimension: territory {
    view_label: "Track"
    type: string
    sql: ${TABLE}.territory
      ;;
  }

  dimension_group: audit_activity {
    view_label: "Date"
    type: time
    sql: ${TABLE}.timestamp ;;
    timeframes: [
      date,
      day_of_week,
      day_of_week_index,
      day_of_month,
      week,
      week_of_year,
      month,
      month_name,
      month_num,
      quarter,
      quarter_of_year,
      year
    ]
  }
}