KNOWLEDGE BASE

Error "The query is too large. The maximum standard SQL query length is 1024.00K characters, including comments.”


Published: 31 May 2021
Last Modified Date: 01 Jun 2021

Issue

When adding a calculated field to a view, the following error may occur:

The query is too large. The maximum standard SQL query length is 1024.00K characters, including comments.

Environment

  • Tableau Desktop
  • Google BigQuery

Resolution

As a possible workaround, use an extract instead of a live connection to the data source.

Cause

Google imposes a limit of 1 MB for standard SQL query length in Google BigQuery.
Did this article resolve the issue?