[New]: create-db-shard-group terraform resource required for Aurora PostgreSQL limitless clusters

[humerarehman]

Description

The AWS CLI currently supports the create-db-shard-group operation for configuring shard groups in Aurora PostgreSQL limitless clusters. However, the Terraform AWS provider does not provide native support for this functionality. This feature is required so users can provision Aurora PostgreSQL RDS cluster with Limitless, which provides sharding capability for scalable database workloads. The lack of Terraform support requires users to rely on manual AWS CLI or SDK calls, which disrupts the Infrastructure-as-Code workflow.

Adding this resource to the Terraform AWS provider will enable users to fully automate the provisioning and management of Aurora PostgreSQL limitless clusters with sharding capabilities.

Requested Resource(s) and/or Data Source(s)

Resource Name: aws_rds_db_shard_group

Potential Terraform Configuration

resource "aws_rds_db_shard_group" "example" {
  name        = "my-shard-group"
  description = "Shard group for limitless Aurora PostgreSQL"
  subnet_group_name = aws_rds_db_subnet_group.example.name
  region      = "us-east-1"
}

resource "aws_rds_cluster" "example" {
  cluster_identifier      = "example-cluster"
  engine                  = "aurora-postgresql"
  engine_version          = "15.2"
  db_subnet_group_name    = aws_rds_db_subnet_group.example.name
  shard_group_name        = aws_rds_db_shard_group.example.name
  cluster_scalability_type = "limitless"
  scaling_configuration {
    min_capacity = 0.5
    max_capacity = 64
  }
  master_username         = "admin"
  master_password         = "securepassword"
  vpc_security_group_ids  = [aws_security_group.example.id]
  storage_encrypted       = true
}

References

AWS CLI Documentation: create-db-shard-group
AWS RDS Aurora Limitless: Documentation: https://aws.amazon.com/blogs/aws/amazon-aurora-postgresql-limitless-database-is-now-generally-available/

Would you like to implement a fix?

None

[github-actions]

Community Note

Voting for Prioritization

• Please vote on this issue by adding a 👍 reaction to the original post to help the community and maintainers prioritize this request.
• Please see our prioritization guide for information on how we prioritize.
• 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.

Volunteering to Work on This Issue

• If you are interested in working on this issue, please leave a comment.
• If this would be your first contribution, please review the contribution guide.

[ewbankkit]

Depends on #41002:

aws_rds_cluster.example: Creating...
╷
│ Error: creating RDS Cluster (ewbankkit-test-001): operation error RDS: CreateDBCluster, https response error StatusCode: 400, RequestID: 774d84b5-0e0c-495a-b7b0-6676b38e7b9b, api error InvalidParameterCombination: You must set the Enhanced Monitoring interval to a value larger than 0 when Aurora Limitless Database is enabled on the DB cluster.
│ 
│   with aws_rds_cluster.example,
│   on main.tf line 4, in resource "aws_rds_cluster" "example":
│    4: resource "aws_rds_cluster" "example" {
│ 
╵