view: orch_app_sales_goals_sales_goal {
  sql_table_name: orchard_app_reporting_v2.prod_sales_goals_sales_goals.sales_goal ;;

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

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

  # measure: first_week_estimate {
  #   type: sum
  #   sql: ${TABLE}.first_week_estimate ;;
  # }

  dimension: hmv_notes {
    label: "HMV Notes"
    type: string
    sql: ${TABLE}.hmv_notes ;;
  }

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

#   dimension: updated_at {
#     type: date_time
#     sql: ${TABLE}.updated_at ;;
#   }
#
#   dimension: updated_by {
#     type: string
#     sql: ${TABLE}.updated_by ;;
#   }
}