View jsonb data from postgres database

Ask a question
1

Hi,

I have a postgreSQL DB that has 2 columns that contain jsonb data - when this data pulls through into parabola I am only able to see [object][object] not the data itself. Is there a reason for this?

This is what i see in Parabola

image
image2362×1162 134 KB

This is what I see in my database:

image
image1212×364 20.1 KB

Thanks!

2

Hey @Victoria_Davies!

This definitely seems unusual. Try using an Expand JSON step to flatten that column into new rows. It may not return what you’re looking for, but that’s a good place to start.

Can you confirm if the OrderData value contains an array of delivery addresses, or is it a single address?

Let me know, and I can look into this further!