I’m doing a bulk insert into a BigQuery table using a BigQuery resource. I have a currency amount, that is represented as “amount” with datatype “NUMERIC” in my BigQuery table schema.
When I run my Retool BigQuery bulk insert query, I get the following error: “Value has type FLOAT64 which cannot be inserted into column amount, which has type NUMERIC at [1:335]”
I have parsed this string out of a table using
Number() but have also tried
parseFloat(). AFAIK Numeric specifically supports FLOAT64. Is there something I’m missing? Is there some issue with Legacy vs. Standard SQL?