gcloud alpha alloydb clusters export

gcloud alpha alloydb clusters export - export data from an AlloyDB cluster to Google Cloud Storage

gcloud alpha alloydb clusters export CLUSTER --database=DATABASE --gcs-uri=GCS_URI --region=REGION ([--csv --select-query=SELECT_QUERY : --escape-character=ESCAPE_CHARACTER --field-delimiter=FIELD_DELIMITER --quote-character=QUOTE_CHARACTER]     | [--sql : --schema-only --tables=TABLES [--clean-target-objects : --if-exist-target-objects]]) [--async] [GCLOUD_WIDE_FLAG …]

gcloud alpha alloydb clusters export my-cluster --region=us-central1 --database=my-database --gcs-uri=gs://my-bucket/my-export-file-path --select-query="SELECT * FROM my-table"

CLUSTER

AlloyDB cluster ID

--database=DATABASE

Database name from which export has to be done.

Destination URI where the file needs to be exported.

This must be specified.

--gcs-uri=GCS_URI

Path to the Google Cloud Storage file to which export has to be done.

--region=REGION

Regional location (e.g. asia-east1, us-east1). See the full list of regions at https://cloud.google.com/sql/docs/instance-locations.

Export options for the cluster.

Exactly one of these must be specified:

CSV export options for the cluster.

--csv

Specifies destination file type.

This flag argument must be specified if any of the other arguments in this group are specified.

--select-query=SELECT_QUERY

Select query to be used for export.

This flag argument must be specified if any of the other arguments in this group are specified.

--escape-character=ESCAPE_CHARACTER

Escape character to be used for export.

--field-delimiter=FIELD_DELIMITER

Field delimiter to be used for export.

--quote-character=QUOTE_CHARACTER

Quote character to be used for export.

SQL export options for the cluster.

--sql

Specifies destination file type.

This flag argument must be specified if any of the other arguments in this group are specified.

--schema-only

Export only schema of the database.

--tables=TABLES

Comma-separated list of table names which need to be exported.

SQL export options to clean target objects.

--clean-target-objects

If true, output commands to DROP all the dumped database objects prior to outputting the commands for creating them.

This flag argument must be specified if any of the other arguments in this group are specified.

--if-exist-target-objects

If true, use DROP … IF EXISTS commands to check for the object's existence before dropping it in clean_target_objects mode.

--async

Return immediately, without waiting for the operation in progress to complete.

Run $ gcloud help for details.

gcloud beta alloydb clusters export