view: fact_prod_label_participant_participated_in_orchard_product {
  sql_table_name: FACTS.PROD.LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_PRODUCT ;;

  dimension: label_participant_id {
    type: number
    primary_key: yes
    sql: ${TABLE}.LABEL_PARTICIPANT_ID ;;
  }

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

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

  dimension: created_at {
    type: date_time
    sql: ${TABLE}.CREATED_AT ;;
    hidden: yes
  }

  dimension: last_modified_at {
    type: date_time
    sql: ${TABLE}.LAST_MODIFIED_AT ;;
    hidden: yes
  }

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

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

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

}