Some Zus customers are interested in exporting a snapshot of the data currently available in their data mart as flat files to a cloud storage provider (e.g. Amazon Web Services, Google Cloud). This page describes the steps required to perform a one-time export of a Zus data mart from Snowflake to these common destinations.

Exporting to Amazon S3

Additional documentation on configuring an integration to AWS available from Snowflake here.

Reach out to your Zus account manager, let them know you want to export your data mart to AWS S3, and share the following information:
- Destination bucket (e.g. zus-[customer]-export-[date])
- Optional destination bucket prefix (e.g. parquet)
- AWS Account ID (12 digits)
- Name of an IAM role that the customer will create (e.g. zus-[customer]-export-role)
The Zus team will configure your Snowflake reader account and provide the following values:
- STORAGE_AWS_IAM_USER_ARN
- STORAGE_AWS_EXTERNAL_ID
Create an IAM role (using the name provided in step 1) in AWS. Use the following Trust Relationship and Policy documents:
- Trust relationship: Substitute STORAGE_AWS_IAM_USER_ARN and STORAGE_AWS_EXTERNAL_ID with the values from step 2

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Principal": {
                "AWS": "<storage_iam_user_arn>"
            },
            "Action": "sts:AssumeRole",
            "Condition": {
                "StringEquals": {
                    "sts:ExternalId": "<storage_aws_external_id>"
                }
            }
        }
    ]
}

Policy template below: Substitute <bucket> and <prefix> with the values from step 1 (note that there are multiple occurrences of each). If <prefix> is not provided, the Condition element below can be omitted.

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": [
                "s3:PutObject",
                "s3:GetObject",
                "s3:GetObjectVersion",
                "s3:DeleteObject",
                "s3:DeleteObjectVersion"
            ],
            "Resource": "arn:aws:s3:::<bucket>/<prefix>/*"
        },
        {
            "Effect": "Allow",
            "Action": [
                "s3:ListBucket",
                "s3:GetBucketLocation"
            ],
            "Resource": "arn:aws:s3:::<bucket>",
            "Condition": {
                "StringLike": {
                    "s3:prefix": [
                        "<prefix>/*"
                    ]
                }
            }
        }
    ]
}

Create a worksheet in your reader account and run COPY INTO commands targeting the above storage integration for each of the tables that you are interested in moving over. The COPY INTO command includes parameters to choose the file format (CSV, Parquet, etc).

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance/'
from allergy_intolerance
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance_code/'
from allergy_intolerance_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance_code_coding/'
from allergy_intolerance_code_coding
storage_integration = unload_to_s3
header = true;

...

To export all data mart tables to S3, run the following worksheet.

