- NAME
- 
- gcloud alpha bq tables copy - copy one BigQuery table to another
 
- SYNOPSIS
- 
- 
gcloud alpha bq tables copy(--destination=DESTINATION:--destination-dataset=DESTINATION_DATASET) (--source=SOURCE:--source-dataset=SOURCE_DATASET) [--async] [--job-id=JOB_ID] [--overwrite] [GCLOUD_WIDE_FLAG …]
 
- 
- DESCRIPTION
- 
(ALPHA)gcloud alpha bq tables copyCopies one BigQuery table to another.
- EXAMPLES
- 
The following copies table my-tableto tablemy-other-table, in datasetmy-datasetoverwriting destination if it exists:gcloud alpha bq tables copy --source my-table --destination my-other-table --source-dataset my-dataset --overwrite
- REQUIRED FLAGS
- 
- 
Table resource - The destination to copy to. 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 projectattribute:- 
provide the argument --destinationon the command line with a fully specified name;
- 
provide the argument --projecton the command line;
- 
set the property core/project.
 This must be specified. - --destination=- DESTINATION
- 
ID of the table or fully qualified identifier for the table.
To set the sourceattribute:- 
provide the argument --destinationon the command line.
 This flag argument must be specified if any of the other arguments in this group are specified. 
- 
provide the argument 
- --destination-dataset=- DESTINATION_DATASET
- 
The id of the BigQuery dataset.
To set the datasetattribute:- 
provide the argument --destinationon the command line with a fully specified name;
- 
provide the argument --destination-dataseton the command line;
- 
provide the argument --source-dataseton the command line.
 
- 
provide the argument 
 
- 
provide the argument 
- 
Table resource - The source to copy 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 projectattribute:- 
provide the argument --sourceon the command line with a fully specified name;
- 
provide the argument --projecton the command line;
- 
set the property core/project.
 This must be specified. - --source=- SOURCE
- 
ID of the table or fully qualified identifier for the table.
To set the sourceattribute:- 
provide the argument --sourceon the command line.
 This flag argument must be specified if any of the other arguments in this group are specified. 
- 
provide the argument 
- --source-dataset=- SOURCE_DATASET
- 
The id of the BigQuery dataset.
To set the datasetattribute:- 
provide the argument --sourceon the command line with a fully specified name;
- 
provide the argument --source-dataseton the command line;
- 
provide the argument --destination-dataseton the command line.
 
- 
provide the argument 
 
- 
provide the argument 
 
- 
Table resource - The destination to copy to. 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.
- OPTIONAL FLAGS
- 
- --async
- Return immediately, without waiting for the operation in progress to complete.
- --job-id=- JOB_ID
- A unique job ID to use for the request. If not specified a unique job id will be generated.
- --overwrite
- Overwrite if the resource already exists.
 
- GCLOUD WIDE FLAGS
- 
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 helpfor details.
- NOTES
- 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.
      gcloud alpha bq tables copy
  
  Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-05-07 UTC.