KNOWLEDGE BASE

Error "The Google BigQuery service was unable to compile the query ... Unable to create extract" Refreshing BigQuery Extract


Published: 04 Mar 2015
Last Modified Date: 31 Aug 2016

Issue

When refreshing a Google BigQuery extract, the following error appears:

The Google BigQuery service was unable to compile the query.

The JOIN operator's right-side table must be a small table. Switch the tables if the left-side table is smaller, or use JOIN EACH if both tables are larger than the maximum described at http://goo.gl/wXqgHs.

Unable to create extract

Environment

  • Tableau Professional 
  • Google BigQuery
  • Incremental Extract

Resolution

Option 1:
One possible workaround is to fully refresh the extract. 

Option 2:
Use the attached .tdc file as a temporary workaround. 

Cause

This is a known issue currently under investigation.
Did this article resolve the issue?