Issue
When using custom SQL to cast a NUMERIC field to STRING, the following error may occur:
The Google BigQuery service was unable to compile the query.
Error Code: 9F80FB23
Invalid date: '01/01/2020'
Last Modified Date: 08 Jul 2022
Environment
- Tableau Desktop
- Google BigQuery
Resolution
As a possible resolution, try casting the NUMERIC field to INT64 or FLOAT64 instead of STRING.Cause
Casting the NUMERIC field to STRING may result in a query for a calculated field that contains the invalid date.Additional Information
Standard SQL Data Types (BigQuery documentation)Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials