The heavily nested nature of FHIR resources and the Parque-on-FHIR schema requires complex SQL queries that can make them difficult to work with for analytics use cases.
A common approach to address this is to flatten the data into a set of views (virtual or materialized) which can then be queried using simpler SQL statements.
Using FHIR Data Pipes, there are multiple approaches for generating flat tabular views for use in analytics applications to match the deployment requirements:
SQL queries to generate virtual views (outside the pipeline)
FHIR ViewDefinition resources to generate materialized views (within the pipeline) which can be outputted in any tabular format (with current support for Parquet and DB tables)
For both of these approaches, a set of "predefined views" for common FHIR resources are provided. These can be modified or extended.
Go to developer documentation