KNOWLEDGE BASE

NUMERIC Type BigQuery Fields Missing in Tableau Desktop


Published: 19 Jun 2018
Last Modified Date: 02 Jan 2019

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.
Did this article resolve the issue?