adswerve/target-bigquery

Remove hard-coded FLOAT for numeric types

Closed this issue · 1 comments

I mentioned this issue in the RealSelf repo but figured I'd post here as well in case there is more traction. At current it does not appear to be possible to have an output that uses numeric instead of float data types - this is ok for some applications but a critical bug for places where accuracy is important due to the nature of issues involving floating point precision. It would be great if it were possible to change to using NUMERIC data types in some way, although I'm not sure what all it would take to make that configurable.

Thank you for a great idea!
We have added this functionality to this branch and will be added to the next release.

Your JSON schema should be formatted like this:
"deci": { "type": "string", "format": "bq-decimal" }