When trying to create a connection for a new redsh...
# replication-ask-ai
d
When trying to create a connection for a new redshift source, I get this error "Discovering schema failed" with Internal message: java.lang.NullPointerException: null value in entry: isNullable=null
k
This error seems to be related to a known issue with the Redshift source connector in Airbyte. The error message "Discovering schema failed" with "java.lang.NullPointerException: null value in entry: isNullable=null" is associated with a problem when the schema contains at least one view "with no schema binding". In this case, the precondition scan fails with a NullPointerException (NPE) [source](https://github.com/airbytehq/airbyte/issues/25825). This issue also occurs when tables/views from a schema were synced successfully with Airbyte, and that view is newly added to the schema, effectively breaking that connection during the next pre-scan. A workaround suggested is to only use Airbyte on schemas which don't contain any views with no schema binding. Here are the steps to reproduce the issue: - Create a no schema binding view on any of the existing tables in your schema, e.g.
CREATE VIEW test_view AS SELECT * from test_table WITH NO SCHEMA BINDING;
- Tap "review changes" of an existing connection to review schema updates, or try creating a new source to that Redshift schema. If you're experiencing this issue, it might be helpful to follow or contribute to the discussion on the related GitHub issue [here](https://github.com/airbytehq/airbyte/issues/25825).