gcloud alpha healthcare fhir-stores export bq - export Cloud Healthcare API FHIR resources to BigQuery
gcloud alpha healthcare fhir-stores export bq (FHIR_STORE : --dataset=DATASET --location=LOCATION) --bq-dataset=BQ_DATASET --schema-type=SCHEMA_TYPE [--async] [--recursive-depth=RECURSIVE_DEPTH] [--resource-type=RESOURCE_TYPE] [--since=SINCE] [--write-disposition=WRITE_DISPOSITION] [GCLOUD_WIDE_FLAG ...]
(ALPHA) Export Cloud Healthcare API FHIR resources to BigQuery.
To export the fhir-store 'test-fhir-store' to the BigQuery dataset 'bqdataset', run:
$ gcloud alpha healthcare fhir-stores export bq test-fhir-store \ --bq-dataset=bq://my-project.bqdataset --dataset=test-dataset
To perform the same export, but with the 'ANALYTICS' schema and the recursive structure depth of 3, run:
$ gcloud alpha healthcare fhir-stores export bq test-fhir-store \ --bq-dataset=bq://my-project.bqdataset --dataset=test-dataset \ --schema-type=analytics --recursive-depth=3
- FhirStore resource - Cloud Healthcare API FHIR store to export resources from.
The arguments in this group can be used to specify the attributes of this resource. (NOTE) Some attributes are not given arguments in this group but can be set in other ways. To set the project attribute:
- —
provide the argument fhir_store on the command line with a fully specified name;
- —
provide the argument --project on the command line;
- —
set the property core/project.
This must be specified.
- FHIR_STORE
ID of the fhirStore or fully qualified identifier for the fhirStore. To set the fhir_store attribute:
provide the argument fhir_store on the command line.
This positional argument must be specified if any of the other arguments in this group are specified.
- --dataset=DATASET
Cloud Healthcare dataset. To set the dataset attribute:
provide the argument fhir_store on the command line with a fully specified name;
provide the argument --dataset on the command line.
- --location=LOCATION
Google Cloud location. To set the location attribute:
provide the argument fhir_store on the command line with a fully specified name;
provide the argument --location on the command line;
set the property healthcare/location.
- --bq-dataset=BQ_DATASET
BigQuery dataset that houses the BigQuery tables.
- --schema-type=SCHEMA_TYPE
Specifies the output schema type. If unspecified, the default is LOSSLESS. SCHEMA_TYPE must be one of:
- analytics
Analytics schema defined by the FHIR community. See https://github.com/rbrush/sql-on-fhir/blob/master/sql-on-fhir.md.
- analytics_v2
Analytics V2, similar to schema defined by the FHIR community, with added support for extensions with one or more occurrences and contained resources in stringified JSON.
- lossless
Schema generated from original FHIR data.
- --async
Return immediately, without waiting for the operation in progress to complete.
- --recursive-depth=RECURSIVE_DEPTH
The depth for all recursive structures in the output analytics schema. For example, concept in the CodeSystem resource is a recursive structure; when the depth is 2, the CodeSystem table will have a column called concept.concept but not concept.concept.concept. If not specified or set to 0, the server will use the default value 2.
- --resource-type=RESOURCE_TYPE
String of comma-delimited FHIR resource types. If provided, only resources of the specified resource type(s) are exported.
- --since=SINCE
If provided, only resources updated after this time are exported. The time uses the format YYYY-MM-DDThh:mm:ss.sss+zz:zz. For example, 2015-02-07T13:28:17.239+02:00 or 2017-01-01T00:00:00Z. The time must be specified to the second and include a time zone.
- --write-disposition=WRITE_DISPOSITION
Determines whether existing tables in the destination dataset are overwritten or appended to. WRITE_DISPOSITION must be one of:
- write-append
Append data to the existing tables.
- write-empty
Only export data if the destination tables are empty.
- write-truncate
Erase all existing data in the tables before writing the instances.
These flags are available to all commands: --access-token-file, --account, --billing-project, --configuration, --flags-file, --flatten, --format, --help, --impersonate-service-account, --log-http, --project, --quiet, --trace-token, --user-output-enabled, --verbosity.
Run $ gcloud help for details.
This command uses the healthcare/v1alpha2 API. The full documentation for this API can be found at: https://cloud.google.com/healthcare
This command is currently in alpha and might change without notice. If this command fails with API permission errors despite specifying the correct project, you might be trying to access an API with an invitation-only early access allowlist. These variants are also available:
$ gcloud healthcare fhir-stores export bq
$ gcloud beta healthcare fhir-stores export bq