Support for jsonb columns in v3 PostgreSQL source connector

Summary

The user is facing issues with jsonb columns in v3 PostgreSQL source connector, as the columns are coming across as type ‘string’ instead of ‘object’ in the streams, causing problems on the destination end. The user is inquiring about the current support status for this feature and if there is a way to resolve the issue.


Question

I’m trying to get jsonb columns working with v3 postgresql source. (I last tried to get this working on v1, and had to build a custom connector.) Is that support still missing? I’m seeing those columns come across as type “string” instead of “object” in the streams, which is causing issues on the destination end. is there still an issue to help resolve this? I didn’t see an open one. or is there a way to get it working correctly today?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["jsonb-columns", "v3-postgresql-source-connector", "data-type", "object-type", "destination-issues"]