view: int_awal_historical_datasets_temp_awal_itunes_downloads {
  sql_table_name: AWAL.AWAL_FINANCE.AWAL_ITUNES_DOWNLOADS ;;


  dimension: SERVICE {
    type: string
    sql: ${TABLE}.SERVICE ;;
  }

  dimension: CLIENT_ID {
    type: string
    sql: ${TABLE}.CLIENT_ID ;;
  }

  dimension: CLIENT_NAME {
    type: string
    sql: ${TABLE}.CLIENT_NAME ;;
  }

  dimension: AWAL_SEGMENT {
    type: string
    sql: ${TABLE}.AWAL_SEGMENT ;;
  }

  dimension: PRIMARY_ARTIST_ID {
    type: string
    sql: ${TABLE}.PRIMARY_ARTIST_ID ;;
  }

  dimension: ARTIST {
    type: string
    sql: ${TABLE}.ARTIST ;;
  }

  dimension: TITLE {
    type: string
    sql: ${TABLE}.TITLE ;;
  }

  dimension: ORIGINAL_RELEASE_DATE {
    type: date
    sql: ${TABLE}.ORIGINAL_RELEASE_DATE ;;
  }#date

  dimension: EXPLOITATION_ID {
    type: string
    sql: ${TABLE}.EXPLOITATION_ID ;;
  }

  dimension: EXPLOITATION_TITLE {
    type: string
    sql: ${TABLE}.EXPLOITATION_TITLE ;;
  }

  dimension: ISRC {
    type: string
    sql: ${TABLE}.ISRC ;;
  }#check Type

  dimension: TERRITORY_CODE {
    type: string
    sql: ${TABLE}.TERRITORY_CODE ;;
  }

  dimension: TERRITORY {
    type: string
    sql: ${TABLE}.TERRITORY ;;
  }

  dimension: DAY {
    type: date
    sql: ${TABLE}.DAY ;;
  }#date

  dimension: PRODUCT_TYPE {
    type: string
    sql: ${TABLE}.PRODUCT_TYPE ;;
  }

  measure: SUM_OF_SALES {
    type: sum
    sql: ${TABLE}.SUM_OF_SALES ;;
  }
}