view: orch_app_ar_bulk_session {
 sql_table_name: ORCHARD_APP_REPORTING_V2.PROD_OWS_PRODUCT_STAGING_OWS_PRODUCT_STAGING.BULK_SESSIONS ;;

  dimension: bulk_session_id {
    primary_key: yes
    type: string
    sql: ${TABLE}.BULK_SESSION_ID ;;
  }

  dimension: vendor_uuid {
    type: string
    sql: ${TABLE}.VENDOR_UUID ;;
  }

  dimension: metadata_status {
    type: string
    sql: ${TABLE}.METADATA_STATUS ;;
  }

  dimension: asset_status {
    type: string
    sql: ${TABLE}.ASSET_STATUS ;;
  }

  dimension: metadata_error_report_json {
    type: string
    sql: ${TABLE}.METADATA_ERROR_REPORT_JSON ;;
  }

  dimension: asset_error_report {
    type: string
    sql: ${TABLE}.ASSET_ERROR_REPORT ;;
  }

  dimension: asset_report_json {
    type: string
    sql: ${TABLE}.ASSET_REPORT_JSON ;;
  }

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

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

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

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

  dimension: is_cancelled {
    type: yesno
    sql: ${TABLE}.IS_CANCELLED ;;
  }

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

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

}