Skip to content
This repository has been archived by the owner on Jan 17, 2025. It is now read-only.

Error on external schema creation #128

Open
mdimas opened this issue Sep 12, 2023 · 4 comments · May be fixed by #131
Open

Error on external schema creation #128

mdimas opened this issue Sep 12, 2023 · 4 comments · May be fixed by #131

Comments

@mdimas
Copy link

mdimas commented Sep 12, 2023

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
Copy link
Author

mdimas commented Sep 12, 2023

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
Copy link

sudhirmishra commented Nov 8, 2023 •
edited
Loading

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'

@sudhirmishra sudhirmishra linked a pull request Nov 8, 2023 that will close this issue
Open
@Olaktal
Copy link

Olaktal commented Nov 20, 2023

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

@juanjesus-jeeves
Copy link

Also reproducing the issue here. Will appreciate any help.

StevenKGER pushed a commit to dbsystel/terraform-provider-redshift that referenced this issue Oct 25, 2024
@mmichaelb
Merge pull request brainly#128 from mmichaelb/renovate/actions-checko…
f786672 
…ut-digest

Update actions/checkout digest to 0ad4b8f
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Update resource_redshift_schema.go sudhirmishra/terraform-provider-redshift
4 participants
@mdimas @sudhirmishra @Olaktal @juanjesus-jeeves