Forum Discussion
smanoharan
5 years agoEmployee
@amubeen There are two ways that you can handle this use case
- Leave the fields you want to loaded as null as Empty in the csv file and un-select the property, “Load empty strings” in Snowflake Bulk Load. This will make sure Snowflake Bulk Load will load the empty values as null in the table
2.The null values coming from a csv parser will be a string. A condition in the mapper to convert the null String values to null will work:
$NULLABLECHAR == “null” ? null : $NULLABLECHAR
cc: @robin
smanoharan
5 years agoEmployee
@amubeen Were you able to resolve your issue with the above information ?