Hi,
I am working locally on the Analytics platform 4.6.3 with BigQuery extension 4.6.0 installed.
My goal is to bulk upload data to BQ using the DB loader node.
While this is working fine for strings, I am unable to get it working for numeric fields.
In the BQ Connector, mapping by type is set to
Number (double) → Double → Numeric
The corresponding field in the BQ table has data type: NUMERIC
When running the workflow, the console throws the error:
Execute failed: Consumption path could not be found from Number (double) through DECIMAL (INT64) to NUMERIC.
Any ideas how to solve this are highly appreciated!
Best, Ingo
Hello @ingo_g ,
can you please try and change the file format from Parquet to CSV. The DECIMAL database type is not supported using Parquet only INT64, FLOAT64, and NUMERIC.
Bye
Tobias
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.