AWS Compute Optimizer
BetaThis source is currently in beta. It works end to end, but you may still hit rough edges. Let us know if you do.
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect AWS Compute Optimizer to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Sync AWS Compute Optimizer recommendations for the connected account in one AWS region.
Enable Compute Optimizer for this account before you sync.
Grant compute-optimizer:GetEnrollmentStatus to check enrollment.
Grant these permissions for the tables you select:
compute-optimizer:GetEC2InstanceRecommendationscompute-optimizer:GetAutoScalingGroupRecommendationscompute-optimizer:GetLambdaFunctionRecommendationscompute-optimizer:GetECSServiceRecommendationscompute-optimizer:GetEBSVolumeRecommendationscompute-optimizer:GetRecommendationSummariescompute-optimizer:GetRDSDatabaseRecommendationscompute-optimizer:GetIdleRecommendationscompute-optimizer:GetEC2RecommendationProjectedMetrics(also needsGetEC2InstanceRecommendations)compute-optimizer:GetECSServiceRecommendationProjectedMetrics(also needsGetECSServiceRecommendations)
Each sync replaces the current recommendations. This source does not keep recommendation history.
Configuration
| Option | Description |
|---|---|
AWS access key IDType: text Required: True | |
AWS secret access keyType: password Required: True | |
AWS session tokenType: password Required: False | Required for temporary credentials. Update the credentials before the token expires. |
AWS regionType: text Required: False | Sync recommendations from this region. The default is us-east-1. |
Linking AWS Compute Optimizer to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select AWS Compute Optimizer
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
ec2_instance_recommendations | EC2 instance recommendations with utilization metrics and estimated savings. | Full refresh | — | — |
auto_scaling_group_recommendations | Auto Scaling group recommendations with configuration options and estimated savings. | Full refresh | — | — |
lambda_function_recommendations | Lambda function recommendations with memory options and estimated savings. | Full refresh | — | — |
ecs_service_recommendations | ECS service recommendations with CPU, memory, and estimated savings. | Full refresh | — | — |
ebs_volume_recommendations | EBS volume recommendations with configuration options and estimated savings. | Full refresh | — | — |
rds_database_recommendations | Aurora and RDS database recommendations for instance classes and storage, with estimated savings. | Full refresh | — | — |
idle_recommendations | Idle resources across resource types, with utilization metrics and estimated savings. | Full refresh | — | — |
ec2_recommendation_projected_metrics | Daily peak CPU and memory utilization projected for each recommended EC2 instance type. | Full refresh | — | — |
ecs_service_recommendation_projected_metrics | Daily peak CPU and memory utilization bounds projected for each recommended ECS service size. | Full refresh | — | — |
recommendation_summaries | Counts of optimization findings and estimated savings by account and resource type. | Full refresh | — | — |