Skip to main content

Metriport

Overview​

Code on Github

Metriport offers clinical data from the largest health information networks in the country, via a single open-source API.

DataFlow​

Metriport Data Flow

Instructions​

Metriport provides clinical data in the FHIR R4 JSON format.

Step 0: Get FHIR data from Metriport​

First things first, pull FHIR data from Metriport using whatever method you're comfortable.

Step 1: Convert FHIR JSON to NDJSON​

First we need to convert our FHIR json data to NDJSON. We recommend using the command line tool jq to do this - brew install it! Once it's installed, run the following command on the file, e.g. "metriport-fhir.json", in your terminal.

 jq -c '.[]' metriport-fhir.json > output.ndjson

Step 2: Use FHIR Inferno to Flatten JSON​

Next use FHIR Inferno to transform the NDJSON into relational CSV tables and load those CSVs into data tables inside your data warehouse. The Metriport Configs used by FHIR Inferno transforms the JSON specific data tables expected by the Metriport Connector.

Step 3: Set up 'Metriport Connector'​

Now clone the Metriport Connector (i.e. dbt project) to your local machine.

All of the configurations you need to make will be in the dbt_project.yml file:

  • set the input_database var to the name of the database where our raw Metriport data is
  • set the input_schema var to the name of the schema where our raw Metriport data is
  • if you've followed other dbt setup guides and your profile name is anything other than default, you need to change the profile: configuration to match what you've set in your profiles.yml.

You can also use this opportunity to set any normal dbt configurations you want, such as the output database or schema and any custom documentation pages, etc.

Step 4: Run​

Now you're ready to execute dbt build and run the entire project.