view: int_dbt_prod_kemado_streams_last_18_months_releases {
  sql_table_name: intelligence.dbt_prod.kemado_streams_last_18_months_releases ;;

  dimension: primary_key {
    primary_key: yes
    hidden: yes
    sql: CONCAT(${TABLE}.orch_app_ar_artist_name, ${TABLE}.isrc,
    ${TABLE}.labelid, ${TABLE}.sale_start_date,
    ${TABLE}.store_name, ${TABLE}.track_name,
    ${TABLE}.transactiontype_description, ${TABLE}.units) ;;
  }

  dimension_group: sale_start_date {
    view_label: "Release"
    label: "Sale Start"
    type: time
    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: artist_name {
    view_label: "Artist"
    label: "Artist Name"
    type: string
    sql: ${TABLE}.orch_app_ar_artist_name ;;
  }

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

  dimension: labelid {
    type: number
    view_label: "Label"
    label: "Label ID"
    sql: ${TABLE}.labelid ;;
    value_format: "0"
  }

  dimension: store_name {
    type: string
    view_label: "Store"
    label: "Store Name"
    sql: ${TABLE}.store_name ;;
  }

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

  dimension: transactiontype_description {
    type: string
    view_label: "Transaction"
    label: "Transaction Type Description"
    sql: ${TABLE}.transactiontype_description ;;
  }

  measure: units {
    type: sum
    view_label: "Units"
    label: "Units"
    sql: ${TABLE}.units ;;
  }



  }