Skip to main content

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.

Be the first to reply!

Reply