Closed
Description
For the following query:
SELECT service, period_start, period_end
FROM aws_cost_by_service_daily
WHERE period_start >= current_timestamp - interval '30d' AND
period_end >= current_timestamp - interval '30d' AND
service = 'Tax'
Generates the following filter request:
{
"Filter": { "Dimensions": {"Key": "SERVICE", "Values": ["Tax"] }},
"Granularity": "DAILY",
"GroupBy": [{ "Key": "SERVICE", "Type": "DIMENSION" }],
"Metrics": ["BlendedCost", "UnblendedCost", "NetUnblendedCost", "AmortizedCost",
"NetAmortizedCost", "UsageQuantity", "NormalizedUsageAmount"],
"TimePeriod": { "End": "2024-03-27", "Start": "2023-03-27" }
}
This requests data for a whole year, instead of just for the requested period, and thus causes many unnecessary API requests which each cost $0.01.
Steampipe v0.22.0
turbot/aws v0.132.0