AWS Savings Plans

AWS Savings Plans

Beta
Beta release

This 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.

Learn more
PostHog Wizard hedgehog

Connect AWS Savings Plans to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Sync Savings Plans, rates, commitment use, coverage, and purchase recommendations into the PostHog Data warehouse. Grant savingsplans:DescribeSavingsPlans for plan inventory. Grant ce:GetSavingsPlansUtilization for daily utilization. Grant ce:GetSavingsPlansUtilizationDetails for utilization details. Grant ce:GetSavingsPlansCoverage for daily coverage. Grant savingsplans:DescribeSavingsPlansOfferings for offerings. Grant savingsplans:DescribeSavingsPlanRates for plan rates. Grant ce:GetSavingsPlansPurchaseRecommendation for purchase recommendations. Grant ce:GetSavingsPlanPurchaseRecommendationDetails for recommendation details. Enable Cost Explorer for the metric tables. AWS charges for Cost Explorer requests. Daily utilization details require at least one request per day. Purchase recommendations need one request for each of 57 plan type, term, payment, and lookback combinations. Recommendation details also need one request for each recommendation. This source uses the global endpoints in the standard AWS partition. Metric imports cover up to 365 days and read the previous seven days again during incremental syncs.

Configuration

OptionDescription
AWS access key ID
Type: text
Required: True
AWS secret access key
Type: password
Required: True
AWS session token
Type: password
Required: False

Temporary credentials expire. Connect again with valid credentials when they expire.

Start date
Type: text
Required: False

Optional. Imports up to 365 days of metrics when empty. AWS requires the end date before today.

Linking AWS Savings Plans to PostHog

  1. Go to the Data pipeline page in PostHog
  2. Click New source and select AWS Savings Plans
  3. Fill in the required configuration fields
  4. Click Next, select the tables you want to sync, and then press Import

Supported tables

TableDescriptionSync methodIncremental fieldPrimary key
savings_plans

Savings Plans with their commitment, term, state, and payment details.

Full refresh——
utilization_daily

Daily commitment use and savings across Savings Plans.

Incremental, Full refreshperiod_start—
utilization_details_daily

Daily commitment use and savings for each Savings Plan.

Incremental, Full refreshperiod_start—
coverage_daily

Daily spend covered by Savings Plans and remaining on-demand spend.

Incremental, Full refreshperiod_start—
savings_plan_offerings

Savings Plans offerings with their plan type, term, payment option, and properties.

Full refresh——
savings_plan_rates

Contracted rates of each Savings Plan by service, usage type, and operation.

Full refresh——
purchase_recommendations

Recommended Savings Plans purchases with their expected cost and savings.

Full refresh——
purchase_recommendation_details

Estimated cost, coverage, and utilization behind each purchase recommendation.

Full refresh——