Hey all, I made a connection between Postgres (source) and Snowflake (dest.). The sync says it's successful, but then doesn't show any schemas/tables? I made sure not to specify a specific schema in the connection so that all would be grabbed by default. Any ideas why? Is there a certain level of permissions my user needs on the postgres side?

Can you share the Connection Settings Page where you’d selected tables and the sync mode?

Oh I see that in the documentation: "You need a Postgres user with the following permissions: • can create schemas e.g: • can create tables and write rows. " So I cannot use a 'read_only' user?

Unfoternatly no 😞 there is an issue requesting improvements in those permissions

Wanted to follow up on this - I’m looking at the Postgres documentation and it says that we can use a read_only user but I’m running into the same issue as Connor where nothing is showing up in the sync.

James, if you figure this out, please say so here 😆

I will for sure. It used to work with read_only users (in fact, the Postgres -> Snowflake connection we have in Airbyte Cloud is set up with read_only credentials. Data is still syncing but no idea if it will someday randomly break.)

@Boaz Arbel turned this thread into a ticket to ensure timely resolution!