Error creating AWS SSM parameter

We encounter a problem while trying to create a parameter in the SSM parameter store of AWS.

resource “aws_ssm_parameter” “database” {
name = “/DB_HOST”
description = “Name of the database”
type = “String”
value = aws_rds_cluster.aurora_serverless.database_name
}

The error we get during a terraform plan is:

Error: Invalid combination of arguments

│ with module.network.aws_ssm_parameter.database,
│ on …/…/modules/network/aurora.tf line 93, in resource “aws_ssm_parameter” “database”:
│ 93: resource “aws_ssm_parameter” “database” {

│ “insecure_value”: one of insecure_value,value must be specified


│ Error: Invalid combination of arguments

│ with module.network.aws_ssm_parameter.database,
│ on …/…/modules/network/aurora.tf line 97, in resource “aws_ssm_parameter” “database”:
│ 97: value = aws_rds_cluster.aurora_serverless.database_name

│ “value”: one of insecure_value,value must be specified

Did somebody encounter the same issue and maybe has a solution/workaround?
All help is welcome.