BizTalk Adapter for Google BigQuery

Build 20.0.7654

UseArrowFormat Property

Specifies whether to use the Arrow format with BigQuery's Storage API.

Data Type

Boolean

Default Value

false

Remarks

This property only has an effect when RSBGoogleBigQuery_p_UseStorageAPI is enabled. When performing reads against the Storage API, the adapter can request data in different formats. By default it uses Avro but enabling this option makes it use Arrow.

This option should be enabled when working with time series data or other datasets that have many date, time, datetime or timestamp fields. For these datasets using Arrow can have noticable improvements over using Avro. Otherwise Avro and Arrow read times are very close and switching between them is unlikely to make a significant difference.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654