view: int_dbt_prod_saaregama_revenue_data {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."SAAREGAMA_REVENUE_DATA" ;;

  dimension: accounting_month {
    type: date
    sql: ${TABLE}.ACCOUNTING_MONTH ;;
    label: "Dataset Date"
  }

  dimension: transaction_country_code {
    type: string
    sql: ${TABLE}.TRANSACTION_COUNTRY_CODE ;;
  }

  dimension: transaction_country_name {
    type: string
    sql: ${TABLE}.TRANSACTION_COUNTRY_NAME ;;
  }

  dimension: transaction_description {
    type: string
    sql: ${TABLE}.TRANSACTION_DESCRIPTION ;;
  }

  dimension: premium_free {
    type: string
    sql: ${TABLE}.PREMIUM_FREE ;;
    label: "Premium/ Free"
  }

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

  dimension: trackname {
    type: string
    sql: ${TABLE}.TRACKNAME ;;
    label: "Track Name"
  }

  dimension: upc {
    type: number
    sql: ${TABLE}.UPC ;;
  }

  dimension: release_name {
    type: string
    sql: ${TABLE}.RELEASE_NAME ;;
  }

  dimension: artistname {
    type: string
    sql: ${TABLE}.ARTISTNAME ;;
    label: "Artist Name"
  }

  dimension: storename {
    type: string
    sql: ${TABLE}.STORENAME ;;
    label: "Store Name"
  }

  dimension: format {
    type: string
    sql: ${TABLE}.FORMAT ;;
  }

  dimension: payout_currency {
    type: string
    sql: ${TABLE}.PAYOUT_CURRENCY ;;
  }

  measure: units {
    type: sum
    sql: ${TABLE}.UNITS ;;
    value_format_name: decimal_0
  }

  measure: net_revenue_usd {
    type: sum
    sql: ${TABLE}.NET_REVENUE_USD ;;
    value_format_name: usd
  }

  measure: net_revenue_payout_currency {
    type: sum
    sql: ${TABLE}.NET_REVENUE_PAYOUT_CURRENCY ;;
    value_format_name: decimal_2
  }
}