Converting AWS CloudWatch Metrics Insight query to CDK Metric

To Nha Notes | April 11, 2023, 10:49 p.m.

 let metrics = new MathExpression({
            expression: "SELECT COUNT(ResourceCount) FROM SCHEMA(\"AWS/Usage\", Class,Resource,Service,Type) WHERE Service = 'Fargate' AND Resource = 'vCPU'",
            usingMetrics: {},
            label: "Query1"
        })

        let metric2 = new Metric({
            namespace: "AWS/Usage",
            metricName: "ResourceCount",
            period: cdk.Duration.seconds(300),
            dimensionsMap: {
                "Service": "Fargate",
                "Type": "Resource",
            }
        })

        const extractECSWidget = new GraphWidget({
            title: "ExtractECSJobTest",
            left: [metrics, metric2],
            region: "us-west-2",
            statistic: "Sum",
            width: 24
        });

        dashboardStack.addWidgets(
            extractECSWidget
        );

References

https://stackoverflow.com/questions/74309107/converting-aws-cloudwatch-metrics-insight-query-to-cdk-metric