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

  dimension: upc {
    label: "UPC"
    type: string
    sql: ${TABLE}.releaseid ;;
    primary_key: yes
  }

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

  dimension: project_id {
    type: number
    sql: ${TABLE}.projectid ;;
  }

  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: release_date {
    type: date
    sql: ${TABLE}.releasedate ;;
    hidden: yes
  }
  dimension: artist_id {
    type: number
    sql: ${TABLE}.artistid ;;
    description: "Unique ID of the artist associated with the release"
  }
  dimension: label_id {
    view_label: "Label"
    type: number
    sql: ${TABLE}.labelid ;;
    description: "Unique ID for the label associated with the release"
  }
}