👋 Hello, team! today i have been trying to extract data from mysql and load to snowflake however the mysql source db has zero dates. Whats the best practice to handle these? I want to store them as NULL in snowflake but get the following error when i run

meltano run tap-mysql target-snowflake

2025-01-13T18:34:26.735619Z [info     ]     raise ValueError(msg)      cmd_type=elb consumer=True job_name=prod:tap-mysql-to-target-snowflake name=target-snowflake producer=False run_id=1a4a5a83-c0cb-4e7d-b96f-a6e8ad6ea8be stdio=stderr string_id=target-snowflake
2025-01-13T18:34:26.735688Z [info     ] ValueError: Could not parse value '0000-00-00' for field 'BurialDate'. cmd_type=elb consumer=True job_name=prod:tap-mysql-to-target-snowflake name=target-snowflake producer=False run_id=1a4a5a83-c0cb-4e7d-b96f-a6e8ad6ea8be stdio=stderr string_id=target-snowflake
2025-01-13T18:34:27.818518Z [error    ] Loader failed                 
2025-01-13T18:34:27.818827Z [error    ] Block run completed.           block_type=ExtractLoadBlocks err=RunnerError('Loader failed') exit_codes={<PluginType.LOADERS: 'loaders'>: 1} set_number=0 success=False

Hey @Peter Hart! You can probably use stream maps on the target's end to convert those values to

None

.