search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
16.24k stars 4.15k forks source link

[source-redshift] error when fetching the schema of my data source #48533

Open Kamaradeivanov opened 4 days ago

Kamaradeivanov commented 4 days ago

Connector Name

source-redshift

Connector Version

0.5.2

What step the error happened?

Other

Relevant information

Creation of the data source is ok but I can't configure a connexion be cause an error occurs when fetching the schema of my data source.

I have a limited account user and can't grant more access. My schema has no table, only views. I was using Daton and want to switch to airbyte but this error is blocking me.

I suppose that the following function trigger my error : https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/source-redshift/src/main/java/io/airbyte/integrations/source/redshift/RedshiftSource.java#L113

Relevant log output

Internal message: java.sql.SQLException: [Amazon](500310) Invalid operation: permission denied for relation pg_tables;
Failure type: system_error

Contribute

marcosmarxm commented 3 days ago

@airbytehq/dbsources can someone take a look into this issue?