turbot/aws_insights

Query: rds_db_instance_cost_mtd

Usage

powerpipe query aws_insights.query.rds_db_instance_cost_mtd

SQL

select
'Cost - MTD' as label,
sum(unblended_cost_amount) :: numeric :: money as value
from
aws_cost_by_service_usage_type_monthly
where
service = 'Amazon Relational Database Service'
and usage_type like '%Instance%'
and period_end > date_trunc('month', CURRENT_DATE :: timestamp);

Dashboards

The query is used in the dashboards: