view: facts_prod_deezer_v3_fraud {
  sql_table_name: FACTS.PROD.STAGING_RAW_DEEZER_V3_FRAUD_REPORT;;

  dimension: row_id {
    type: number
    sql: ${TABLE}.ROW_ID ;;
  }

  dimension_group: ingestion_time {
    type: time
    timeframes: [raw, date, week, month, year]
    sql: ${TABLE}.INGESTION_TIME ;;
  }

  dimension: download_date {
    type: date
    sql: ${TABLE}.DOWNLOAD_DATE ;;
  }

  dimension: filename {
    type: string
    sql: ${TABLE}.FILENAME ;;
  }

  dimension: song_id {
    type: number
    sql: ${TABLE}.SONG_ID ;;
  }

  dimension: song_title {
    type: string
    sql: ${TABLE}.SONG_TITLE ;;
  }

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

  dimension: album_title {
    type: string
    sql: ${TABLE}.ALBUM_TITLE ;;
  }

  dimension: album_upc {
    type: string
    sql: ${TABLE}.ALBUM_UPC ;;
  }

  dimension: artist_name {
    type: string
    sql: ${TABLE}.ARTIST_NAME ;;
  }

  dimension: label_name {
    type: string
    sql: ${TABLE}.LABEL_NAME ;;
  }

  dimension: country {
    type: string
    sql: ${TABLE}.COUNTRY ;;
  }

  measure: nb_streams {
    type: sum
    sql: ${TABLE}.NB_STREAMS ;;
    value_format_name: decimal_0
  }

  measure: nb_distinct_users {
    type: sum
    sql: ${TABLE}.NB_DISTINCT_USERS ;;
    value_format_name: decimal_0
  }

  dimension: licensor {
    type: string
    sql: ${TABLE}.LICENSOR ;;
  }
}