Connection creation stuck at schema discovery with the Redshift source connector

[jzhang-georgian]

Hi,

I'm creating a connection with a Redshift source connector and a BigQuery destination connector. I'm able to connect with the Redshift data source but the connection creation is just stuck at schema discovery, even after I limited the schemas to only one.

System info:
Redshift connector: v0.4.0
BigQuery connector: v2.3.18
Airbyte version: latest as of writing (v0.50.35)

One theory:
The table in Redshift is an external table based on data files in S3. Would this cause any issue during schema discovery (like it has to read through all the files to understand the schema)?

There is no log on the UI I can see on what's happening either. Where can I find the logs for schema discovery issues in Airbyte?

Thank you!