Data Export
      Back to home
      1. Help Center
      2. Platform Features
      3. Data Export

      Data Export Format: Intelligent Showback - Showback (v1)

      Once you have successfully configured Data Export, updates will be published to your S3 bucket every 24 hours. This article describes the organization and structure of the Intelligent Showback - Showback (v1) export.

      Organization

      Directory Structure

      ProsperOps will create the following directory structure in your export S3 bucket.

      • intelligent_showback
        • v1
          • <file>

        File Structure

        The v1 directory contains CSV files representing the data in the Intelligent Showback view of the ProsperOps Console.

        • One file is available for each month ProsperOps has been active
        • The naming and structure of these export files mimic that which is displayed and available for download in the ProsperOps console
        • Name
          • prosperops-showback-[yyyy]-[mm]-[managementAccountNumber]-[savingsReallocationMethod]-[savingsShareIfIncluded].csv
          • Example: prosperops-showback-2025-02-123456789012-shared_benefit-savings_share.csv
        • Rows
          • Each row represents the original and reallocated cost and savings data grouped by account number, service, region, platform, tenancy, and instance type. This is collectively known as a "showback group".
        • Columns

          Column Name Type Description
          month_start date The first day of the month the showback data applied (yyyy-mm-dd) 
          account_number integer The 12-digit AWS account number where the showback group resided/applied
          account_name string The corresponding AWS account name
          service string

          Valid values are:

          EC2
          EC2 Dedicated Hosts
          EC2 Unused Capacity Reservations
          Fargate
          Lambda
          Compute Savings Plans
          EC2 Instance Savings Plans
          EC2 Convertible Reserved Instances
          EC2 Standard Reserved Instances
          RDS
          RDS Reserved Instances
          ElastiCache
          ElastiCache Reserved Nodes
          OpenSearch
          OpenSearch Reserved Instances
          Redshift
          Redshift Reserved Nodes
          MemoryDB
          MemoryDB Reserved Nodes
          ProsperOps Compute Savings Share
          ProsperOps RDS Savings Share
          ProsperOps ElastiCache Savings Share
          ProsperOps OpenSearch Savings Share
          ProsperOps Redshift Savings Share
          ProsperOps MemoryDB Savings Share
          region string The region where the showback group resided/applied; * means any
          platform string The showback group operating system or engine; * means any; empty means n/a
          tenancy string The showback group tenancy; * means any; empty means n/a
          instance_type string The instance type of the showback group; * means any; empty means n/a; value will be of the format [instance family]:* (e.g. c6i:*, db.r8g:*) if instance size flexibility applied
          undiscounted_usage decimal What would have been paid if there were no discounts
          original_savings decimal Savings as natively allocated, to arrive at original_cost
          original_cost decimal Cost as shown on the invoice
          reallocated_savings decimal The portion of total savings generated, properly allocated back
          adjusted_cost decimal Cost with properly allocated savings
          net_adjustment decimal The amount of incremental cost to add to or remove from the original_cost value to align with adjusted_cost