Worksheet to export all tables to s3

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance/'
from allergy_intolerance
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/location/'
from location
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance_code/'
from allergy_intolerance_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance_code_coding/'
from allergy_intolerance_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance_identifier/'
from allergy_intolerance_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance_note/'
from allergy_intolerance_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance_reaction/'
from allergy_intolerance_reaction
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance_reaction_manifestation/'
from allergy_intolerance_reaction_manifestation
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/allergy_intolerance_reaction_manifestation_coding/'
from allergy_intolerance_reaction_manifestation_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/appointment/'
from appointment
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/appointment_identifier/'
from appointment_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/appointment_participant_location/'
from appointment_participant_location
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/appointment_participant_practitioner/'
from appointment_participant_practitioner
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/appointment_participant_practitioner_type/'
from appointment_participant_practitioner_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/appointment_participant_practitioner_type_coding/'
from appointment_participant_practitioner_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/appointment_type/'
from appointment_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/appointment_type_coding/'
from appointment_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/body_site_concept/'
from body_site_concept
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/body_site_concept_coding/'
from body_site_concept_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_plan/'
from care_plan
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_plan_activity/'
from care_plan_activity
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_plan_activity_code/'
from care_plan_activity_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_plan_activity_code_coding/'
from care_plan_activity_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_plan_activity_product/'
from care_plan_activity_product
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_plan_activity_product_coding/'
from care_plan_activity_product_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_plan_goal/'
from care_plan_goal
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_plan_identifier/'
from care_plan_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_plan_note/'
from care_plan_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_team/'
from care_team
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_team_identifier/'
from care_team_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_team_participant/'
from care_team_participant
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_team_participant_role/'
from care_team_participant_role
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_team_participant_role_coding/'
from care_team_participant_role_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/care_team_telecom/'
from care_team_telecom
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/condition/'
from condition
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/condition_category/'
from condition_category
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/condition_category_coding/'
from condition_category_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/condition_code/'
from condition_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/condition_code_coding/'
from condition_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/condition_identifier/'
from condition_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/condition_note/'
from condition_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/consent/'
from consent
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/consent_category/'
from consent_category
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/consent_category_coding/'
from consent_category_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/consent_identifier/'
from consent_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/consent_policy_rule/'
from consent_policy_rule
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/consent_policy_rule_coding/'
from consent_policy_rule_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/consent_provision_actor/'
from consent_provision_actor
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/consent_provision_actor_role/'
from consent_provision_actor_role
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/consent_provision_actor_role_coding/'
from consent_provision_actor_role_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/contact_point/'
from contact_point
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/coverage/'
from coverage
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/coverage_identifier/'
from coverage_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/coverage_payor/'
from coverage_payor
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/coverage_type/'
from coverage_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/coverage_type_coding/'
from coverage_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device/'
from device
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device_identifier/'
from device_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device_name/'
from device_name
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device_note/'
from device_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device_specialization_system_type_bridge/'
from device_specialization_system_type_bridge
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device_specialization_system_type_coding/'
from device_specialization_system_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device_udi_carrier/'
from device_udi_carrier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device_use_statement/'
from device_use_statement
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device_use_statement_derived_from/'
from device_use_statement_derived_from
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/device_use_statement_identifier/'
from device_use_statement_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/diagnostic_report/'
from diagnostic_report
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/diagnostic_report_code/'
from diagnostic_report_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/diagnostic_report_code_coding/'
from diagnostic_report_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/diagnostic_report_identifier/'
from diagnostic_report_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/diagnostic_report_performer/'
from diagnostic_report_performer
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/diagnostic_report_result/'
from diagnostic_report_result
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/document_reference/'
from document_reference
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/document_reference_category_bridge/'
from document_reference_category_bridge
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/document_reference_category_coding/'
from document_reference_category_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/document_reference_identifier/'
from document_reference_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/document_reference_relates_to/'
from document_reference_relates_to
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/document_reference_type/'
from document_reference_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/document_reference_type_coding/'
from document_reference_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/dosage/'
from dosage
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/dosage_method/'
from dosage_method
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/dosage_method_coding/'
from dosage_method_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter/'
from encounter
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_diagnosis/'
from encounter_diagnosis
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_hospitalization_discharge_disposition/'
from encounter_hospitalization_discharge_disposition
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_hospitalization_discharge_disposition_coding/'
from encounter_hospitalization_discharge_disposition_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_identifier/'
from encounter_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_participant/'
from encounter_participant
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_participant_type/'
from encounter_participant_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_participant_type_coding/'
from encounter_participant_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_reason_code/'
from encounter_reason_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_type/'
from encounter_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/encounter_type_coding/'
from encounter_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/family_member_history/'
from family_member_history
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/family_member_history_condition/'
from family_member_history_condition
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/family_member_history_condition_code/'
from family_member_history_condition_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/family_member_history_condition_code_coding/'
from family_member_history_condition_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/family_member_history_identifier/'
from family_member_history_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/family_member_history_note/'
from family_member_history_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/family_member_history_relationship/'
from family_member_history_relationship
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/family_member_history_relationship_coding/'
from family_member_history_relationship_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/goal/'
from goal
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/goal_description/'
from goal_description
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/goal_description_coding/'
from goal_description_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/goal_identifier/'
from goal_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/goal_target/'
from goal_target
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/goal_target_measure/'
from goal_target_measure
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/goal_target_measure_coding/'
from goal_target_measure_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/human_name/'
from human_name
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/human_name_given/'
from human_name_given
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/identifier/'
from identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/immunization/'
from immunization
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/immunization_identifier/'
from immunization_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/immunization_note/'
from immunization_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/immunization_status_reason/'
from immunization_status_reason
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/immunization_status_reason_coding/'
from immunization_status_reason_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/immunization_vaccine_code/'
from immunization_vaccine_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/immunization_vaccine_code_coding/'
from immunization_vaccine_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter/'
from lens_encounter
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter_aggregated_from/'
from lens_encounter_aggregated_from
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter_diagnosis/'
from lens_encounter_diagnosis
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter_hospitalization_discharge_disposition/'
from lens_encounter_hospitalization_discharge_disposition
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter_hospitalization_discharge_disposition_coding/'
from lens_encounter_hospitalization_discharge_disposition_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter_identifier/'
from lens_encounter_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter_participant/'
from lens_encounter_participant
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter_related_binaries/'
from lens_encounter_related_binaries
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter_type/'
from lens_encounter_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_encounter_type_coding/'
from lens_encounter_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_rxnorm_medication_statement/'
from lens_rxnorm_medication_statement
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_snomed_condition/'
from lens_snomed_condition
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_snomed_condition_code/'
from lens_snomed_condition_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_snomed_condition_code_coding/'
from lens_snomed_condition_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_transition_of_care/'
from lens_transition_of_care
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_transition_of_care_aggregated_from/'
from lens_transition_of_care_aggregated_from
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_transition_of_care_diagnosis/'
from lens_transition_of_care_diagnosis
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_transition_of_care_discharge_disposition/'
from lens_transition_of_care_discharge_disposition
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_transition_of_care_discharge_disposition_coding/'
from lens_transition_of_care_discharge_disposition_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/lens_transition_of_care_identifier/'
from lens_transition_of_care_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/location_identifier/'
from location_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/location_physical_type/'
from location_physical_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/location_physical_type_coding/'
from location_physical_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/location_telecom/'
from location_telecom
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/location_type/'
from location_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/location_type_coding/'
from location_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication/'
from medication
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_administration/'
from medication_administration
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_administration_identifier/'
from medication_administration_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_administration_reason_code/'
from medication_administration_reason_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_administration_reason_reference/'
from medication_administration_reason_reference
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_concept/'
from medication_concept
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_concept_coding/'
from medication_concept_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_dispense/'
from medication_dispense
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_dispense_identifier/'
from medication_dispense_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_form/'
from medication_form
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_form_coding/'
from medication_form_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_ingredient/'
from medication_ingredient
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_ingredient_item_code/'
from medication_ingredient_item_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_ingredient_item_code_coding/'
from medication_ingredient_item_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_request/'
from medication_request
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_request_category/'
from medication_request_category
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_request_category_coding/'
from medication_request_category_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_request_identifier/'
from medication_request_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_request_note/'
from medication_request_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_request_reason_code_bridge/'
from medication_request_reason_code_bridge
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_request_reason_code_coding/'
from medication_request_reason_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_request_reason_reference/'
from medication_request_reason_reference
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_statement/'
from medication_statement
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_statement_identifier/'
from medication_statement_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_statement_note/'
from medication_statement_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_statement_reason_code_bridge/'
from medication_statement_reason_code_bridge
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/medication_statement_reason_code_coding/'
from medication_statement_reason_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation/'
from observation
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_code/'
from observation_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_code_coding/'
from observation_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_identifier/'
from observation_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_interpretation/'
from observation_interpretation
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_interpretation_coding/'
from observation_interpretation_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_method/'
from observation_method
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_method_coding/'
from observation_method_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_note/'
from observation_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_performer/'
from observation_performer
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_value_concept/'
from observation_value_concept
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/observation_value_concept_coding/'
from observation_value_concept_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/organization/'
from organization
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/organization_identifier/'
from organization_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/organization_telecom/'
from organization_telecom
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/organization_type/'
from organization_type
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/organization_type_coding/'
from organization_type_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient/'
from patient
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_address/'
from patient_address
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_communication/'
from patient_communication
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_communication_language/'
from patient_communication_language
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_communication_language_coding/'
from patient_communication_language_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_contact/'
from patient_contact
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_contact_telecom/'
from patient_contact_telecom
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_general_practitioner/'
from patient_general_practitioner
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_identifier/'
from patient_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_name/'
from patient_name
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/patient_telecom/'
from patient_telecom
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/practitioner/'
from practitioner
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/practitioner_identifier/'
from practitioner_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/practitioner_qualification/'
from practitioner_qualification
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/practitioner_qualification_coding/'
from practitioner_qualification_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/practitioner_telecom/'
from practitioner_telecom
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/procedure/'
from procedure
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/procedure_code/'
from procedure_code
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/procedure_code_coding/'
from procedure_code_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/procedure_identifier/'
from procedure_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/procedure_note/'
from procedure_note
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/related_person/'
from related_person
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/related_person_identifier/'
from related_person_identifier
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/related_person_relationship/'
from related_person_relationship
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/related_person_relationship_coding/'
from related_person_relationship_coding
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/related_person_telecom/'
from related_person_telecom
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/route_concept/'
from route_concept
storage_integration = unload_to_s3
header = true;

copy into 's3://zus-[customer]-export-[date]/route_concept_coding/'
from route_concept_coding
storage_integration = unload_to_s3
header = true;

Exporting to Google Cloud Storage

Additional documentation on configuring an integration to Google Cloud Storage (GCS) available from Snowflake here.

Reach out to your Zus account manager, let them know you want to export your data mart to Google Cloud Storage, and share the following information
- Destination bucket (e.g. zus-[customer]-export-[date])
- Optional destination bucket prefix (e.g. parquet)
The Zus team will configure your Snowflake reader account and provide the following values:
- STORAGE_GCP_SERVICE_ACCOUNT
Create a Custom IAM Role in GCP (following the “data unloading only” option from Snowflake docs)
- From the home dashboard, select IAM & Admin » Roles
- Select Create Role and enter a title and description
- Select Add Permissions, and check the following four permissions
  - storage.buckets.get
  - storage.objects.create
  - storage.objects.delete
  - storage.objects.list
- Select Add, and Create
Assign the Custom Role to the GCS bucket
- From the home dashboard, select Cloud Storage » Buckets.
- Select the bucket from Step 1
- Select Permissions » View by principals, then select Grant access.
- Under Add principals, paste the value from Step 2
Create a worksheet in your reader account and run COPY INTO commands targeting the above storage integration for each of the tables that you are interested in moving over. The COPY INTO command includes parameters to choose the file format (CSV, Parquet, etc).

copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance/'
from allergy_intolerance
storage_integration = unload_to_gcs;

copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance_code/'
from allergy_intolerance_code
storage_integration = unload_to_gcs;

copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance_code_coding/'
from allergy_intolerance_code_coding
storage_integration = unload_to_gcs;

...

To export all data mart tables to GCS, run the following worksheet.

Worksheet to export all tables to GCS

copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance/'
from allergy_intolerance
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/location/'
from location
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance_code/'
from allergy_intolerance_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance_code_coding/'
from allergy_intolerance_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance_identifier/'
from allergy_intolerance_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance_note/'
from allergy_intolerance_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance_reaction/'
from allergy_intolerance_reaction
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance_reaction_manifestation/'
from allergy_intolerance_reaction_manifestation
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/allergy_intolerance_reaction_manifestation_coding/'
from allergy_intolerance_reaction_manifestation_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/appointment/'
from appointment
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/appointment_identifier/'
from appointment_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/appointment_participant_location/'
from appointment_participant_location
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/appointment_participant_practitioner/'
from appointment_participant_practitioner
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/appointment_participant_practitioner_type/'
from appointment_participant_practitioner_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/appointment_participant_practitioner_type_coding/'
from appointment_participant_practitioner_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/appointment_type/'
from appointment_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/appointment_type_coding/'
from appointment_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/body_site_concept/'
from body_site_concept
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/body_site_concept_coding/'
from body_site_concept_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_plan/'
from care_plan
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_plan_activity/'
from care_plan_activity
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_plan_activity_code/'
from care_plan_activity_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_plan_activity_code_coding/'
from care_plan_activity_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_plan_activity_product/'
from care_plan_activity_product
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_plan_activity_product_coding/'
from care_plan_activity_product_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_plan_goal/'
from care_plan_goal
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_plan_identifier/'
from care_plan_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_plan_note/'
from care_plan_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_team/'
from care_team
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_team_identifier/'
from care_team_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_team_participant/'
from care_team_participant
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_team_participant_role/'
from care_team_participant_role
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_team_participant_role_coding/'
from care_team_participant_role_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/care_team_telecom/'
from care_team_telecom
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/condition/'
from condition
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/condition_category/'
from condition_category
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/condition_category_coding/'
from condition_category_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/condition_code/'
from condition_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/condition_code_coding/'
from condition_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/condition_identifier/'
from condition_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/condition_note/'
from condition_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/consent/'
from consent
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/consent_category/'
from consent_category
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/consent_category_coding/'
from consent_category_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/consent_identifier/'
from consent_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/consent_policy_rule/'
from consent_policy_rule
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/consent_policy_rule_coding/'
from consent_policy_rule_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/consent_provision_actor/'
from consent_provision_actor
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/consent_provision_actor_role/'
from consent_provision_actor_role
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/consent_provision_actor_role_coding/'
from consent_provision_actor_role_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/contact_point/'
from contact_point
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/coverage/'
from coverage
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/coverage_identifier/'
from coverage_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/coverage_payor/'
from coverage_payor
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/coverage_type/'
from coverage_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/coverage_type_coding/'
from coverage_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device/'
from device
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device_identifier/'
from device_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device_name/'
from device_name
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device_note/'
from device_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device_specialization_system_type_bridge/'
from device_specialization_system_type_bridge
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device_specialization_system_type_coding/'
from device_specialization_system_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device_udi_carrier/'
from device_udi_carrier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device_use_statement/'
from device_use_statement
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device_use_statement_derived_from/'
from device_use_statement_derived_from
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/device_use_statement_identifier/'
from device_use_statement_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/diagnostic_report/'
from diagnostic_report
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/diagnostic_report_code/'
from diagnostic_report_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/diagnostic_report_code_coding/'
from diagnostic_report_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/diagnostic_report_identifier/'
from diagnostic_report_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/diagnostic_report_performer/'
from diagnostic_report_performer
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/diagnostic_report_result/'
from diagnostic_report_result
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/document_reference/'
from document_reference
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/document_reference_category_bridge/'
from document_reference_category_bridge
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/document_reference_category_coding/'
from document_reference_category_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/document_reference_identifier/'
from document_reference_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/document_reference_relates_to/'
from document_reference_relates_to
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/document_reference_type/'
from document_reference_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/document_reference_type_coding/'
from document_reference_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/dosage/'
from dosage
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/dosage_method/'
from dosage_method
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/dosage_method_coding/'
from dosage_method_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter/'
from encounter
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_diagnosis/'
from encounter_diagnosis
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_hospitalization_discharge_disposition/'
from encounter_hospitalization_discharge_disposition
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_hospitalization_discharge_disposition_coding/'
from encounter_hospitalization_discharge_disposition_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_identifier/'
from encounter_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_participant/'
from encounter_participant
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_participant_type/'
from encounter_participant_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_participant_type_coding/'
from encounter_participant_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_reason_code/'
from encounter_reason_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_type/'
from encounter_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/encounter_type_coding/'
from encounter_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/family_member_history/'
from family_member_history
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/family_member_history_condition/'
from family_member_history_condition
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/family_member_history_condition_code/'
from family_member_history_condition_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/family_member_history_condition_code_coding/'
from family_member_history_condition_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/family_member_history_identifier/'
from family_member_history_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/family_member_history_note/'
from family_member_history_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/family_member_history_relationship/'
from family_member_history_relationship
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/family_member_history_relationship_coding/'
from family_member_history_relationship_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/goal/'
from goal
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/goal_description/'
from goal_description
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/goal_description_coding/'
from goal_description_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/goal_identifier/'
from goal_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/goal_target/'
from goal_target
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/goal_target_measure/'
from goal_target_measure
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/goal_target_measure_coding/'
from goal_target_measure_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/human_name/'
from human_name
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/human_name_given/'
from human_name_given
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/identifier/'
from identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/immunization/'
from immunization
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/immunization_identifier/'
from immunization_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/immunization_note/'
from immunization_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/immunization_status_reason/'
from immunization_status_reason
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/immunization_status_reason_coding/'
from immunization_status_reason_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/immunization_vaccine_code/'
from immunization_vaccine_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/immunization_vaccine_code_coding/'
from immunization_vaccine_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter/'
from lens_encounter
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter_aggregated_from/'
from lens_encounter_aggregated_from
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter_diagnosis/'
from lens_encounter_diagnosis
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter_hospitalization_discharge_disposition/'
from lens_encounter_hospitalization_discharge_disposition
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter_hospitalization_discharge_disposition_coding/'
from lens_encounter_hospitalization_discharge_disposition_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter_identifier/'
from lens_encounter_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter_participant/'
from lens_encounter_participant
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter_related_binaries/'
from lens_encounter_related_binaries
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter_type/'
from lens_encounter_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_encounter_type_coding/'
from lens_encounter_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_rxnorm_medication_statement/'
from lens_rxnorm_medication_statement
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_snomed_condition/'
from lens_snomed_condition
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_snomed_condition_code/'
from lens_snomed_condition_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_snomed_condition_code_coding/'
from lens_snomed_condition_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_transition_of_care/'
from lens_transition_of_care
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_transition_of_care_aggregated_from/'
from lens_transition_of_care_aggregated_from
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_transition_of_care_diagnosis/'
from lens_transition_of_care_diagnosis
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_transition_of_care_discharge_disposition/'
from lens_transition_of_care_discharge_disposition
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_transition_of_care_discharge_disposition_coding/'
from lens_transition_of_care_discharge_disposition_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/lens_transition_of_care_identifier/'
from lens_transition_of_care_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/location_identifier/'
from location_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/location_physical_type/'
from location_physical_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/location_physical_type_coding/'
from location_physical_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/location_telecom/'
from location_telecom
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/location_type/'
from location_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/location_type_coding/'
from location_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication/'
from medication
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_administration/'
from medication_administration
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_administration_identifier/'
from medication_administration_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_administration_reason_code/'
from medication_administration_reason_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_administration_reason_reference/'
from medication_administration_reason_reference
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_concept/'
from medication_concept
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_concept_coding/'
from medication_concept_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_dispense/'
from medication_dispense
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_dispense_identifier/'
from medication_dispense_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_form/'
from medication_form
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_form_coding/'
from medication_form_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_ingredient/'
from medication_ingredient
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_ingredient_item_code/'
from medication_ingredient_item_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_ingredient_item_code_coding/'
from medication_ingredient_item_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_request/'
from medication_request
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_request_category/'
from medication_request_category
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_request_category_coding/'
from medication_request_category_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_request_identifier/'
from medication_request_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_request_note/'
from medication_request_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_request_reason_code_bridge/'
from medication_request_reason_code_bridge
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_request_reason_code_coding/'
from medication_request_reason_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_request_reason_reference/'
from medication_request_reason_reference
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_statement/'
from medication_statement
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_statement_identifier/'
from medication_statement_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_statement_note/'
from medication_statement_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_statement_reason_code_bridge/'
from medication_statement_reason_code_bridge
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/medication_statement_reason_code_coding/'
from medication_statement_reason_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation/'
from observation
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_code/'
from observation_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_code_coding/'
from observation_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_identifier/'
from observation_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_interpretation/'
from observation_interpretation
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_interpretation_coding/'
from observation_interpretation_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_method/'
from observation_method
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_method_coding/'
from observation_method_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_note/'
from observation_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_performer/'
from observation_performer
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_value_concept/'
from observation_value_concept
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/observation_value_concept_coding/'
from observation_value_concept_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/organization/'
from organization
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/organization_identifier/'
from organization_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/organization_telecom/'
from organization_telecom
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/organization_type/'
from organization_type
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/organization_type_coding/'
from organization_type_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient/'
from patient
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_address/'
from patient_address
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_communication/'
from patient_communication
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_communication_language/'
from patient_communication_language
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_communication_language_coding/'
from patient_communication_language_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_contact/'
from patient_contact
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_contact_telecom/'
from patient_contact_telecom
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_general_practitioner/'
from patient_general_practitioner
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_identifier/'
from patient_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_name/'
from patient_name
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/patient_telecom/'
from patient_telecom
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/practitioner/'
from practitioner
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/practitioner_identifier/'
from practitioner_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/practitioner_qualification/'
from practitioner_qualification
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/practitioner_qualification_coding/'
from practitioner_qualification_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/practitioner_telecom/'
from practitioner_telecom
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/procedure/'
from procedure
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/procedure_code/'
from procedure_code
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/procedure_code_coding/'
from procedure_code_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/procedure_identifier/'
from procedure_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/procedure_note/'
from procedure_note
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/related_person/'
from related_person
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/related_person_identifier/'
from related_person_identifier
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/related_person_relationship/'
from related_person_relationship
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/related_person_relationship_coding/'
from related_person_relationship_coding
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/related_person_telecom/'
from related_person_telecom
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/route_concept/'
from route_concept
storage_integration = unload_to_gcs;


copy into 'gcs://zus-[customer]-export-[date]/route_concept_coding/'
from route_concept_coding
storage_integration = unload_to_gcs;