Exploring the AWS Pricing API Using CloudQuery AWS Pricing Plugin

cloudquery sync ./cloudquery-config

SELECT
	sku, 
	product_family, 
	attributes,
	attributes->>'instanceType' as instance_type,
	attributes->>'servicename' as service_name,
	attributes->>'regionCode' as region
FROM awspricing_service_products
WHERE product_family = 'Compute Instance'

WITH expanded_price_dimensions AS (
  SELECT
    st.sku,
    st.type,
    st.effective_date,
    jsonb_array_elements(st.price_dimensions) AS price_dimension
  FROM
    awspricing_service_terms AS st
)
SELECT
    sp.sku,
    sp.product_family,
    sp.attributes->>'regionCode' AS region,
    sp.attributes->>'instanceType' AS instance_type,
    epd.effective_date,
    epd.price_dimension->'pricePerUnit'->>'USD' AS price_per_unit_usd,
    epd.price_dimension->>'description' AS price_description,
    epd.price_dimension->>'unit' AS unit
FROM
    awspricing_service_products AS sp
JOIN
    expanded_price_dimensions AS epd
ON
    sp.sku = epd.sku
WHERE
    sp.attributes->>'servicecode' = 'AmazonEC2'
    AND epd.type = 'OnDemand';