Apache.Arrow.Adbc.Drivers.BigQuery 0.15.0

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. .NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. 
dotnet add package Apache.Arrow.Adbc.Drivers.BigQuery --version 0.15.0                

                    
                

            
NuGet\Install-Package Apache.Arrow.Adbc.Drivers.BigQuery -Version 0.15.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="Apache.Arrow.Adbc.Drivers.BigQuery" Version="0.15.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Apache.Arrow.Adbc.Drivers.BigQuery --version 0.15.0                

                    
                

            
#r "nuget: Apache.Arrow.Adbc.Drivers.BigQuery, 0.15.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install Apache.Arrow.Adbc.Drivers.BigQuery as a Cake Addin
#addin nuget:?package=Apache.Arrow.Adbc.Drivers.BigQuery&version=0.15.0

// Install Apache.Arrow.Adbc.Drivers.BigQuery as a Cake Tool
#tool nuget:?package=Apache.Arrow.Adbc.Drivers.BigQuery&version=0.15.0

BigQuery

The BigQuery ADBC driver wraps a BigQueryClient object for working with Google BigQuery data.

Supported Features

Authentication

The ADBC driver supports both Service and User accounts for use with BigQuery authentication.

Authorization

The ADBC driver passes the configured credentials to BigQuery, but you may need to ensure the credentials have proper authorization to perform operations such as read and write.

Parameters

The following parameters can be used to configure the driver behavior. The parameters are case sensitive.

adbc.bigquery.allow_large_results<br>     Sets the AllowLargeResults value of the QueryOptions to true if configured; otherwise, the default is false.

adbc.bigquery.auth_type<br>     Required. Must be user or service

https://cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.V2/latest/Google.Cloud.BigQuery.V2.QueryOptions#Google_Cloud_BigQuery_V2_QueryOptions_AllowLargeResults

adbc.bigquery.client_id<br>     The OAuth client ID. Required for user authentication.

adbc.bigquery.client_secret<br>     The OAuth client secret. Required for user authentication.

adbc.bigquery.auth_json_credential<br>     Required if using service authentication. This value is passed to the GoogleCredential.FromJson method.

adbc.bigquery.get_query_results_options.timeout<br>     Optional. Sets the timeout (in minutes) for the GetQueryResultsOptions value. If not set, defaults to 5 minutes.

adbc.bigquery.max_fetch_concurrency<br>     Optional. Sets the maxStreamCount for the CreateReadSession method. If not set, defaults to 1.

adbc.bigquery.include_constraints_getobjects<br>     Optional. Some callers do not need the constraint details when they get the table information and can improve the speed of obtaining the results. Setting this value to "false" will not include the constraint details. The default value is "true".

adbc.bigquery.large_results_destination_table<br>     Optional. Sets the DestinationTable value of the QueryOptions if configured. Expects the format to be {projectId}.{datasetId}.{tableId} to set the corresponding values in the TableReference class.

adbc.bigquery.project_id<br>     The Project ID used for accessing BigQuery.

adbc.bigquery.refresh_token<br>     The refresh token used for when the generated OAuth token expires. Required for user authentication.

adbc.bigquery.scopes<br>     Optional. Comma separated list of scopes to include for the credential.

adbc.bigquery.use_legacy_sql<br>     Sets the UseLegacySql value of the QueryOptions to true if configured; otherwise, the default is false.

Type Support

There are some limitations to both C# and the C# Arrow implementation that limit how BigQuery data types that can be represented by the ADBC driver. For example, the BIGNUMERIC type in BigQuery does not have a large value equivalent to C#.

The following table depicts how the BigQuery ADBC driver converts a BigQuery type to an Arrow type.

BigQuery Type Arrow Type C# Type
BIGNUMERIC Decimal256 string
BOOL Boolean bool
BYTES Binary byte[]
DATE Date64 DateTime
DATETIME Timestamp DateTime
FLOAT64 Double double
GEOGRAPHY String string
INT64 Int64 long
NUMERIC Decimal128 SqlDecimal
STRING String string
STRUCT String+ string
TIME Time64 long
TIMESTAMP Timestamp DateTimeOffset

+A JSON string

See Arrow Schema Details for how BigQuery handles Arrow types.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on Apache.Arrow.Adbc.Drivers.BigQuery:

Repository Stars
apache/arrow-adbc
Database connectivity API standard and libraries for Apache Arrow
Version Downloads Last updated
0.15.0 66 11/13/2024
0.14.0 121 9/5/2024
0.13.0 126 7/5/2024
0.12.0 119 5/21/2024
0.11.0 158 3/31/2024