Summary
The user is facing typecasting errors with numbers formatted with commas in the BingAds connector when loading data into Snowflake, causing NULLs in Snowflake. Looking for a workaround or solution.
Question
Hi everyone, 
I’m having an issue with the BingAds connector when loading data into Snowflake. Specifically, I’m having trouble with typecasting numbers in some columns. For instance, in the AllRevenue column of the campaign_performance_report_daily stream, numbers formatted with commas (e.g., 1,234.67) are causing typecasting errors, e.g.
source > Failed to transform value '2,223.06' of type 'string' to '['null', 'number']', key path: '.AllRevenue'
As a result, any revenue values above 999.99 are not being properly cast to floats, leading to NULLs in Snowflake.
Has anyone else faced this issue or found a workaround? Any help would be greatly appreciated! Thank you!
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.