Enable Advanced Database Insights using CloudFormation

Hello.

Included in "AWS::RDS::DBCluster".
This can be set using the parameter "DatabaseInsightsMode".
Enabling Performance Insights as per the answer in AWS re:Post Agent does not enable Advanced Database Insights.
As of March 2025, it may not be possible to set it up using just "AWS::RDS::DBInstance". (I'll try doing some testing.)
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-rds-dbcluster.html

While CloudFormation doesn't have a direct property for enabling Advanced Database Insights, you can achieve this by configuring Performance Insights with specific settings in your CloudFormation template for your RDS instances.

To enable Advanced Database Insights using CloudFormation, you need to set the following properties for your AWS::RDS::DBInstance resource:

1. Enable Performance Insights by setting 'EnablePerformanceInsights' to true.
2. Set the 'PerformanceInsightsRetentionPeriod' to at least 465 days (which is approximately 15 months, the minimum for Advanced mode).

Here's an example of how you might configure this in your CloudFormation template:

MyDBInstance:
  Type: AWS::RDS::DBInstance
  Properties:
    Engine: postgres
    # ... other properties ...
    EnablePerformanceInsights: true
    PerformanceInsightsRetentionPeriod: 465

By setting these properties, you're effectively enabling the Advanced mode of Database Insights. The key is the retention period of at least 465 days, which is a characteristic of the Advanced mode.

Remember that enabling Advanced Database Insights will incur additional costs, as it provides extended data retention and advanced features compared to the Standard mode.

If you're updating existing instances, you may need to modify your CloudFormation template and update your stack. Be aware that changing these settings might require some downtime for your RDS instances.

Also, ensure that your IAM roles have the necessary permissions to enable and use Performance Insights and Database Insights features.
Sources
Turning on the Advanced mode of Database Insights for Amazon RDS - Amazon Relational Database Service
Turning on the Advanced mode of Database Insights for Amazon Aurora - Amazon Aurora
Get started with CloudWatch Database Insights - Amazon CloudWatch