public void CopyTable( string projectId = "your-project-id", string destinationDatasetId = "your_dataset_id" ) { BigQueryClient client = BigQueryClient.Create(projectId); TableReference sourceTableRef = new TableReference() { TableId = "shakespeare", DatasetId = "samples", ProjectId = "bigquery-public-data" }; TableReference destinationTableRef = client.GetTableReference( destinationDatasetId, "destination_table"); BigQueryJob job = client.CreateCopyJob( sourceTableRef, destinationTableRef) .PollUntilCompleted() // Wait for the job to complete. .ThrowOnAnyError(); // Retrieve destination table BigQueryTable destinationTable = client.GetTable(destinationTableRef); Console.WriteLine( $"Copied {destinationTable.Resource.NumRows} rows from table " + $"{sourceTableRef.DatasetId}.{sourceTableRef.TableId} " + $"to {destinationTable.FullyQualifiedId}." ); }
private void setupTable(DateTime dateTime) { DateTime now = DateTime.UtcNow; TableReference src = new TableReference() { ProjectId = "firebase-lispace", DatasetId = "binance_orderbooks", TableId = "template" }; TableReference dst = new TableReference() { ProjectId = "firebase-lispace", DatasetId = "binance_orderbooks", TableId = getTableName(dateTime) }; bqClient.CreateCopyJob(src, dst); }