Error on external schema creation

Creating a redshift_schema resource with an rds_mysql_source block successfully creates the schema, but then fails with the error "Unsupported source database type unknown".

It looks like the cause of the problem is that and rds_mysql_source is expected to have eskind = 7

WHEN eskind = 7 THEN 'rds_mysql_source'

However, when you query svv_external_schemas you'll see that the eskind is 8.

It looks like the cause of the problem is that and rds_mysql_source is expected to have eskind = 7
WHEN eskind = 7 THEN 'rds_mysql_source'
However, when you query svv_external_schemas you'll see that the eskind is 8.

based on the amazon document https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_EXTERNAL_SCHEMAS.html
8 indicates a schema for remote MySQL databases, there is nothing assigned to number 7, which previously might have been remote MySQL databases

the code which makes use of this mapping

terraform-provider-redshift/redshift/resource_redshift_schema.go

Line 482 in 785455d

WHEN eskind = 7 THEN 'rds_mysql_source'

Hello
We have the same issue, do you have any time where this issue will be fixed ? 🙏
Thanks

Also reproducing the issue here. Will appreciate any help.