How to Query the FHIR Data Model in Microsoft Fabric: SQL and Key Harmonization
Microsoft Fabric healthcare data model querying and identifier harmonization Microsoft
Microsoft demonstrated the capability to query and harmonize healthcare data using its Native FHIR data model.
Summary
This article explains how to query data based on the silver layer of Healthcare Data Solutions (HDS) within Microsoft Fabric, which is built upon the FHIR R4 standard. It demonstrates querying techniques using both Spark SQL and T-SQL, emphasizing that key harmonization provides a simpler and more consistent query experience.
Key Players
Details
The healthcare data model in Microsoft Fabric's Healthcare Data Solutions (HDS) resides in the silver layer and is based on the FHIR R4 standard, serving as a core foundation for handling medical data. Native FHIR format can be challenging to query using SQL due to complex reference properties. This article addresses this by utilizing a harmonized data model that simplifies querying through key harmonization. Technically, FHIR references often involve complex structures, including business identifiers alongside standard IDs. HDS performs harmonization on resource-level FHIR IDs and references by hashing them, making SQL queries much easier. This eliminates the need to parse raw reference formats like “Patient/<id>”. Furthermore, for T-SQL environments, complex columns (struct, list, map) are given a `_string` suffix, allowing querying via JSON functions. The guide provides flexibility by supporting both Spark SQL and T-SQL, offering concrete methods for utilizing FHIR standard data in a practical manner.
Technology Note
FHIR（Fast Healthcare Interoperability Resources）は医療データ交換の国際標準。このエントリの関連技術: FHIR
Original content copyright by respective publishers