Automate your healthcare workflows with Google BigQuery integrations and Morf. BigQuery is a cloud-based data warehouse for analyzing and querying large datasets. Save event data from a Morf workflow to a BigQuery table.

​
Getting started

​
Grant Morf access to BigQuery

  1. Create a new dataset. This recommended approach to dataset management ensures Morf only has access to the necessary tables. Follow Google’s instructions on creating a new dataset.
  2. Share your dataset with Morf. Follow Google’s instructions on granting access to a dataset.
    • Role: BigQuery Data Editor (roles/bigquery.dataEditor)
    • Email: primary-workload-sa@morf-prod-5f7d.iam.gserviceaccount.com

⚠️ This role should be granted at the dataset level so Morf doesn’t have unneccessary access to other data.

​
Send data to BigQuery from your workflow

Use Morf’s Send Data to BigQuery action to store event data directly in BigQuery from a workflow.

Input

  • Project ID: Top level entry found in Explorer panel of BigQuery.
  • Dataset ID: Found within project in Explorer panel of BigQuery.
  • Table Name: (optional) If not specified, Morf will use the event type as a table name. Note that using this feature may lead to multiple tables created by a single workflow (e.g. healthie_patient_created, healthie_patient_updated ).
  • Fields: (optional) If not specified, Morf will save all fields from the event payload to BigQuery.

Output

  • Table name
  • Table schema
  • Partition: Date partition where the data was written
  • Estimated row count
  • Schema differences: Differences found between the inserted data and the existing schema