import("context""fmt""cloud.google.com/go/bigquery")// copyMultiTable demonstrates using a copy job to copy multiple source tables into a single destination table.funccopyMultiTable(projectID,srcDatasetIDstring,srcTableIDs[]string,dstDatasetID,dstTableIDstring)error{// projectID := "my-project-id"// srcDatasetID := "sourcedataset"// srcTableIDs := []string{"table1","table2"}// dstDatasetID = "destinationdataset"// dstTableID = "destinationtable"ctx:=context.Background()client,err:=bigquery.NewClient(ctx,projectID)iferr!=nil{returnfmt.Errorf("bigquery.NewClient: %w",err)}deferclient.Close()srcDataset:=client.Dataset(srcDatasetID)dstDataset:=client.Dataset(dstDatasetID)vartableRefs[]*bigquery.Tablefor_,v:=rangesrcTableIDs{tableRefs=append(tableRefs,srcDataset.Table(v))}copier:=dstDataset.Table(dstTableID).CopierFrom(tableRefs...)copier.WriteDisposition=bigquery.WriteTruncatejob,err:=copier.Run(ctx)iferr!=nil{returnerr}status,err:=job.Wait(ctx)iferr!=nil{returnerr}iferr:=status.Err();err!=nil{returnerr}returnnil}

importcom.google.cloud.bigquery.BigQuery;importcom.google.cloud.bigquery.BigQueryException;importcom.google.cloud.bigquery.BigQueryOptions;importcom.google.cloud.bigquery.CopyJobConfiguration;importcom.google.cloud.bigquery.Job;importcom.google.cloud.bigquery.JobInfo;importcom.google.cloud.bigquery.TableId;importjava.util.Arrays;publicclassCopyMultipleTables{publicstaticvoidmain(String[]args){// TODO(developer): Replace these variables before running the sample.StringdestinationDatasetName="MY_DATASET_NAME";StringdestinationTableId="MY_TABLE_NAME";StringsourceTable1Id="MY_SOURCE_TABLE_1";StringsourceTable2Id="MY_SOURCE_TABLE_2";copyMultipleTables(destinationDatasetName,destinationTableId,sourceTable1Id,sourceTable2Id);}publicstaticvoidcopyMultipleTables(StringdestinationDatasetName,StringdestinationTableId,StringsourceTable1Id,StringsourceTable2Id){try{// Initialize client that will be used to send requests. This client only needs to be created// once, and can be reused for multiple requests.BigQuerybigquery=BigQueryOptions.getDefaultInstance().getService();TableIddestinationTable=TableId.of(destinationDatasetName,destinationTableId);TableIdsourceTable1=TableId.of(destinationDatasetName,sourceTable1Id);TableIdsourceTable2=TableId.of(destinationDatasetName,sourceTable2Id);// For more information on CopyJobConfiguration see:// https://googleapis.dev/java/google-cloud-clients/latest/com/google/cloud/bigquery/JobConfiguration.htmlCopyJobConfigurationconfiguration=CopyJobConfiguration.newBuilder(destinationTable,Arrays.asList(sourceTable1,sourceTable2)).build();// For more information on Job see:// https://googleapis.dev/java/google-cloud-clients/latest/index.html?com/google/cloud/bigquery/package-summary.htmlJobjob=bigquery.create(JobInfo.of(configuration));// Blocks until this job completes its execution, either failing or succeeding.JobcompletedJob=job.waitFor();if(completedJob==null){System.out.println("Job not executed since it no longer exists.");return;}elseif(completedJob.getStatus().getError()!=null){System.out.println("BigQuery was unable to copy tables due to an error: \n"+job.getStatus().getError());return;}System.out.println("Table copied successfully.");}catch(BigQueryException|InterruptedExceptione){System.out.println("Table copying job was interrupted. \n"+e.toString());}}}

// Import the Google Cloud client libraryconst{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();asyncfunctioncopyTableMultipleSource(){// Copy multiple source tables to a given destination./**   * TODO(developer): Uncomment the following lines before running the sample.   */// const datasetId = "my_dataset";// sourceTable = 'my_table';// destinationTable = 'testing';// Create a clientconstdataset=bigquery.dataset(datasetId);constmetadata={createDisposition:'CREATE_NEVER',writeDisposition:'WRITE_TRUNCATE',};// Create table referencesconsttable=dataset.table(sourceTable);constyourTable=dataset.table(destinationTable);// Copy tableconst[apiResponse]=awaittable.copy(yourTable,metadata);console.log(apiResponse.configuration.copy);}

fromgoogle.cloudimportbigquery# Construct a BigQuery client object.client=bigquery.Client()# TODO(developer): Set dest_table_id to the ID of the destination table.# dest_table_id = "your-project.your_dataset.your_table_name"# TODO(developer): Set table_ids to the list of the IDs of the original tables.# table_ids = ["your-project.your_dataset.your_table_name", ...]job=client.copy_table(table_ids,dest_table_id)# Make an API request.job.result()# Wait for the job to complete.print("The tables{} have been appended to{}".format(table_ids,dest_table_id))