google-cloud-platformgoogle-bigquerygoogle-cloud-data-fusioncdapwrangler

Cloud Data Fusion: Numeric datatype into BigQuery

I'm running a Data Fusion pipeline with Wrangler transformations and I want to store a value as Numeric in BigQuery for some precise arithmetic calculations, but Wrangler doesn't let me transform a FLOAT value to NUMERIC.

I've tried with implicit conversion trying to write a FLOAT value into a NUMERIC column inside BQ but that didn't work.

Is there a workaround for this?

Thanks!

Solution

  • You can convert the value to a decimal datatype which maps to the bigquery NUMERIC datatype. Documentation here.