view: facts_prod_staging_raw_shazam {
  sql_table_name: facts.prod.staging_raw_shazam ;;

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

  dimension: artist_name {
    type: string
    sql: ${TABLE}.artist_name ;;
    view_label: "Artist"
  }

  dimension: country_code {
    type: string
    sql: ${TABLE}.country ;;
    view_label: "Event Location"
  }

  dimension: download_date {
    type: date_time
    sql: ${TABLE}.download_date ;;
    hidden: yes
  }

  dimension_group: event {
    type: time
    sql: ${TABLE}.timestamp ;;
    view_label: "Event"
  }

  dimension: event_id {
    type: number
    sql: ${TABLE}.event_id ;;
    view_label: "Event"
  }

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

  dimension: isrc_name {
    type: string
    sql: ${TABLE}.isrc_name ;;
    view_label: "Track"
    label: "Track Name"
  }

  dimension: lat {
    type: number
    sql: TRUNC(${TABLE}.lat,1) ;;
    view_label: "Event Location"
    label: "Latitude"
  }

  dimension: lng {
    type: number
    sql: TRUNC(${TABLE}.lng,1) ;;
    view_label: "Event Location"
    label: "Longitude"
  }

  dimension: processed_datetime {
    type: date_time
    sql: ${TABLE}.processed_datetime ;;
    hidden: yes
  }

  measure: count_event {
    type: count_distinct
    sql: ${TABLE}.event_id ;;
    view_label: "Event"
    label: "Number of Events"
  }
}