Destination Improvement: Support JSONB for Postgres
Currently, you do not support JSONB for Postgres:
https://fivetran.com/docs/destinations/postgresql#typetransformationmapping
JSONB has many great features. For example, it allows you to make indices on the columns:
CREATE INDEX idxgintags ON api USING gin ((jdoc -> 'tags'));
This is super helpful if you often do a `where` on your JSONB columns.
It shouldn't be much of a lift because Postgres converts from JSON to JSONB for you automatically.
Thanks!
Please sign in to leave a comment.
Comments
0 comments