Hey everyone, I recently swapped from using the transferwise tap-postgres and transferwise target-snowflake to the respective meltanolabs variants, but if a column in a table has only empty arrays

[ ]

and we're doing a full table sync then the meltanolabs target-snowflake is loading this whole column as

true

. If the column has a mixture of empty and non-empty arrays, it reads it through fine. Just seems to be the case when the column only has empty arrays. Is this a known issue? Is there a config I might be missing somewhere?

smells like a bug. It sounds a lot like what led us to make https://github.com/MeltanoLabs/tap-postgres/blob/main/tap_postgres/client.py#L75 If you could build a way to replicate this out and put an issue in we could point you to the right place/way to fix this.

Got it, and we'd want to open this against the meltanolabs target-snowflake? Using the meltanolabs tap-postgres with transferwise target-snowflake does not have the same issue (empty arrays come over as expected).

idk it depends on how you replicate it