Snowflake: how to truncate data if larger than column size while loading?

Question

How can I truncate the column data when it's size is greater than the column size while loading it into a Snowflake table. I am using file format to do COPY INTO as follows:

CREATE OR REPLACE FILE FORMAT 'schema."csv_file_format"'
                  TYPE = 'csv'
                  FIELD_DELIMITER = '\001'
                  NULL_IF = ('\\N', 'NULL', 'NUL', '')
                  COMPRESSION = 'AUTO';

COPY INTO schema.table_name
FROM @EXTERNAL_STAGE/s3_prefix
FILE_FORMAT = 'schema."csv_file_format"' ON_ERROR = 'CONTINUE' PURGE = TRUE;

Answer 1

There are copy options (ENFORCE_LENGTH, TRUNCATECOLUMNS) for CSV data

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#copy-options-copyoptions

Answer 2

For CSV files Snowflake provides column ordering, column omission using SELECT statement and setting TRUNCATECOLUMS=true|false in COPY command.

For more information refer Transforming Data during dataload