search

transferwise / pipelinewise-target-redshift

Singer.io Target for Amazon Redshift - PipelineWise compatible
https://transferwise.github.io/pipelinewise/
Other
12 stars 65 forks source link

Null JSON columns result in literal 'null' string #60

Open Limess opened 4 years ago

Limess commented 4 years ago

Expected

When a column is of type jsonb but has an empty record, the output in Redshift is a NULL (or empty depending on the COPY handling) column

Actual

When a column is of type jsonb but has an empty record, the output in Redshift is the string null