Skip to content

Instantly share code, notes, and snippets.

@ludflu
Last active January 22, 2022 19:07
Show Gist options
  • Save ludflu/96cad4f277e034e1f384befcdff1cbf7 to your computer and use it in GitHub Desktop.
Save ludflu/96cad4f277e034e1f384befcdff1cbf7 to your computer and use it in GitHub Desktop.
demo load checklist
  • alerts_by_actions
  • alerts_by_all
  • alerts_by_date
  • alerts_by_departments
  • alerts_by_employees
  • alerts_by_encounter
  • alerts_by_lgl
  • alerts_by_provider_types
  • alerts_by_triggers
  • alerts_with_dis
  • dea_class
  • departments
  • employees
  • encounter_alerts (empty)
  • encounter_medications (empty)
  • encounter_procedures (empty)
  • flo
  • flowsheets_by_all
  • fyi
  • fyi_counts
  • grouper
  • grouper_member
  • importance
  • main_orderable_groups. ERROR. diagnostics: User class threw exception: org.apache.spark.sql.AnalysisException: Column "is_released" not found in schema Some(StructType(StructField(id,DecimalType(38,18),true), StructField(name,StringType,true), StructField(version,StringType,true), StructField(status,StringType,true), StructField(record_status,StringType,true), StructField(type,StringType,true), StructField(override_status,StringType,true), StructField(metadata_list,StringType,true), StructField(textsearchable_index_col,StringType,true)))
  • main_orderable_groups_history
  • master_alert_burden
  • master_alerts
  • master_dis
  • master_emi
  • master_emi_preview
  • master_etx
  • master_etx_preview
  • master_flo
  • master_flt
  • master_hcm_ot
  • master_lgl
  • master_lgl_preview
  • master_mar
  • master_med
  • master_osq_block
  • master_osq_description
  • master_osq_ot
  • master_osq_web
  • master_otl
  • master_otl_admin_instructions
  • master_otl_assoc_dx
  • master_otl_ord_comments
  • master_otl_ord_instructions
  • master_prl
  • master_prl_ot
  • master_prl_prl_to_sections
  • master_prl_section_to_sgs
  • master_prl_sg_to_children
  • master_prl_suggested
  • master_ssi
  • master_ssi_preview
  • medication_orders
  • medication_orders_by_date
  • medications
  • new_alerts_by_actions_table
  • notes
  • order_class
  • order_events2
  • order_priority
  • order_question
  • order_question_responses
  • order_sources
  • orders_from_orderset
  • ordersets_by_all (FAILED TO LOAD because of HSTORE / not need!?)
  • override_reasons
  • panel_events
  • pharm_class
  • pharm_subclass
  • preference_lists
  • procedure_categories
  • procedure_groups
  • procedure_orders
  • procedure_orders_by_date
  • procedures
  • provider_specialties
  • provider_types
  • providers
  • rule
  • shown_places
  • specialties
  • thera_class
  • triggers
  • visit_reason
  • actions

Tables we KNOW we need to mask / fix

  • employees
  • departments
  • providers
  • rule
  • flow.display_name
  • fyi.name
  • grouper.grouper_name
  • main_orderable_groups.name
  • main_orderable_groups_history.display_name
  • master_alerts
  • master_lgl_preview
  • master_lgl
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment