Forum Discussion

amubeen's avatar
amubeen
New Contributor II
5 years ago

Loading Null values into Snowflake DB via Bulk Load Snap

Hey All, So I’m trying to load certain columns from a csv file into snowflake, but facing some issues. I have the file, properly parsed it via the csv parser, and I’ve also used a mapper to map t...
igormicev's avatar
igormicev
Contributor
5 years ago

Hi @amubeen,

You’d better use multiple checks when it comes to nulls from csv file. It can be an empty string, or NULL or null or Null or (null), , etc.

One way is this:
($NULLABLECHAR == ““ || $NULLABLECHAR.toLowerCase().indexOf(‘null’) > -1) ? null : $NULLABLECHAR

However, settings can help you also, but if you fully trust the csv incoming data (e.g. always having null, but not (null) which is different)

/Igor