FlatQuack is a new, open source, View Definition ELT runner that targets DuckDB, a lightweight, high performance database engine. By compiling to SQL, FlatQuack can be easily integrated into existing data pipelines that use off-the-shelf orchestration tools like DBT and Apache Airflow.
FlatQuack is an innovative, open-source SQL on FHIR view definition compiler designed for DuckDB, a compact and efficient database engine. DuckDB can operate as a standalone executable that scans a local directory of FHIR resources or as a distributed system accessing billions of cloud-based resources. By converting to SQL, FlatQuack seamlessly fits into established data workflows utilizing popular orchestration tools such as DBT and Apache Airflow.
FlatQuack is a new, open source, SQL on FHIR View Definition to SQL compiler that targets DuckDB, a lightweight, high performance database engine. DuckDB can scale from running as a single executable that queries a directory of FHIR resources on a local machine to a distributed platform that queries across billions of resources in the cloud. By compiling to SQL, FlatQuack can be easily integrated into existing data pipelines that use off-the-shelf orchestration tools like DBT and Apache Airflow.
Dan Gottlieb is a clinical informaticist and software consultant with experience leading the design and development of healthcare apps and population health analytic tools for commercial and non-profit organizations. He serves as the senior technical advisor to the SMART on FHIR Project and a subject matter expert for the Argonaut FHIR Accelerator, and is the co-creator and maintainer of the FHIR population data API standard (“FHIR Bulk Data”) which has been deployed by organizations including CMS, Epic, Cerner, Microsoft and Google.
Aidbox is a developer-friendly FHIR platform where everything remains under your control. Build your enterprise-grade digital healthcare apps and systems using a habitual tech stack and suitable cloud infrastructure: Google, Azure, AWS, or on-premises.
// Read More
