Leading zeroes are lost in numeric fields

Snowflake-Labs / Excelerator

This is an Excel Addin for Windows that reads and writes data to Snowflake

Apache License 2.0

78 stars 22 forks source link

Leading zeroes are lost in numeric fields #11

Closed bkaehny closed 3 years ago

bkaehny commented 3 years ago

I put this issue on this youtube video: https://www.youtube.com/watch?v=csmS5V2ONr8&lc=UgzpYpaSWOgSNDvBMbJ4AaABAg.9IDpIqerYoJ9IxW74-QrC0&feature=em-comments

You lost the leading zeroes in your ZIP code in rows 33 and 34 on the initial SELECT *. Is there any way to prevent that from happening?

ssegal100 commented 3 years ago

Hi Brian. The leading zeros will not be lost if the column datatype in Snowflake is a string. In the example in the YouTube video, the datatype is a number, so that's why there are no leading zeros. In other words, the zip code in the table doesn't have the zeros. Does this answer your question? Thanks.

bkaehny commented 3 years ago

Yes, that answers my question. Thanks!