view: int_dbt_prod_agg_daily_beatport_download_model {
  sql_table_name: intelligence.dbt_prod.agg_daily_beatport_download_model ;;

  dimension_group: download_activity_date {
    view_label: "Date"
    label: "Activity"
    type: time
    description: "Date of consumption"
    sql: ${TABLE}.download_activity_date ;;
    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: label_id {
    type: number
    view_label: "Label"
    label: "Label ID"
    sql: ${TABLE}.label_id ;;
    description: "Label ID"
  }

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

  dimension: release_id {
    type: number
    view_label: "Release"
    label: "UPC"
    sql: ${TABLE}.release_id ;;
    description: "Unique Product Code"
  }

  dimension: track_id {
    type: number
    view_label: "Track"
    label: "Track ID"
    sql: ${TABLE}.track_id ;;
    description: "Unique track identifier"
  }


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

  dimension: imprint_id {
    view_label: "Release"
    label: "Imprint ID"
    type: number
    sql: ${TABLE}.imprint_id ;;
    description: "Imprint ID associated with the release"
  }

  dimension: subaccount_id {
    view_label: "Subaccount"
    label: "Subaccount ID"
    type: number
    sql: ${TABLE}.subaccount_id ;;
    description: "Subaccount ID associated with the release"
  }

  dimension: label_name {
    view_label: "Label"
    label: "Label Name"
    type: string
    sql: ${TABLE}.label_name ;;
    description: "Label Name associated with the release"
  }

  dimension: transaction_country_name {
    view_label: "Transaction Country"
    label: "Country name"
    type: string
    sql: ${TABLE}.transaction_country_name ;;
    description: "Name of country of consumption"
  }

  dimension: transaction_continent {
    view_label: "Transaction Country"
    label: "Continent"
    type: string
    sql: ${TABLE}.transaction_continent ;;
    description: "Name of continent of consumption"
  }

  dimension: format {
    view_label: "Release"
    label: "Format"
    type: string
    sql: ${TABLE}.format ;;
    description: "Release Format (EP/ Album/ Single)"
  }

  dimension: is_active {
    view_label: "Release"
    type: yesno
    label: "Is Active"
    description: "Whether the release is active or not"
    sql: ${TABLE}.is_active=TRUE;;
  }

  dimension: imprint_name {
    view_label: "Release"
    type: string
    label: "Imprint Name"
    description: "Name of release imprint"
    sql: ${TABLE}.imprint_name;;
  }

  dimension: release_name {
    view_label: "Release"
    type: string
    label: "Release Name"
    description: "Name of the release"
    sql: ${TABLE}.release_name;;
  }

  dimension_group: release_date {
    view_label: "Date"
    label: "Release"
    type: time
    description: "Date of original release"
    sql: ${TABLE}.release_date ;;
    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: sale_start_date {
    view_label: "Date"
    label: "Sale Start"
    type: time
    description: "Date when The Orchard starting distributing the release"
    sql: ${TABLE}.sale_start_date ;;
    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: pre_order_date {
    view_label: "Date"
    label: "Pre Order"
    type: time
    hidden: yes
    sql: ${TABLE}.sale_start_date ;;
    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: vendor_catalog_number {
    view_label: "Release"
    type: string
    label: "Catalog Number"
    description: "Unique identifier for each release in system"
    sql: ${TABLE}.vendor_catalog_number;;
  }

  dimension: version {
    view_label: "Release"
    type: string
    label: "Version"
    description: "Release Version (Remix, LoFi etc)"
    sql: ${TABLE}.version;;
  }

  dimension: track_unique_id {
    type: number
    view_label: "Track"
    label: "Track Unique ID"
    description: "Unique id for each track"
    sql: ${TABLE}.track_unique_id ;;
  }

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

  dimension: duration {
    type: number
    view_label: "Track"
    label: "Duration"
    description: "Length of track"
    sql: ${TABLE}.duration ;;
  }

  dimension: artist_name {
    type: string
    view_label: "Artist"
    label: "Artist Name"
    description: "Primary artist associated with the release"
    sql: ${TABLE}.artist_name ;;
  }

  dimension: genre {
    type: string
    view_label: "Release"
    label: "Genre"
    description: "Genre of the release"
    sql: ${TABLE}.genre ;;
  }

  dimension: label_country_name {
    type: string
    view_label: "Label"
    label: "Label Country"
    description: "Country of the label associated with the release"
    sql: ${TABLE}.label_country_name ;;
  }

  dimension: parent_company {
    view_label: "Orchard/ AWAL Tiers"
    label: "Parent Company"
    type: string
    full_suggestions: no
    sql: ${TABLE}.parent_company ;;
    description: "Parent Company of the Brand that the label belongs to. (SME or Orchard)"
  }

  dimension: brand_name {
    type: string
    view_label: "Orchard/ AWAL Tiers"
    label: "Brand Name"
    full_suggestions: no
    sql: ${TABLE}.brand_name ;;
    description: "Name of the company to which the label belongs. Can be awal, orchard, sme"
  }

  dimension: service_tier_name {
    type: string
    view_label: "Orchard/ AWAL Tiers"
    label: "Service Tier Name"
    full_suggestions: no
    sql: ${TABLE}.service_tier_name ;;
    description: "Client tier the label falls into as per the awal tiers. (Values are null for Orchard brands)"
  }

  dimension: owner {
    type: string
    view_label: "Orchard/ AWAL Tiers"
    label: "Owner"
    full_suggestions: no
    sql: ${TABLE}.owner ;;
    description: "Label Owner (AWAL-UK, AWAL_Core etc)"
  }

  dimension: subaccount_name {
    type: string
    label: "Subaccount Name"
    view_label: "Subaccount"
    full_suggestions: no
    sql: ${TABLE}.subaccount_name ;;
    description: "Subaccount Name"
  }

  dimension: transaction_detail {
    type: string
    view_label: "Transaction Type"
    label: "Transaction Description"
    full_suggestions: no
    sql: ${TABLE}.transaction_detail ;;
    description: "Detail of transaction type"
  }

  dimension: label_manager {
    type: string
    view_label: "Label"
    label: "Label Manger"
    full_suggestions: no
    sql: ${TABLE}.label_manager ;;
    description: "Label Manger"
  }

  measure: downloads {
    type: sum
    view_label: "Consumption"
    label: "Downloads"
    sql: ${TABLE}.downloads ;;
    description: "Total downloads"
  }


  }