KNOWLEDGE BASE

Error "Bad int64 value" Using FLOAT() on a String field in Google BigQuery


Published: 24 Nov 2016
Last Modified Date: 13 Jan 2017

Issue

Using FLOAT () on a string field containing a decimal separator (ex: 12345.67), the following error occurs:
Bad int64 value 12345.67

Environment

  • Tableau Desktop 10.1
  • Google BigQuery

Resolution

Instead of:
FLOAT([DimensionName])
Use:
RAWSQL_REAL("CAST (%1 AS FLOAT64)", [DimensionName])
 

Cause

This behavior is related to a known issue which is currently under investigation.
Did this article resolve the issue?