Some tables are missing when I do a

refresh source schema

. Is this a bug or how can I ensure all the tables from the

source

are loaded into the

destination

I specified? The source is a PostgreSQL DB running on Amazon RDS.

Hi @Oluwapelumi Adeosun, could you please share which version of the postgres connector you are using? Are the missing tables views or materialized views?

Thanks for the response @Augustin Lafanechere (Airbyte) I'm using the latest postgres connector version: 0.4.9 The missing tables are actual tables from the database not views.

@Oluwapelumi Adeosun if you downgrade to 0.4.4 are you able to see the tables?

No, i still couldn't. I've tried 0.4.5 and 0.4.6 too. @Marcos Marx (Airbyte)

@Oluwapelumi Adeosun could you check the database adm and check those tables permissions if are the same as the one Airbyte was able to get in the discovery?

Thank you @Marcos Marx (Airbyte) Turned out that Select Access was not granted to the DB user I used in those tables. It's discovering all tables now that they've been updated.