view: believe {
  sql_table_name: "INTELLIGENCE"."DEV_AWALSPOTIFY"."VW_BELIEVE" ;;

  dimension_group: REPORTING_MONTH{
    label:"REPORTING_MONTH"
    type: time
    sql:${TABLE}.REPORTING_MONTH;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension_group: MONTH_OF_SALE{
    label:"MONTH_OF_SALE"
    type: time
    sql:${TABLE}.MONTH_OF_SALE;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension: PLATFORM{
    label:"PLATFORM"
    type: string
    sql:${TABLE}.PLATFORM;;
  }
  dimension: COUNTRY_REGION{
    label:"COUNTRY_REGION"
    type: string
    sql:${TABLE}.COUNTRY_REGION;;
  }
  dimension: LABEL_NAME{
    label:"LABEL_NAME"
    type: string
    sql:${TABLE}.LABEL_NAME;;
  }
  dimension: ARTIST_NAME{
    label:"ARTIST_NAME"
    type: string
    sql:${TABLE}.ARTIST_NAME;;
  }
  dimension: RELEASE_TITLE{
    label:"RELEASE_TITLE"
    type: string
    sql:${TABLE}.RELEASE_TITLE;;
  }
  dimension: TRACK_TITLE{
    label:"TRACK_TITLE"
    type: string
    sql:${TABLE}.TRACK_TITLE;;
  }
  dimension: UPC{
    label:"UPC"
    type: string
    sql:${TABLE}.UPC;;
  }
  dimension: ISRC{
    label:"ISRC"
    type: string
    sql:${TABLE}.ISRC;;
  }
  dimension: OUTPUT_CATALOG_REFERENCE{
    label:"OUTPUT_CATALOG_REFERENCE"
    type: string
    sql:${TABLE}.OUTPUT_CATALOG_REFERENCE;;
  }
  dimension: TYPE_OF_STREAMING_SUBSCRIPTION{
    label:"TYPE_OF_STREAMING_SUBSCRIPTION"
    type: string
    sql:${TABLE}.TYPE_OF_STREAMING_SUBSCRIPTION;;
  }
  dimension: OUTPUT_TYPE{
    label:"OUTPUT_TYPE"
    type: string
    sql:${TABLE}.OUTPUT_TYPE;;
  }
  dimension: TYPE_OF_SALE{
    label:"TYPE_OF_SALE"
    type: string
    sql:${TABLE}.TYPE_OF_SALE;;
  }
  measure: QUANTITY{
    label:"QUANTITY"
    type: sum
    sql:${TABLE}.QUANTITY;;
  }
  dimension: CUSTOMER_PAYMENT_CURRENCY{
    label:"CUSTOMER_PAYMENT_CURRENCY"
    type: string
    sql:${TABLE}.CUSTOMER_PAYMENT_CURRENCY;;
  }
  dimension: UNKNOWN01{
    label:"UNKNOWN01"
    type: string
    sql:${TABLE}.UNKNOWN01;;
  }
  dimension: UNIT_PRICE{
    label:"UNIT_PRICE"
    type: number
    sql:${TABLE}.UNIT_PRICE;;
  }
  dimension: UNKNOWN02{
    label:"UNKNOWN02"
    type: string
    sql:${TABLE}.UNKNOWN02;;
  }
  dimension: MECHANICAL_PRODUCTION_COST{
    label:"MECHANICAL_PRODUCTION_COST"
    type: number
    sql:${TABLE}.MECHANICAL_PRODUCTION_COST;;
  }
  measure: GROSS_REVENUE{
    label:"GROSS_REVENUE"
    type: sum
    sql:${TABLE}.GROSS_REVENUE;;
  }
  dimension: CUSTOMER_REVENUE_RATE{
    label:"CUSTOMER_REVENUE_RATE"
    type: number
    sql:${TABLE}.CUSTOMER_REVENUE_RATE;;
  }
  measure: NET_REVENUE{
    label:"NET_REVENUE"
    type: sum
    sql:${TABLE}.NET_REVENUE;;
  }
  dimension: ROWCOUNT{
    label:"ROWCOUNT"
    type: number
    sql:${TABLE}.ROWCOUNT;;
  }
  measure: CALC_REVENUE_AMOUNT{
    label:"CALC_REVENUE_AMOUNT"
    type: sum
    sql:${TABLE}.CALC_REVENUE_AMOUNT;;
  }

}