Stream: analytics on FHIR
Topic: FHIR SQL Mappings
Praveen Shivaprasad (Jun 02 2020 at 07:30):
Can anybody direct me to a tool (preferably open source tool) that can convert FHIR resources to a relational data model either columnar storage or pure-relational for querying purposes and possibly for analytical workloads
Peter Jordan (Jun 02 2020 at 08:54):
https://github.com/FHIR/sql-on-fhir
John Grimes (Jun 02 2020 at 09:57):
https://pathling.csiro.au
FHIR (R4) in, Parquet out
Paul S (Jun 03 2020 at 22:27):
You have to do it yourself. I asked a year ago and there was nothing out there. We created our own mapping with SQL.
Ryan Brush (Jun 07 2020 at 16:43):
Here's an example that loads FHIR data into BigQuery https://github.com/google/fhir/tree/master/examples/bigquery.
Also, if Apache Spark is your thing, there is a library that encodes FHIR data as Spark data frames: https://engineering.cerner.com/bunsen
Eric Whitley (Jun 08 2020 at 14:00):
Paul S said:
You have to do it yourself. I asked a year ago and there was nothing out there. We created our own mapping with SQL.
Would you be willing to discuss your approach and insights with this? I'd love to know more about your experiences.
Praveen Shivaprasad (Jul 06 2020 at 06:53):
Thanks Eric for the messages. Yes I would be interested in looking at it
Last updated: Apr 12 2022 at 19:14 UTC
