Error on external schema creation

[mdimas]

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".

[mdimas]

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.

[sudhirmishra]

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 https://github.com/brainly/terraform-provider-redshift/blob/785455d972e902ea934d504a63e666b17e0cdc4a/redshift/resource_redshift_schema.go#L482

[Olaktal]

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

[juanjesus-jeeves]

Also reproducing the issue here. Will appreciate any help.