list_aws_monthely_cost_detail

Column Type
amortized_cost_amount BLOB
blended_cost_amount BLOB
net_amortized_cost_amount BLOB
net_unblended_cost_amount BLOB
period_start BLOB
period_end BLOB
unblended_cost_amount BLOB
account BLOB

SQL DDL

CREATE VIEW list_aws_monthely_cost_detail AS
SELECT 
acd.amortized_cost_amount,
acd.blended_cost_amount,
acd.net_amortized_cost_amount,
acd.net_unblended_cost_amount,
acd.period_start,
acd.period_end,
acd.unblended_cost_amount,
acc.title as account
FROM ur_transform_list_aws_monthly_cost_detail AS acd
INNER JOIN ur_transform_aws_account_info AS acc ON acd.linked_account_id = acc.account_id ORDER BY acd.period_start DESC
;