Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Need Help on Load FHIR data into BigQuery

Hello everyone,

I am seeking assistance in finding the best serverless solution for automatically loading FHIR data from cloud storage into BigQuery. I initially attempted to solve this using Dataflow, but I discovered that Apache Beam has deprecated the healthcare feature. Therefore, if anyone has a better solution, please let me know. Your input would be greatly appreciated. Thank you.

0 1 247
1 REPLY 1

Hi @Abdul92,

Welcome to the Google Cloud Community!

You should look into Exporting FHIR resources to BigQuery. It explains how to export to BigQuery for exploration and analysis. You must first have to set BigQuery permissions, then you can export FHIR resources.

 If the above option doesn't help, you can also look into Batch Loading Data

You can load data into BigQuery from Cloud Storage or from a local file as a batch operation. FHIR is a healthcare data that includes data representation that uses JSON, XML, and RDF. 

In batch loading data, the source data from cloud storage can be a JSON file. Read the above documentation to learn more. You can also get in touch with Google Cloud Support if the above options don't work.

Let me know if it helped, thanks!