Created
October 3, 2025 11:38
-
-
Save tatiana/c7831173ab09bf05d88839fb0b557920 to your computer and use it in GitHub Desktop.
Example of running fhir-dbt-analytics breaking the dbt pipeline into multiple dbt commands
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # Break down the execution of the dbt project https://github.com/google/fhir-dbt-analytics | |
| #set -v | |
| #set -x | |
| #set -e | |
| dbt run --select active_encounters_daily | |
| dbt run --select active_encounters_midnight_census | |
| dbt run --select active_patients_with_allergyintolerance | |
| dbt run --select active_patients_with_careteam_daily | |
| dbt run --select active_patients_with_composition_daily | |
| dbt run --select active_patients_with_diagnosticreport_daily | |
| dbt run --select active_patients_with_medicationadministration_daily | |
| dbt run --select active_patients_with_medicationrequest_daily | |
| dbt run --select active_patients_with_medicationstatement | |
| dbt run --select active_patients_with_observation_daily | |
| dbt run --select active_patients_with_servicerequest_daily | |
| dbt run --select allergyintolerance_count | |
| dbt run --select allergyintolerance_reference_encounter_undefined | |
| dbt run --select allergyintolerance_reference_encounter_unresolved | |
| dbt run --select allergyintolerance_reference_patient_undefined | |
| dbt run --select allergyintolerance_reference_patient_unresolved | |
| dbt run --select binary_count | |
| dbt run --select careteam_count | |
| dbt run --select careteam_reference_encounter_undefined | |
| dbt run --select careteam_reference_encounter_unresolved | |
| dbt run --select careteam_reference_patient_undefined | |
| dbt run --select careteam_reference_patient_unresolved | |
| dbt run --select careteam_reference_practitioner_undefined | |
| dbt run --select careteam_reference_practitioner_unresolved | |
| dbt run --select composition_binary_mimetype | |
| dbt run --select composition_count | |
| dbt run --select composition_reference_binary_undefined | |
| dbt run --select composition_reference_binary_unresolved | |
| dbt run --select composition_reference_encounter_undefined | |
| dbt run --select composition_reference_encounter_unresolved | |
| dbt run --select composition_reference_patient_undefined | |
| dbt run --select composition_reference_patient_unresolved | |
| dbt run --select composition_reference_practitioner_undefined | |
| dbt run --select composition_reference_practitioner_unresolved | |
| dbt run --select composition_with_section_text_div | |
| dbt run --select composition_with_type_text | |
| dbt run --select condition_count | |
| dbt run --select condition_reference_encounter_undefined | |
| dbt run --select condition_reference_encounter_unresolved | |
| dbt run --select condition_reference_patient_undefined | |
| dbt run --select condition_reference_patient_unresolved | |
| dbt run --select condition_with_code_text | |
| dbt run --select diagnosticreport_count | |
| dbt run --select diagnosticreport_performer_specialty | |
| dbt run --select diagnosticreport_reference_encounter_undefined | |
| dbt run --select diagnosticreport_reference_encounter_unresolved | |
| dbt run --select diagnosticreport_reference_observation_undefined | |
| dbt run --select diagnosticreport_reference_observation_unresolved | |
| dbt run --select diagnosticreport_reference_patient_undefined | |
| dbt run --select diagnosticreport_reference_patient_unresolved | |
| dbt run --select diagnosticreport_reference_practitioner_undefined | |
| dbt run --select diagnosticreport_reference_practitioner_unresolved | |
| dbt run --select diagnosticreport_reference_servicerequest_undefined | |
| dbt run --select diagnosticreport_reference_servicerequest_unresolved | |
| dbt run --select diagnosticreport_with_attachment | |
| dbt run --select diagnosticreport_with_binary_unresolved | |
| dbt run --select diagnosticreport_with_code_text | |
| dbt run --select diagnosticreport_with_conclusion | |
| dbt run --select documentreference_binary_mimetype | |
| dbt run --select documentreference_count | |
| dbt run --select documentreference_distribution_type | |
| dbt run --select documentreference_mimetype | |
| dbt run --select documentreference_reference_patient_undefined | |
| dbt run --select documentreference_reference_patient_unresolved | |
| dbt run --select documentreference_reference_practitioner_undefined | |
| dbt run --select documentreference_reference_practitioner_unresolved | |
| dbt run --select encounter_count | |
| dbt run --select encounter_count_by_end_date | |
| dbt run --select encounter_count_by_start_date | |
| dbt run --select encounter_reference_location_undefined | |
| dbt run --select encounter_reference_location_unresolved | |
| dbt run --select encounter_reference_patient_undefined | |
| dbt run --select encounter_reference_patient_unresolved | |
| dbt run --select episodeofcare_count | |
| dbt run --select location_count | |
| dbt run --select medication_count | |
| dbt run --select medicationadministration_count | |
| dbt run --select medicationadministration_dosage_dose_rate | |
| dbt run --select medicationadministration_dosage_instruction | |
| dbt run --select medicationadministration_dosage_route | |
| dbt run --select medicationadministration_reference_encounter_undefined | |
| dbt run --select medicationadministration_reference_encounter_unresolved | |
| dbt run --select medicationadministration_reference_medication_undefined | |
| dbt run --select medicationadministration_reference_medication_unresolved | |
| dbt run --select medicationadministration_reference_medicationrequest_undefined | |
| dbt run --select medicationadministration_reference_medicationrequest_unresolved | |
| dbt run --select medicationadministration_reference_patient_undefined | |
| dbt run --select medicationadministration_reference_patient_unresolved | |
| dbt run --select medicationdispense_dosage_dose_rate | |
| dbt run --select medicationdispense_dosage_instruction | |
| dbt run --select medicationdispense_dosage_route | |
| dbt run --select medicationrequest_count | |
| dbt run --select medicationrequest_dosage_dose_rate | |
| dbt run --select medicationrequest_dosage_instruction | |
| dbt run --select medicationrequest_dosage_route | |
| dbt run --select medicationrequest_reference_encounter_undefined | |
| dbt run --select medicationrequest_reference_encounter_unresolved | |
| dbt run --select medicationrequest_reference_medication_undefined | |
| dbt run --select medicationrequest_reference_medication_unresolved | |
| dbt run --select medicationrequest_reference_medicationrequest_undefined | |
| dbt run --select medicationrequest_reference_medicationrequest_unresolved | |
| dbt run --select medicationrequest_reference_patient_undefined | |
| dbt run --select medicationrequest_reference_patient_unresolved | |
| dbt run --select medicationrequest_reference_practitioner_undefined | |
| dbt run --select medicationrequest_reference_practitioner_unresolved | |
| dbt run --select medicationstatement_count | |
| dbt run --select medicationstatement_dosage_dose_rate | |
| dbt run --select medicationstatement_dosage_instruction | |
| dbt run --select medicationstatement_dosage_route | |
| dbt run --select medicationstatement_reference_encounter_undefined | |
| dbt run --select medicationstatement_reference_encounter_unresolved | |
| dbt run --select medicationstatement_reference_medication_undefined | |
| dbt run --select medicationstatement_reference_medication_unresolved | |
| dbt run --select medicationstatement_reference_patient_undefined | |
| dbt run --select medicationstatement_reference_patient_unresolved | |
| dbt run --select metric_all_definitions | |
| dbt run --select observation_count | |
| dbt run --select observation_quantity_unit | |
| dbt run --select observation_quantity_value | |
| dbt run --select observation_reference_encounter_undefined | |
| dbt run --select observation_reference_encounter_unresolved | |
| dbt run --select observation_reference_patient_undefined | |
| dbt run --select observation_reference_patient_unresolved | |
| dbt run --select observation_reference_servicerequest_undefined | |
| dbt run --select observation_reference_servicerequest_unresolved | |
| dbt run --select organization_count | |
| dbt run --select patient_count | |
| dbt run --select patient_dob_distribution | |
| dbt run --select patient_inactive | |
| dbt run --select patient_missing_dob | |
| dbt run --select patient_missing_encounter | |
| dbt run --select patient_missing_mrn | |
| dbt run --select patient_name_missing | |
| dbt run --select patient_testpatient | |
| dbt run --select patient_unknown_gender | |
| dbt run --select person_count | |
| dbt run --select person_reference_patient_undefined | |
| dbt run --select person_reference_patient_unresolved | |
| dbt run --select practitioner_count | |
| dbt run --select practitionerrole_count | |
| dbt run --select procedure_count | |
| dbt run --select procedure_reference_encounter_undefined | |
| dbt run --select procedure_reference_encounter_unresolved | |
| dbt run --select procedure_reference_patient_undefined | |
| dbt run --select procedure_reference_patient_unresolved | |
| dbt run --select procedure_reference_practitioner_undefined | |
| dbt run --select procedure_reference_practitioner_unresolved | |
| dbt run --select procedure_with_code_text | |
| dbt run --select project_variables | |
| dbt run --select resource_hour_distribution | |
| dbt run --select servicerequest_count | |
| dbt run --select servicerequest_reference_encounter_undefined | |
| dbt run --select servicerequest_reference_encounter_unresolved | |
| dbt run --select servicerequest_reference_patient_undefined | |
| dbt run --select servicerequest_reference_patient_unresolved | |
| dbt run --select servicerequest_reference_practitioner_undefined | |
| dbt run --select servicerequest_reference_practitioner_unresolved | |
| dbt run --select servicerequest_reference_servicerequest_undefined | |
| dbt run --select servicerequest_reference_servicerequest_unresolved | |
| dbt run --select unioned_thresholds | |
| dbt run --select AllergyIntolerance | |
| dbt run --select Binary | |
| dbt run --select CareTeam | |
| dbt run --select Composition | |
| dbt run --select Condition | |
| dbt run --select DiagnosticReport | |
| dbt run --select DocumentReference | |
| dbt run --select Encounter | |
| dbt run --select EpisodeOfCare | |
| dbt run --select ImagingStudy | |
| dbt run --select Location | |
| dbt run --select Medication | |
| dbt run --select MedicationAdministration | |
| dbt run --select MedicationDispense | |
| dbt run --select MedicationRequest | |
| dbt run --select MedicationStatement | |
| dbt run --select Observation | |
| dbt run --select Organization | |
| dbt run --select Patient | |
| dbt run --select Person | |
| dbt run --select Practitioner | |
| dbt run --select PractitionerRole | |
| dbt run --select Procedure | |
| dbt run --select ServiceRequest | |
| dbt run --select fhir_table_list |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment