Version history

Version 2.4.0, released 2022-05-05

GA release of the features previously in beta: support for BigNumeric, and more detailed exceptions.

Version 2.4.0-beta02, released 2022-04-26

New features

Include more information on GoogleApiException.Message when possible. (commit 2057c2e)

BREAKING CHANGE: If calling code depended on the exact exception message, it could be broken by this change. Customers are strongly encouraged not to depend on error message text.

Version 2.4.0-beta01, released 2022-02-07

New features

Add support for BigNumeric. (commit 4dc2e9b)

Version 2.3.0, released 2021-08-10

Commit d51544c: In GetOrCreate methods, retry "get" operation if "create" fails due to conflict. Fixes issue 6902

Version 2.2.0, released 2021-05-05

Commit a07ebae: feat: Model extract jobs.
Commit 648196d: Fix BigQueryInsertStatus bullet point descriptions

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.
- Fixes issue 3762
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

Commit f58fa79: Makes BigQueryRow.TimestampConverter accept pre 1970 dates. Fixes issue 4821.

Version 2.0.0-beta03, released 2020-03-30

Commit 7ab60e1: Fixes ReadPage and ReadPageAsync incorrect PageToken when starting again. Fixes issue 4678.

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:

Commit 3c900ed: Remove obsolete BigQueryResults constructor
Commit 21117b7: Fixes issue introduced in issue 4073.
Commit 3cadc8e: Modifies insert methods to return BigQueryInsertResults.
Commit 9a2f966: Adds BigQueryInsertResults which wraps the response obtained from insert attempts.
Commit a849e5c: Supports listing partial rows by specifying a partial table schema.
Commit a820034: Supports fetching a partial table schema when getting a table.
Commit 06e0d6e: Adds Model CRUD operations wrappers to BigQueryDataset and BigQueryModel.
Commit 38e755a: Adds some Model CRUD operations and supporting types.
Commit ade13ba: Support ParentJobId filtering when listing Jobs.
Commit ebeece5: Parse timestamp JSON values as decimal instead of double. Fixes issue 4031.

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:

Support for customer managed encryption (Cloud KMS)

Version 1.0.0, released 2017-12-07

Initial release.