error: Table may not exist or is unsupported relation type code: 25350 context: query: 0 location: mysqlclient.cpp:255 process: padbmaster [pid=15091]

Question

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.

Answer 1

change the table name in lower case. It worked for me.

Answer 2

SET enable_case_sensitive_identifier TO true; and Columns names and table names should be in double quotes