PostgreSQL with jsonb?

I’m currently flattening jsonb stored in a Postgresql instance and sending it to S3, eventually pointing Rockset to that S3 instance.

Is there a way I could just point Rockset to the Postgresql instance so I don’t have to do extra work (flattening) with the data?

1 Like

HI @rahul

Does something like this help: PostgreSQL | Rockset Documentation – or are you looking for something different? Where are you running your postgres instance? IF you needed to flatten the data on Rockset- you can use:
→ UNNEST: Commands | Rockset Documentation
→ Here’s a blog I did that goes over it.


1 Like