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


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

Unable to create extract


  • Tableau Professional 
  • Google BigQuery
  • Incremental Extract


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

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


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