Version history

Version 2.3.0, released 2021-08-10

Version 2.2.0, released 2021-05-05

Version 2.1.0, released 2020-09-23

  • Commit 14be654: feat: Disable pretty printing in BigQuery unless explicitly requested. Fixes issue 5330.
  • Commit 909f568: docs: Clarify the scopes used by BigQueryClient.Create and CreateAsync

Version 2.0.0, released 2020-06-04

  • Commit 0970dff: Fix: Propagates some cancellation tokens that weren't being propagated before.
  • Commit e9e6a47: Binary breaking change: Adds missing CancellationToken parameter on BigQueryDataset.DeleteModelAsync.
  • Commit 8e9c40f: Adds BigQuery Routines CRUD operations.
  • Commit 575c61a:
    • Convert BigQuery field validation from a regex to hand-written code.
    • This is entirely for the sake of performance. Benchmark results are approximately 10x better.
    • Fixes issue 4975

Version 2.0.0-beta04, released 2020-04-07

Version 2.0.0-beta03, released 2020-03-30

Version 2.0.0-beta02, released 2020-03-18

  • Commit 2b4c06f:
    • Table creation breaking change:
      • All options have been removed from Google.Cloud.BigQuery.V2.TableCreateOptions.
      • Table create operations overloads added that received a Google.Apis.Bigquery.v2.Data.Table instead.
      • Extension methods have been added to help in setting some Google.Apis.Bigquery.v2.Data.Table properties.
  • Commit d951c14:
    • Dataset creation breaking change:
      • All options have been removed from Google.Cloud.BigQuery.V2.DatasetCreateOptions.
      • Dataset create operations now received a Google.Apis.Bigquery.v2.Data.Dataset instead.
      • Extension methods have been added to help in setting some Google.Apis.Bigquery.v2.Data.Dataset properties.
  • Commit acad11b:
    • BigQueryResults breaking change.
      • TotalRows is now ulong? instead of ulong.
      • SafeTotalRows has been removed.

In addition to the above changes, this release now targets GAX 3.0.0 (GA).

Version 2.0.0-beta01, released 2020-02-20

Breaking changes:

  • Updated to GAX v3, which has breaking changes, particularly around async pagination
  • Removed obsolete BigQueryResults constructor
  • Insert operations now return a BigQueryInsertResults instead of void

Further breaking changes are being considered before the 3.0.0 release, specifically around BigQueryResults.SafeTotalRows and options to create resources (tables, datasets etc).

New features:

  • Introduced BigQueryInsertResults as a cleaner way of handling insert errors
  • Retrieval of partial results via GetTableOptions.SelectedFields
  • Support for ParentJobId filtering when listing jobs
  • CRUD support for models

Specific commits:

Version 1.4.0, released 2019-12-16

New features since 1.3.0:

  • Commit 1074e9f: Support for empty InsertIds when inserting rows.
  • Add TemplateSuffix, SkipInvalidRows and SuppressInsertErrors to InsertOptions.
  • Add DefaultPartitionExpiration and DefaultEncryptionConfiguration to CreateDatasetOptions.
  • Add table CreationTime, ExpirationTime and Clustering info to ListTables output.
  • Loosen the restriction on JobConfigurationQuery.DestinationTable not being null.
  • Provide option for using Avro logical types for load/extract.
  • Adds creation time filtering to BigQuery job listing.
  • New type BigQueryClientBuilder to simplify configuration.
  • Implement support for BigQuery GEOGRAPHY type.
  • netstandard2.0 target
  • Reimplemented query handling using GetQueryResults RPC instead of ListRows, resulting in a performance improvement

Version 1.3.0, released 2019-02-07

New features since 1.2.0:

  • Support for table clustering in CreateTableOptions
  • Nullable row count properties (SafeTotalRows and NumDmlAffectedRows) in BigQueryResults
  • Support for the NUMERIC type via BigQueryNumeric
  • Support for a projection to be specified when listing jobs
  • Support for time-based partitioning in load and query jobs
  • Support for time-based partitioning by a specific field
  • Support for SchemaUpdateOptions for load and query jobs
  • Support for Parquet load jobs
  • Support for ORC load jobs
  • Support for job labels
  • Support for supplying page tokens to all list operations
  • Public constructors for BigQueryTable etc, for improved testability

Version 1.2.0, released 2018-04-09

New features since 1.1.0:

  • Support for geo-regionalization for data sets and jobs

Version 1.1.0, released 2018-03-06

New features since 1.0.0:

Version 1.0.0, released 2017-12-07

Initial release.