BizTalk Adapter for Google BigQuery

Build 20.0.7654

DestinationTable Property

DestinationTable is entered in the format DestinationProjectId:DestinationDataSet.TableName. Setting DestinationTable allows the query to return very large result sets (more than 128mb of result data) to a permanent destination table.

Data Type


Default Value



Queries that return large results will take longer to execute, even if the result set is small, and are subject to additional limitations:

  • A resultset destination table will be created.
  • You cannot specify a top-level ORDER BY clause.
  • Large data volumes cannot use the TOP function.
Note: The default write mode for this table is WRITE_TRUNCATE, so each query will drop the existing table and write the new result set. It is suggested each connection has a different DestinationTable specified.

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