When loading date or timestamp data into a table, you could encounter the following error:
Date '0000-00-00' is not recognized
One or more columns in your CSV file contains the special date or timestamp, 0000-00-00 or 0000-00-00 00:00:00. Snowflake does not currently support the special date or timestamp.
As a workaround, you could convert the special date or timestamp to a SQL NULL value on load.
COPY INTO <table> FILE_FORMAT=(NULL_IF = ('0000-00-00'));
All Snowflake clients