I’m trying to build a Postgres source and I’m not able to see the list of tables when selecting a particular schema. Do we need to alter the schema in any way to be accessible by Airbyte? The

public

schema is accessible, but the data I want to copy resides in another schema.

2. Add user-level permissions We recommend using a user specifically for Airbyte's replication so you can minimize access. This Airbyte user for your instance needs to be granted `REPLICATION` and

LOGIN

permissions. You can create a role with

CREATE ROLE <name> REPLICATION LOGIN;

and grant that role to the user. You still need to make sure the user can connect to the database, use the schema, and to use

SELECT

on tables (the same are required for non-CDC incremental syncs and all full refreshes). https://docs.airbyte.com/integrations/sources/postgres/

Thank you for the quick response! I will try this out and get back to you if this doesn’t resolve it.

Hi @Sreeram Venkitesh, feel free to post on our forum if you need additional help on this topic.

Hi @Augustin Lafanechere (Airbyte)! We were able to solve this issue. The postgres user did not have the

REPLICATION

permission, which was causing the schemas to be empty. Thanks for all the help!

Glad you figured it out 🙂