Add support for the Redshift Data Api.

[Javier162380]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or other comments that do not add relevant new information or questions; they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

Redshift release on October their data API. https://docs.aws.amazon.com/sdk-for-go/api/service/redshiftdataapiservice/. It comes with the possibility to interact with Redshift via HTTP and Authenticate with the cluster using IAM Roles purely. I will like to create a module to create schemas, users, and groups using this API. We could control this way in code all these operations. It is something that traditionally I have been controlled using SQL scripts.

Something similar to the BQ module will be awesome in this case https://registry.terraform.io/providers/hashicorp/google/latest/docs/resources/bigquery_dataset_iam.

New or Affected Resource(s)

• aws_XXXXX

Potential Terraform Configuration

resource "aws_redshift_user" "user" {
 user = "name"
 password = "password"
 extrapropeties = ""
}

resource "aws_redshift_group" "group" {
   name = "name"
   members = [ "user1", "user2"]
}

resoure "aws_redshift_schema" "schema" {
  name = "name"
  view {
     members = ["group1", "group2", "group3"]
  }
  write {
    members = ["group1", "user2"] 
 }
  owner = "user"
}

References

• #0000

[DrFaust92]

As there are no direct APIs to manage the above, #25104 takes care of this (in a way)

[github-actions]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.
If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.