view: dim_isrc {
  sql_table_name: facts.prod.DIM_ISRC ;;

  dimension: cd {
    sql: ${TABLE}.CD ;;
  }

  dimension: date_created {
    sql: ${TABLE}.DATE_CREATED ;;
  }

  dimension: isrc {
    sql: ${TABLE}.ISRC ;;
  }

  dimension: isrcid {
    sql: ${TABLE}.ISRCID ;;
  }

  dimension: isrcname {
    sql: ${TABLE}.ISRCNAME ;;
  }

  dimension: labelid {
    sql: ${TABLE}.LABELID ;;
  }

  dimension: last_updated {
    sql: ${TABLE}.LAST_UPDATED ;;
  }

  dimension: source {
    sql: ${TABLE}.SOURCE ;;
  }

  dimension: track_id {
    # hidden: true
    sql: ${TABLE}.TRACK_ID ;;
  }

  dimension: track_id_uniq {
    sql: ${TABLE}.TRACK_ID_UNIQ ;;
  }

  dimension: upc {
    sql: ${TABLE}.UPC ;;
  }

  dimension: vendor_catalog_number {
    sql: ${TABLE}.VENDOR_CATALOG_NUMBER ;;
  }

  measure: rows {
    type: count
    drill_fields: [isrcname, accounting.count]
  }
}