Hello - I’m having an issue with the snowflake connector. We set up a test for the snowflake integration, and it’s working as designed so far. The issue I’m running into is that all numbers are coming in with a decimal point, and a zero at the end.
We’ve tried changing the data in Snowflake, but it doesn’t matter. I don’t have the option to fix this this like I would have in a rules engine with an S3 file. The only “transform” i can do is with case expressions.
Any ideas?
Example: 1234567 is coming in as 1234567.0. We are loading into a string field as well, to prevent any commas in our numbers.