Ingestion and Processing of HL7 V2.x messages using Snowflake Demo's

Why this Demo

Problem Statement

With the support for unstructured data in Snowflake, customers no longer need to run a processing pipeline of HL7 V2.x outside Snowflake. Now customers can directly store the HL7 V2.x messages in Snowflake, process them using Java UDFs/UDTFs, Python UDFs/UDTFs and run analytics on the fly.

Technical Overview of HL7 Ingestion and Processing using Snowflake

Medium Blog

Processing of HL7 V2.x messages

Prototype implementations for parsing HL7 V2.x messages.

---

Implementations

Type	Implementation Class
Java UDTF	HL7UDTF
Java UDF	HL7UDF
Python UDF	hl7pyparserUDF

Detailed documentation/Quickstart guide

Quickstart

Note

The implementations provided here are at best MVP/Prototype versions, they are not of production quality. You are free to extend the functionality and improve the code as it fits your functionality.

Reference

• HL7 sample file hl7_2-3_samples.txt was sourced from simhospital.