Redshift source does not list views

Connector Questions & Issues
1
  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: Ubuntu
  • Memory / Disk: 32Gb / 100 GB
  • Deployment: Docker
  • Airbyte Version: 0.35.64-alpha
  • Source name/version: Redshift (0.3.10)
  • Destination name/version: Postgres (0.3.20)
  • Step: Fetching the schema

Hi, I want to replicate a view from Redshift to Postgres but when the redshift source fetch the source schema the views doe snot appear only the materialized tables. I think this could be a kind of bug.

2

I’m using Redshift 0.3.10 to Postgres 0.3.20

And was able to see views in my connection. Can you confirm you have the right permissions?

3

Thanks @marcosmarxm

I check and when I define the schema in the source it only shows the tables that are materialized.

I leave it empty and then use the search stream tab and appears all the views.

4

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.