Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
pbell-landing
Contributor
Contributor

JSON vs JSONB Data Type

I use Stitch to load data from a PostgreSQL database to Snowflake. One of my data tables has a JSON field, and is being classified as JSON data type in Stitch. However, I have a lot of values that are non null in the PostgreSQL database that are null once loaded into Snowflake (about 80% are null when I know a value exists). Would this be resolved if the field was instead classified as JSONB?

Labels (1)
0 Replies