How do I prevent leading zeros from being stripped in a column in my csv file that is uploaded to S3?

Matillion ETL
1

I have a job that is calling an API and downloading a report. The file type is CSV. The column should be five characters and is numeric and will sometimes have leading zeros. I know how to do this with a local file. But is there a setting in the S3 load component in Matillion to keep this from happening?

The data from the CSV file is then loaded into Snowflake.

 

Data example:

Coming out as 2

Should be 00002

 

2

Resolved!

I found a very simply solution. First, I updated the character limit for that column to 5 in landing table. Then I used the LPAD function in Snowflake for that column in the SQL Script step which already has other transformations.