Analyze the different metered costs for a particular SKU

Personas: FinOps Practitioner

Analyze the different metered costs for a particular SKU v1.3

Adapted to v1.0

Source: FOCUS 1.0 sample
Result rows: 100
Status: Adapted to v1.0
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Breaks down SKU costs by charge period, SKU price, pricing unit, and list unit price. ServiceProviderName uses publisher_name when it differs from invoice_issuer_name to identify marketplace sellers such as Datadog and Red Hat, otherwise provider_name. The source SQL does not filter to one SKU; this translation preserves its first 100 breakdowns in deterministic chronological order.

Column adaptations (1)

Query results

Query results
Service provider name	Charge period start	Charge period end	Sku id	Sku price id	Pricing unit	List unit price	Total pricing quantity	Total list cost	Total effective cost
AWS	2026-03-01	2026-03-01 01:00	2KRSTFABXH77P2FQ	2KRSTFABXH77P2FQ.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.12	0.01	$0.0015	$0.00
AWS	2026-03-01	2026-03-01 01:00	3CXT4SN26EPSKK5A	3CXT4SN26EPSKK5A.JRTCKXETXF.6YS6EN2CT7	Hours	$0.01	4	$0.04	$0.00
AWS	2026-03-01	2026-03-01 01:00	3ZD39ECB23FRWNNP	3ZD39ECB23FRWNNP.JRTCKXETXF.6YS6EN2CT7	Hours	$0.17	1	$0.17	$0.00
AWS	2026-03-01	2026-03-01 01:00	4AR283EJ3D82STYQ	4AR283EJ3D82STYQ.JRTCKXETXF.6YS6EN2CT7	GB	$0.02	0	$0.0000000026	$0.00
AWS	2026-03-01	2026-03-01 01:00	4GQUNXTFWVSGPUZK	4GQUNXTFWVSGPUZK.JRTCKXETXF.6YS6EN2CT7	Hours	$0.005	1	$0.005	$0.00
AWS	2026-03-01	2026-03-01 01:00	4MB6SVGV7JKWFBUJ	4MB6SVGV7JKWFBUJ.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.11	0.01	$0.00127	$0.00
AWS	2026-03-01	2026-03-01 01:00	4V475Q49DCKGXQZ2	4V475Q49DCKGXQZ2.JRTCKXETXF.HBHVWY47CM	ReadCapacityUnit-Hours	$0.00	1	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	55NFVN8W7N8G6PPF	55NFVN8W7N8G6PPF.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	5CHDB6K4USP8QXF3	5CHDB6K4USP8QXF3.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	5M4327XEUKBBTWAT	5M4327XEUKBBTWAT.JRTCKXETXF.Q3Z75P77EN	GB	$0.09	0	$0.00000095	$0.00
AWS	2026-03-01	2026-03-01 01:00	62WNQUZDQQ6GRJC5	62WNQUZDQQ6GRJC5.JRTCKXETXF.6YS6EN2CT7	GB	$0.01	0	$0.00000243	$0.00
AWS	2026-03-01	2026-03-01 01:00	8HFJK44D9234XNWA	8HFJK44D9234XNWA.JRTCKXETXF.6YS6EN2CT7	Hours	$0.005	1	$0.005	$0.00
AWS	2026-03-01	2026-03-01 01:00	8RN6B8U4MERHRXP3	8RN6B8U4MERHRXP3.JRTCKXETXF.VXGXCWQKTY	Requests	$0.0000004	4	$0.0000016	$0.00
AWS	2026-03-01	2026-03-01 01:00	98TA3WPUP3A4AH4Y	98TA3WPUP3A4AH4Y.JRTCKXETXF.6YS6EN2CT7	Hours	$0.06	1	$0.06	$0.00
AWS	2026-03-01	2026-03-01 01:00	9DEJHBACUYEYMVN8	9DEJHBACUYEYMVN8.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	9E83UKTH5HDZP369	9E83UKTH5HDZP369.JRTCKXETXF.6YS6EN2CT7	GB	$0.02	0	$0.000000004	$0.00
AWS	2026-03-01	2026-03-01 01:00	9MG5B7V4UUU2WPAV	9MG5B7V4UUU2WPAV.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	AEBQHWFEG8Q4Y7AT	AEBQHWFEG8Q4Y7AT.JRTCKXETXF.6YS6EN2CT7	API Requests	$0.000005	1	$0.000005	$0.00
AWS	2026-03-01	2026-03-01 01:00	ARHHEUH3WM2QNZJF	ARHHEUH3WM2QNZJF.JRTCKXETXF.6YS6EN2CT7	GB	$0.02	0	$0.0000000052	$0.00
AWS	2026-03-01	2026-03-01 01:00	AUJG8J97AVK3PF8K	AUJG8J97AVK3PF8K.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.10	0.08	$0.00764	$0.00
AWS	2026-03-01	2026-03-01 01:00	AWKFFAT3BA3CZFU3	AWKFFAT3BA3CZFU3.JRTCKXETXF.HBHVWY47CM	ReadCapacityUnit-Hours	$0.00	1	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	CV5S3QJ2UJAGVWG7	CV5S3QJ2UJAGVWG7.JRTCKXETXF.6YS6EN2CT7	Hours	$0.00	1	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	D7RMW443YWTMZ4V5	D7RMW443YWTMZ4V5.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.09	0.1	$0.0095	$0.00
AWS	2026-03-01	2026-03-01 01:00	D8WVCVBE32N227KA	D8WVCVBE32N227KA.JRTCKXETXF.6YS6EN2CT7	Hours	$0.18	1	$0.18	$0.00
AWS	2026-03-01	2026-03-01 01:00	DC3B6SZ3M34J977D	DC3B6SZ3M34J977D.JRTCKXETXF.6YS6EN2CT7	Events	$0.00	6	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	E77AQEM2DC4VV3FC	E77AQEM2DC4VV3FC.JRTCKXETXF.6YS6EN2CT7	Requests	$0.0000004	7	$0.0000028	$0.00
AWS	2026-03-01	2026-03-01 01:00	EAUDKWWNQJZTV253	EAUDKWWNQJZTV253.JRTCKXETXF.6YS6EN2CT7	GB	$0.02	0	$0.000000137	$0.00
AWS	2026-03-01	2026-03-01 01:00	F62Y6TKR8NC6Q2ZB	F62Y6TKR8NC6Q2ZB.JRTCKXETXF.Q3Z75P77EN	GB	$0.09	0	$0.00000205	$0.00
AWS	2026-03-01	2026-03-01 01:00	FSEU4E6BRE95JTX8	FSEU4E6BRE95JTX8.JRTCKXETXF.Q3Z75P77EN	GB	$0.09	0	$0.00000184	$0.00
AWS	2026-03-01	2026-03-01 01:00	G95FST5FTYV3JSRX	G95FST5FTYV3JSRX.JRTCKXETXF.VXGXCWQKTY	Requests	$0.0000004	23	$0.0000092	$0.00
AWS	2026-03-01	2026-03-01 01:00	GV2WFGX37Q9PDSHF	GV2WFGX37Q9PDSHF.JRTCKXETXF.Q3Z75P77EN	GB	$0.09	0.34	$0.03	$0.00
AWS	2026-03-01	2026-03-01 01:00	HQEH3ZWJVT46JHRG	HQEH3ZWJVT46JHRG.JRTCKXETXF.Q3Z75P77EN	GB	$0.09	0	$0.0000000034	$0.00
AWS	2026-03-01	2026-03-01 01:00	HSRFWQ3TJGWVZ2EK	HSRFWQ3TJGWVZ2EK.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	HY3BZPP2B6K8MSJF	HY3BZPP2B6K8MSJF.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.10	0.08	$0.00764	$0.00
AWS	2026-03-01	2026-03-01 01:00	J5H5J7F2H2NJEZZN	J5H5J7F2H2NJEZZN.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.004	0.05	$0.000181	$0.00
AWS	2026-03-01	2026-03-01 01:00	JAJH5U2Z5CRKQF8R	JAJH5U2Z5CRKQF8R.JRTCKXETXF.6YS6EN2CT7	Requests	$0.00001	123	$0.00123	$0.00
AWS	2026-03-01	2026-03-01 01:00	JG3KUJMBRGHV3N8G	JG3KUJMBRGHV3N8G.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.08	0	$0.000111	$0.00
AWS	2026-03-01	2026-03-01 01:00	K7TCM43VJV3N2RMH	K7TCM43VJV3N2RMH.JRTCKXETXF.6YS6EN2CT7	GB	$0.008	0	$0.0000000071	$0.00
AWS	2026-03-01	2026-03-01 01:00	KJC988R4J65BDMTQ	KJC988R4J65BDMTQ.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.10	0	$0.000348	$0.00
AWS	2026-03-01	2026-03-01 01:00	KVW47BDJMV6V4TYA	KVW47BDJMV6V4TYA.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.12	0.01	$0.00133	$0.00
AWS	2026-03-01	2026-03-01 01:00	NBHXEKTE88TJDDQF	NBHXEKTE88TJDDQF.JRTCKXETXF.6YS6EN2CT7	Hours	$0.005	4.85	$0.02	$0.00
AWS	2026-03-01	2026-03-01 01:00	NTC2QZFJW79R5XVK	NTC2QZFJW79R5XVK.JRTCKXETXF.6YS6EN2CT7	Hours	$0.00445	0.01	$0.000037	$0.00
AWS	2026-03-01	2026-03-01 01:00	P6D6UQPC87KFKK3N	P6D6UQPC87KFKK3N.JRTCKXETXF.6YS6EN2CT7	Hours	$0.005	1	$0.005	$0.00
AWS	2026-03-01	2026-03-01 01:00	PJY6CW7GDQYM5RHH	PJY6CW7GDQYM5RHH.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	PNUBVW4CPC8XA46W	PNUBVW4CPC8XA46W.JRTCKXETXF.6YS6EN2CT7	GB	$0.01	0.07	$0.000712	$0.00
AWS	2026-03-01	2026-03-01 01:00	PQJGBSU7YWWTQH72	PQJGBSU7YWWTQH72.JRTCKXETXF.6YS6EN2CT7	GB	$0.02	0	$0.000000129	$0.00
AWS	2026-03-01	2026-03-01 01:00	PYNU7WJBSCTWR8XF	PYNU7WJBSCTWR8XF.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.02	0	$0.00000137	$0.00
AWS	2026-03-01	2026-03-01 01:00	QBM2FSFWP6GWWHMU	QBM2FSFWP6GWWHMU.JRTCKXETXF.6YS6EN2CT7	GB	$0.05	0	$0.0000000261	$0.00
AWS	2026-03-01	2026-03-01 01:00	RGN4FERZ8NXYWRDE	RGN4FERZ8NXYWRDE.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	S8QGXX5R2BKKMDSJ	S8QGXX5R2BKKMDSJ.JRTCKXETXF.6YS6EN2CT7	GB	$0.50	0	$0.000204	$0.00
AWS	2026-03-01	2026-03-01 01:00	SCM63QZA8NKUYACF	SCM63QZA8NKUYACF.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.10	0.06	$0.00556	$0.00
AWS	2026-03-01	2026-03-01 01:00	SCRJWVN46C6JYKT5	SCRJWVN46C6JYKT5.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	SDZJ3RVGSDZ69N6A	SDZJ3RVGSDZ69N6A.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	SFYF65Z68F2F43ZV	SFYF65Z68F2F43ZV.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	T8AC6AEU9J8K6MN8	T8AC6AEU9J8K6MN8.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	UKQ34C8EAAJUUK8Q	UKQ34C8EAAJUUK8Q.JRTCKXETXF.Q3Z75P77EN	GB	$0.11	0	$0.00000182	$0.00
AWS	2026-03-01	2026-03-01 01:00	V7KMP6W4U24AS5GT	V7KMP6W4U24AS5GT.JRTCKXETXF.6YS6EN2CT7	GB	$0.02	0	$0.000000724	$0.00
AWS	2026-03-01	2026-03-01 01:00	V97WX8KBR4YWXNJZ	V97WX8KBR4YWXNJZ.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	VCCKNYURW3SX8D6J	VCCKNYURW3SX8D6J.JRTCKXETXF.6YS6EN2CT7	Hours	$0.48	1	$0.48	$0.00
AWS	2026-03-01	2026-03-01 01:00	WEMS88BYNHHUKWC8	WEMS88BYNHHUKWC8.JRTCKXETXF.6YS6EN2CT7	Hours	$0.50	1	$0.50	$0.00
AWS	2026-03-01	2026-03-01 01:00	WP9ANXZGBYYSGJEA	WP9ANXZGBYYSGJEA.JRTCKXETXF.PGHJ3S3EYE	GB-Months	$0.02	0	$0.0000000012	$0.00
AWS	2026-03-01	2026-03-01 01:00	XZ2DR556MD28P9WJ	XZ2DR556MD28P9WJ.JRTCKXETXF.6YS6EN2CT7	LCU-Hours	$0.006	0	$0.0000000306	$0.00
AWS	2026-03-01	2026-03-01 01:00	Y8HYRU3BZZ4QFJHH	Y8HYRU3BZZ4QFJHH.JRTCKXETXF.6YS6EN2CT7	GB	$0.02	0	$0.000000615	$0.00
AWS	2026-03-01	2026-03-01 01:00	YPGKVRB2EKTVDJDT	YPGKVRB2EKTVDJDT.JRTCKXETXF.PGHJ3S3EYE	GB-Months	$0.02	0.01	$0.000139	$0.00
AWS	2026-03-01	2026-03-01 01:00	Z3FQZG73HYSPVABR	Z3FQZG73HYSPVABR.JRTCKXETXF.PGHJ3S3EYE	GB-Months	$0.02	0	$0.0000265	$0.00
AWS	2026-03-01	2026-03-01 01:00	ZACFFWPPC668YV8A	ZACFFWPPC668YV8A.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	ZHNEWRM5JMUK596C	ZHNEWRM5JMUK596C.JRTCKXETXF.6YS6EN2CT7	GB	$0.00	0	$0.00	$0.00
AWS	2026-03-01	2026-03-01 01:00	ZP85FQT9FHKJRAG5	ZP85FQT9FHKJRAG5.JRTCKXETXF.6YS6EN2CT7	Hours	$0.005	0.47	$0.00233	$0.00
AWS	2026-03-01	2026-03-01 22:00	5M4327XEUKBBTWAT	–	GB	-$0.00000374	0	-$0.00000374	$0.00
Microsoft	2026-03-01	2026-03-02	1002909	1002909	Hours	$0.06	24	$1.44	$1.44
Microsoft	2026-03-01	2026-03-02	1003280	1003280	GB/Month	$0.08	0	$0.0000342	$0.0000342
Microsoft	2026-03-01	2026-03-02	1004161	1004161	GB	$0.00	0	$0.00	$0.00
Microsoft	2026-03-01	2026-03-02	1004646	1004646	GB/Month	$0.02	0.17	$0.00283	$0.00283
Microsoft	2026-03-01	2026-03-02	1007365	1007365	GB/Month	$0.02	0	$0.00000504	$0.00000504
Microsoft	2026-03-01	2026-03-02	1007663	1007663	Hours	$0.15	-0.98	-$0.14	-$0.14
Microsoft	2026-03-01	2026-03-02	1007742	1007742	Units	$0.06	0	$0.000044	$0.000044
Microsoft	2026-03-01	2026-03-02	1007784	1007784	Units	$0.00036	0	$0.000063	$0.000063
Microsoft	2026-03-01	2026-03-02	1008493	1008493	Units/Day	$0.16	1	$0.16	$0.16
Microsoft	2026-03-01	2026-03-02	1009967	1009967	Hours	$0.15	-1	-$0.15	-$0.15
Microsoft	2026-03-01	2026-03-02	1010107	1010107	GB	$0.09	0	$0.0000351	$0.0000351
Microsoft	2026-03-01	2026-03-02	1010886	1010886	Hours	$0.10	0.98	$0.09	$0.09
Microsoft	2026-03-01	2026-03-02	1010996	1010996	Units	$0.00036	-0	-$0.0000156	-$0.0000156
Microsoft	2026-03-01	2026-03-02	1012587	1012587	Units	$0.02	0	$0.00	$0.00
Microsoft	2026-03-01	2026-03-02	1013822	1013822	Hours	$0.004	24	$0.10	$0.10
Microsoft	2026-03-01	2026-03-02	1017069	1017069	GB/Month	$0.05	0	$0.0000127	$0.0000127
Microsoft	2026-03-01	2026-03-02	1018410	1018410	Units	$0.00036	0	$0.000000216	$0.000000216
Microsoft	2026-03-01	2026-03-02	1019000	1019000	Units	$0.03	-0	-$0.000009	-$0.000009
Microsoft	2026-03-01	2026-03-02	1019280	1019280	GB/Month	$0.02	-0.03	-$0.0006	-$0.0006
Microsoft	2026-03-01	2026-03-02	1019536	1019536	Units/Month	$3.00	0	$0.00417	$0.00417
Microsoft	2026-03-01	2026-03-02	1020646	1020646	Units	$0.0005	-0	-$0.000001	-$0.000001
Microsoft	2026-03-01	2026-03-02	1046405	1046405	Units	$0.0043	0	$0.0000043	$0.0000043
Microsoft	2026-03-01	2026-03-02	1047247	1047247	Units	$0.004	0	$0.0000448	$0.0000448
Microsoft	2026-03-01	2026-03-02	1047956	1047956	Units	$0.004	0	$0.00	$0.00
Microsoft	2026-03-01	2026-03-02	1048759	1048759	GB/Month	$0.05	0	$0.000027	$0.000027
Microsoft	2026-03-01	2026-03-02	1048867	1048867	Units	$0.0044	0	$0.00	$0.00
Microsoft	2026-03-01	2026-03-02	1051500	1051500	Hours	$0.04	1.25	$0.05	$0.05
Microsoft	2026-03-01	2026-03-02	1053938	1053938	GB	$2.30	0.21	$0.48	$0.48
Microsoft	2026-03-01	2026-03-02	1071327	1071327	GB	$0.005	-16.66	-$0.08	-$0.08
Microsoft	2026-03-01	2026-03-02	1071790	1071790	Hours	$0.005	24	$0.12	$0.12
Microsoft	2026-03-01	2026-03-02	1071942	1071942	Hours	$0.03	2	$0.05	$0.05

