Is this your first time deploying Airbyte
yes
OS Version / Instance
Mac
Memory / Disk
32G/1T
Deployment
docker
Airbyte Version
v0.35.28-alpha
Source name/versionPostgres 9.6.13Destination name/versionPostgres 13Step
Setting up the connection
DescriptionHi all - i’m trying to setup connection between one postgres and another and my source postgres only has views (no tables - it’s long story) im reading the postgres docs and it says it supports replicating views but under the “Select the data you want to sync” there are no rows so doesnt seem to be picking anything up even though it can successfully connect to the database and when i connect as well in a different program I can see the views / query them. Any idea what might be up?
o
Ofek Katriel
02/21/2022, 6:19 PM
Hi @Ross Nordeen, I confirm that our connector can read views. Could you double check the postgres user you're using with the connector has read permissions on these views? The connector does not list table/views it can't read.
v
Vinod Varma
02/21/2022, 9:01 PM
Yep 100% can read the views, I am reading them with same user in different sql editor tool
Vinod Varma
02/21/2022, 9:02 PM
Is there some kind of debugging can put on to see where it's getting stuck?