view: orch_app_ar_concierge_product {
 sql_table_name: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.CONCIERGE_PRODUCT ;;

  dimension: concierge_product_id {
    type: number
    primary_key: yes
    sql: ${TABLE}.CONCIERGE_PRODUCT_ID ;;
  }

  measure: count_concierge_product_id {
    label: "Count of Concierge Products"
    type: count_distinct
    sql: case when ${TABLE}.CONCIERGE_VALUE = 'yes' then ${TABLE}.CONCIERGE_PRODUCT_ID else null end;;
  }

  dimension: product_id {
    type: number
    sql: ${TABLE}.PRODUCT_ID ;;
  }

  dimension: updated_by {
    type: number
    sql: ${TABLE}.UPDATED_BY ;;
  }

  dimension_group: last_updated {
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    sql: ${TABLE}.LAST_UPDATED ;;
  }

  dimension: fivetran_deleted {
    type: yesno
    sql: ${TABLE}._FIVETRAN_DELETED ;;
    hidden: yes
  }

  dimension_group: fivetran_synced {
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    sql: ${TABLE}._FIVETRAN_SYNCED ;;
    hidden: yes
  }

  dimension: concierge_value {
    type: string
    sql: ${TABLE}.CONCIERGE_VALUE ;;
  }
}