Data format issue with Monetary values in Google and Facebook connectors
Planned
Monetary values have been set to FLOAT types in snowflake. Currency amounts should not be stored as floats due to precision.
field like cost, cost_per_click, using data type Float while landing the data in snowflake.
it would be much helpful if it updates the data with precision like Number(38,2).
For both Google Ads and facebook ad connectors.
-
Official comment
Hi Samanth, Drew from the Product team here. Thanks so much for raising this issue.
We are currently investigating this issue. We realize that we are delivering currency values in micros in our metadata tables, so this certainly seems like an issue that needs to be fixed.
I've sent you a follow-up email with a request for more information.
Please sign in to leave a comment.
Comments
1 comment