100 rows. Scroll inside the table to see more.

Default parameters use the precomputed result, generated as the read-only focus_reader role.

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select
  case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
  charge_period_start as charge_period_start,
  charge_period_end as charge_period_end,
  sku_id as sku_id,
  sku_price_id as sku_price_id,
  pricing_unit as pricing_unit,
  list_unit_price as list_unit_price,
  sum(pricing_quantity) as total_pricing_quantity,
  sum(list_cost) as total_list_cost,
  sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
  and charge_period_end < $2::timestamptz
group by case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end, charge_period_start, charge_period_end,
  sku_id, sku_price_id, pricing_unit, list_unit_price
order by charge_period_start asc, charge_period_end asc,
  service_provider_name asc, sku_id asc nulls last, sku_price_id asc nulls last,
  pricing_unit asc nulls last, list_unit_price asc nulls last
limit 100

Parameters: $1 = charge_period_start, $2 = charge_period_end

Original FOCUS SQL

SELECT
  ServiceProviderName,
  ChargePeriodStart,
  ChargePeriodEnd,
  SkuId,
  SkuPriceId,
  PricingUnit,
  ListUnitPrice,
  SUM(PricingQuantity) AS TotalPricingQuantity,
  SUM(ListCost) AS TotalListCost,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  ServiceProviderName,
  ChargePeriodStart,
  ChargePeriodEnd,
  SkuId,
  SkuPriceId,
  PricingUnit,
  ListUnitPrice
ORDER BY
  ChargePeriodStart ASC
LIMIT 100

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