The avatar for @fcontrepois
Frank Contrepois
Serial learner and pathological sharer.
Public
Edited
Aug 4, 2023
Fork of 2023-07-19 SQL Server license costs in AWS
AWS pricing discovery
Are AWS' prices going up?AWS testing density graphs
WIP 2023-RDS SQL engines license costs in AWS
Looking into the RDS pricing data2023-04-17 Windows license costs in AWS2023-04-19 RHEL license costs in AWS2023-07-19 SQL Server license costs in AWS2023-04 AWS EC2 pricing investigation2024-01 Extention to the findings in the previous investigation
Also listed in…
WIP
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
dtRdsOneTyepOneRegion
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
vl.markBar()
.data(dtRdsManagementFeePerNormAllsinUsEast)
.encode(
vl.x().fieldQ('fee_price').title('RDS Fee per nomalisation factor per hour').bin(true),
vl.y().fieldN('full_engine').title('SQL engine').sort("-x"),
vl.column().fieldN('cpu_brand'),
vl.tooltip(["fee_price", "instancefamily", "full_engine", "cpu_brand", "region_code_1"]),
vl.color().fieldN('region_code_1'),
vl.opacity().value(1),
vl.xOffset().fieldN('instance_type_1'),
//vl.order().fieldQ('fee_price').sort('descending')
)
.render()
Insert cell
vl.markTick()
.data(dtRdsManagementFeePerNormAllsinUsEast)
.encode(
vl.x().fieldQ('fee_price').title('RDS Fee per nomalisation factor per hour'),
//vl.y().fieldN('full_engine').title('SQL engine').sort("-x"),
vl.row().fieldN('region_code_1'),
vl.tooltip(["fee_price", "instancefamily", "full_engine", "cpu_brand","region_code_1"]),
vl.color().fieldN('region_code_1'),
//vl.order().fieldQ('fee_price').sort('descending')
)
.render()
Insert cell
vl.markTick()
.data(dtRdsManagementFeePerNormAllsinUsEast)
.encode(
vl.x().fieldQ('fee_price').title('RDS Fee per nomalisation factor per hour').bin(true),
//vl.y().fieldN('full_engine').title('SQL engine').sort("-x"),
vl.row().fieldN('region_code_1'),
vl.tooltip(["fee_price", "instancefamily", "full_engine", "cpu_brand","region_code_1"]),
vl.color().fieldN('region_code_1'),
//vl.order().fieldQ('fee_price').sort('descending')
)
.render()
Insert cell
dtRdsManagementFeePerNormAllsinUsEast
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
import {vl} from '@vega/vega-lite-api-v5'
Insert cell
Insert cell
Insert cell
Insert cell
parquetUrlLnx='https://data.frankcontrepois.com/FinOpsGuyAwsPricingElaboratedData/2023-07/ec2_gen_lnx_na_prices.parquet'
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more