[HOP-4605] Postgres Bulkloader should support bulkloading boolean values.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.1.0, 2.2.0
• Fix Version/s: Migrated to GHI
• Component/s: Transforms
• Assignee: Unassigned
• Reporter: Brandon Jackson
• Created: 17/Nov/22 20:24
• Updated: 09/Feb/23 12:47
• Resolved: 09/Feb/23 12:47

Description

From talking with people on Hop's Mattermost chat, the Postgres Bulkloader needs the users to take their existing boolean columns and cast them into strings with Y/N values when outputting to a destination table with a boolean column within Postgress.

 

If that is true, a good improvement would be to transparently convert those for users in the bulk loader step which would avoid extra Select Transforms on canvas or other acrobatics from them in the stream.

 

https://www.postgresql.org/docs/current/sql-copy.html