How do I preserve leading zeros in a seed?
If you need to preserve leading zeros (for example in a zipcode or mobile number):
- v0.16.0 onwards: Include leading zeros in your seed file, and use the
column_types
configuration with a varchar datatype of the correct length. - Prior to v0.16.0: Use a downstream model to pad the leading zeros using SQL, for example:
lpad(zipcode, 5, '0')
0