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.
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.