view: facts_prod_dim_release {
  sql_table_name: facts.prod.dim_release ;;
  suggestions: no

  dimension: upc {
    label: "UPC"
    type: string
    sql: ${TABLE}.releaseid ;;
    primary_key: yes
    description: "Unique alphanumeric code assigned to each release"
  }

  dimension: release_name {
    type: string
    sql: ${TABLE}.releasename ;;
    description: "Name of the release as stored in our metadata"
  }

  dimension: project_id {
    type: number
    sql: ${TABLE}.projectid ;;
    description: "Unique idenfier for the project the release was a part of"
  }

  dimension: label_id {
    view_label: "Label"
    type: number
    sql: ${TABLE}.labelid ;;
    description: "Unique ID for the label associated with the release"
  }

  dimension: product_id {
    label: "Release ID"
    type: number
    sql: ${TABLE}.product_id ;;
    hidden: yes
  }

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

  dimension: product_type {
    type: string
    sql: ${TABLE}.product_type ;;
    hidden: yes
    description: "Tells whether the product is digital or physical"
  }

  dimension: release_date {
    type: date
    sql: ${TABLE}.releasedate ;;
    hidden: yes
    description: "Original Release Date for a release"
  }

  dimension: artistid {
    type: number
    sql: ${TABLE}.artistid ;;
    hidden: yes
    description: "Unique ID of the artist associated with the release"
  }

  dimension: artist_id {
    type: number
    sql: ${TABLE}.artistid ;;
    description: "Unique ID of the artist associated with the release"
  }


  dimension: subaccountid {
    type: number
    sql: ${TABLE}.subaccountid ;;
    hidden: yes
    description: "Subaccount ID for a label"
  }

  dimension: compilation {
    type: string
    sql: ${TABLE}.compilation ;;
    hidden: no
    description: "Indicates if a release is a compilation(Y/N)"
  }

  dimension: genre_id {
    type: number
    sql: ${TABLE}.genreid ;;
    hidden: yes
    description: "Unique ID assigned to each genre type"
  }

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

  dimension: not_for_distribution {
    type: string
    sql: ${TABLE}.not_for_distribution ;;
    hidden: yes
  }

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

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