Does anyone know for the postgres to snowflake connectoin if it's supposed to deliver empty strings as null or

''

?

Hi Kyle! I think this is pertinent to how Snowflake works. They talk about this in the docs: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html#empty-strings-and-null-values An empty string is a string with zero length or no characters, whereas NULL values represent an absence of data. In CSV files, a NULL value is typically represented by two successive delimiters (e.g.

,,

) to indicate that the field contains no data; however, you can use string values to denote NULL (e.g.

null

) or any unique string. An empty string is typically represented by a quoted empty string (e.g.

''

) to indicate that the string contains zero characters. So I guess an empty string would be

''

because it is not a NULL value

hey @Nataly Merezhuk (Airbyte) thanks for the follow up! There is an option to treat

EMPTY_FIELD_AS_NULL = TRUE

as a part of the unload. Is there a way to set this up within Airbyte?

No there is not. Please open a feature request on GitHub! :) I'm sure this would be useful to many other users. If you'd have time to contribute a PR, that would be great too!