view: dms_genre_mapping_snowflake {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.dms_genre_mapping ;;

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  dimension: dms_genre_mapping_id {
    type: number
    sql: ${TABLE}.DMS_GENRE_MAPPING_ID ;;
  }

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

  dimension: _metadata__uuid {
    type: string
    hidden: yes
    sql: ${TABLE}._METADATA__UUID ;;
  }

  dimension: _metadata_database {
    type: string
    hidden: yes
    sql: ${TABLE}._METADATA_DATABASE ;;
  }

  dimension: _metadata_deleted {
    type: string
    hidden: yes
    sql: ${TABLE}._METADATA_DELETED ;;
  }

  dimension: _metadata__timestamp {
    type: string
    hidden: yes
    sql: ${TABLE}._METADATA__TIMESTAMP ;;
  }

  dimension: _metadata_log_file {
    type: string
    hidden: yes
    sql: ${TABLE}._METADATA_LOG_FILE ;;
  }

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

  dimension: _metadata_timestamp {
    type: string
    hidden: yes
    sql: ${TABLE}._METADATA_TIMESTAMP ;;
  }

  dimension: dms_master_genre_id {
    type: number
    sql: ${TABLE}.DMS_MASTER_GENRE_ID ;;
  }

  dimension: orchard_subgenre_id {
    type: number
    sql: ${TABLE}.ORCHARD_SUBGENRE_ID ;;
  }

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

  set: detail {
    fields: [
      dms_genre_mapping_id,
      _metadata_snapshot_id,
      _metadata__uuid,
      _metadata_database,
      _metadata_deleted,
      _metadata__timestamp,
      _metadata_log_file,
      _metadata_log_position,
      _metadata_timestamp,
      dms_master_genre_id,
      orchard_subgenre_id,
      _metadata_snapshot_size
    ]
  }
}