Error: Response Too Large To Return

Issue

The following error appears:

Response too large to return. Consider specifying a destination table in your job configuration

Environment

Connector: BigQuery

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your BigQuery connection page.
2. Select the Settings tab.
3. Click Edit connection.
4. Set the Use working dataset for queries toggle to ON.
5. Click Save & Test.

For more information, see Configure query results table.

Cause

This issue occurs when Fivetran runs a SQL import query that returns more than 10 GB of compressed data and no query results table is configured. Without a configured working dataset, BigQuery can't stage the large query results, so the query fails when the response exceeds the API payload limit.