KNOWLEDGE BASE

NUMERIC Type BigQuery Fields Missing in Tableau Desktop


Published: 19 Jun 2018
Last Modified Date: 04 Sep 2018

Issue

When connecting to a Google BigQuery table that has columns of NUMERIC type, the NUMERIC fields and data do not appear in Tableau Desktop.

Environment

  • Tableau Desktop
  • Google BigQuery

Resolution

As a possible workaround, use Custom SQL to cast the NUMERIC field into another data type, for example INT or FLOAT. For more information, see Changing a Column's Data Type at BigQuery. 
 

Cause

BigQuery's NUMERIC type is currently not recognized by Tableau.

Additional Information

To voice your support for the inclusion of this enhancement in a future product release, add your vote to the following Community Idea: Support NUMERIC type from BigQuery.

 

 

Did this article resolve the issue?