We are trying to create a AWS Redshift EXTERNAL_SCHEMA from MySQL RDS but running into a strange problem. We followed the AWS instruction to create a Secret in Secret Manager with the RDS credentials and created an IAM user to access the Secret. We were able to get all the RDS table schema but we start running into problem when we try to query the data inside of the EXTERNAL_SCHEMA. The error we are running into shows that the table does not exist or is unsupported data type.
We tried turning on the enhanced VPC option but didn't have any luck and trying to see if anybody else ever ran into this problem.
Please let us know if anybody was able to solve this issue.