Querying HealthLake data with Amazon Athena

During a HealthLake import job, nested FHIR JSON data undergoes an ETL process and is stored in Apache Iceberg open table format, where each FHIR resource type is represented as an individual table in Athena. This enables users to query the FHIR data using SQL, but without having to export it first. This is valuable, as it empowers clinicians and scientists to query FHIR data to validate their decisions or advance their research. For more information about how Apache Iceberg tables function in Athena, see Query Apache Iceberg tables in the Athena User Guide.

The topics in this section describe how to connect your HealthLake data store to Athena, how to query it using SQL, and how to connect results with other AWS services for further analysis.