Hello all, Is anyone using Redshift as source and have issues to establish connection?

Hello, It seems that several users have experienced issues when using Redshift as a source in Airbyte. Here are some common problems and potential solutions based on the information available: 1. Schema Discovery Issues: - Issue: Users have reported that schema discovery fails even when the source connection succeeds. - Example: [Forum Post: Redshift Source Discovering schema failed](https://discuss.airbyte.io/t/2979) - Solution: Ensure that the user has the necessary read permissions on the cluster/database/schema. Additionally, try specifying a specific schema in the source configuration. 2. Fetching Source Schema: - Issue: The source test connection succeeds, but fetching the schema fails. - Example: [Forum Post: Redshift source "Failed to fetch schema"](https://discuss.airbyte.io/t/2548) - Solution: Verify that the user has read permissions. Increasing the size of the disk running the Airbyte server might help. Check the logs for more details on the error. 3. Null Pointer Exception (NPE) for Views with No Schema Binding: - Issue: Users have encountered NPEs when using views with no schema binding. - Example: [Github Issue: source-redshift NPE for view with no schema binding](https://github.com/airbytehq/airbyte/issues/25825) - Solution: This issue persists in multiple versions. It might be helpful to follow the issue on GitHub for updates or try using a different version of the connector. 4. Connection Issues with Redshift Serverless: - Issue: Difficulty connecting to Redshift Serverless. - Example: [Forum Post: Destination-Redshift: Destination not connecting for the Redshift Serverless data warehouse](https://discuss.airbyte.io/t/1567) - Solution: Ensure that the inbound rule to allow access to the default port (5439) is set in the security group attached to the Workgroup. 5. General Sync Issues: - Issue: Errors during the sync process. - Example: [Github Issue: Platform Issue: Redshift source connector](https://github.com/airbytehq/airbyte/issues/25513) - Solution: If you encounter a null pointer error with a specific version, try using a different version of the connector that is known to work. If you continue to face issues, it might be helpful to check the logs for more detailed error messages and share them on the Airbyte forums or GitHub issues page for further assistance. For more detailed troubleshooting, you can refer to the specific forum posts and GitHub issues linked above. Hope this helps! If you have any more questions or need further assistance, feel free to ask.