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

Remarks

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.