getstrake / aws-pricing-sheets-addon

Google Sheets add-on for AWS Pricing
https://workspace.google.com/marketplace/app/aws_pricing_by_strake/378787760903
33 stars 0 forks source link

Show "Amazon VPC" things for ec2 instances. #32

Open john-macroscope opened 1 year ago

john-macroscope commented 1 year ago

Consider adding Amazon VPC things to ec2 instances. Based on from this question from @Saroopashree which asked (among other things), "What about platforms like Linux/UNIX (Amazon VPC)" ?

I haven't researched this deeply, but here's an example reserved instance that mentions "Amazon VPC": note the description of "Linux with SQL Server Enterprise (Amazon VPC), r3.xlarge reserved instance applied".

Presumably the base instance type has something we could add to what we're surfacing this in the user interface, see ec2 SKU below.

    "Reserved" : {
      "6RCJMXD8XSQUJE8Q" : {
        "6RCJMXD8XSQUJE8Q.CUZHX8X6JH" : {
          "offerTermCode" : "CUZHX8X6JH",
          "sku" : "6RCJMXD8XSQUJE8Q",
          "effectiveDate" : "2018-03-31T23:59:59Z",
          "priceDimensions" : {
            "6RCJMXD8XSQUJE8Q.CUZHX8X6JH.2TG2D8R56U" : {
              "rateCode" : "6RCJMXD8XSQUJE8Q.CUZHX8X6JH.2TG2D8R56U",
              "description" : "Upfront Fee",
              "unit" : "Quantity",
              "pricePerUnit" : {
                "USD" : "8013"
              },
              "appliesTo" : [ ]
            },
            "6RCJMXD8XSQUJE8Q.CUZHX8X6JH.6YS6EN2CT7" : {
              "rateCode" : "6RCJMXD8XSQUJE8Q.CUZHX8X6JH.6YS6EN2CT7",
              "description" : "Linux with SQL Server Enterprise (Amazon VPC), r3.xlarge reserved instance applied",
              "beginRange" : "0",
              "endRange" : "Inf",
              "unit" : "Hrs",
              "pricePerUnit" : {
                "USD" : "0.9150000000"
              },
              "appliesTo" : [ ]
            }
          },
          "termAttributes" : {
            "LeaseContractLength" : "1yr",
            "OfferingClass" : "convertible",
            "PurchaseOption" : "Partial Upfront"
          }
        },

ec2 SKU

Working back from the reserved-instance SKU of "HRWXUXUDEADCE8NY" from above it looks like "tenancy" : "Dedicated", might be relevant.

    "HRWXUXUDEADCE8NY" : {
      "sku" : "HRWXUXUDEADCE8NY",
      "productFamily" : "Compute Instance",
      "attributes" : {
        "servicecode" : "AmazonEC2",
        "location" : "Asia Pacific (Sydney)",
        "locationType" : "AWS Region",
        "instanceType" : "r3.xlarge",
        "currentGeneration" : "No",
        "instanceFamily" : "Memory optimized",
        "vcpu" : "4",
        "physicalProcessor" : "Intel Xeon E5-2670 v2 (Ivy Bridge)",
        "clockSpeed" : "2.5 GHz",
        "memory" : "30.5 GiB",
        "storage" : "1 x 80 SSD",
        "networkPerformance" : "Moderate",
        "processorArchitecture" : "64-bit",
        "tenancy" : "Dedicated",
        "operatingSystem" : "Linux",
        "licenseModel" : "No License required",
        "usagetype" : "APS2-DedicatedRes:r3.xlarge",
        "operation" : "RunInstances:0100",
        "availabilityzone" : "NA",
        "capacitystatus" : "AllocatedCapacityReservation",
        "classicnetworkingsupport" : "true",
        "ecu" : "13",
        "enhancedNetworkingSupported" : "Yes",
        "gpuMemory" : "NA",
        "instancesku" : "6RCJMXD8XSQUJE8Q",
        "intelAvxAvailable" : "Yes",
        "intelAvx2Available" : "No",
        "intelTurboAvailable" : "Yes",
        "marketoption" : "OnDemand",
        "normalizationSizeFactor" : "8",
        "preInstalledSw" : "SQL Ent",
        "processorFeatures" : "Intel AVX; Intel Turbo",
        "regionCode" : "ap-southeast-2",
        "servicename" : "Amazon Elastic Compute Cloud",
        "vpcnetworkingsupport" : "true"
      }
    },