Good day to you all!
I am struggling, when trying to send a NULL to be inserted in a cell, when using RedShift - any ideas how is could be done?
I can just copy the whole line, and leave the cells that should be NULL - blank , but searching for a more elegant way.
Thank You!
Hi @Patryk_Raczy and welcome to the Make Community!
I think you might be confusing Make’s null with the string “null”. “null” is a SQL key word so if you’re looking for that in your query, just type “null”. Don’t use the {{null}} placeholder from make. That actually equals the NULL character (0x0000) from the ASCII/Unicode table.
So delete the pink “null” in your module and replace it with the word “null” and that should give you what you want.
L
Hi,
Thank You, have tried that also - sadly, does not work. This “null” in not interpreted as “real” null in SQL.
As You can see here:
Hmm, I may have faulty memory of SQL queries.
I’m wondering whether the Amazon Redshift module deal empty values as ‘’ and null as ‘null’. If you can share the output that creates the SQL query, please do so. It’sll help to figure out what the module is doing.
Another thing you might try is to map the value. It’s possible that just using NULL with maps will prevent any string manipulation on the part of the module.
Unfortunately, I don’t see any useful documentation about that for the module.
L
