Metadata:
AWS::CloudFormation::Interface:
ParameterGroups:
- Label:
default: Tags
Parameters:
- TagService
- TagName
- TagEnvironment
- TagCreatedBy
- TagContactNetId
- TagAccountNumber
- TagSubAccount
- TagResourceFunction
Parameters:
TagService:
Description: Service name (from the service catalog) that is utilizing this resource
Type: String
TagName:
Description: Descriptive identifier of resource.
Type: String
TagEnvironment:
Description: Type of environment that is using this resource, such as 'dev', 'tst', 'prd'.
Type: String
TagCreatedBy:
Description: NetID of the user that created this resource
Type: String
TagContactNetId:
Description: NetID of the person to contact for information about this resource
Type: String
TagAccountNumber:
Description: Financial system account number for the service utilizing this resource
Type: String
TagSubAccount:
Description: Financial system subaccount number for the service utilizing this resource
Type: String
TagResourceFunction:
Description: Human-readable description of what function this resource is providing
Type: String
Resources:
KFSParameterGroup:
Type: "AWS::RDS::DBParameterGroup"
Properties:
Family: oracle-ee-12.1
Description: KFS RDS Parameter Group
Parameters:
open_cursors: 500
audit_trail: DB
processes: 1200
Tags:
-
Key: service
Value: !Ref TagService
-
Key: Name
Value: !Ref TagName
-
Key: environment
Value: !Ref TagEnvironment
-
Key: createdby
Value: !Ref TagCreatedBy
-
Key: contactnetid
Value: !Ref TagContactNetId
-
Key: accountnumber
Value: !Ref TagAccountNumber
-
Key: subaccount
Value: !Ref TagSubAccount
-
Key: resourcefunction
Value: !Ref TagResourceFunction
Outputs:
DBOptionGroup:
Value: !Ref KFSParameterGroup
Export:
Name: !Sub "${AWS::StackName}-DbParamGroup"
This CloudFormation will create an RDS Option Group for use with the KFS database. The KFS requires an option group with the option of 'TIME_ZONE' set to 'America/Phoenix'.