aws_cloudwatch

Components

Tables

    log_group

    metric_alarm

Functions

    log_group_tail

Enums

    comparison_operator

    evaluate_low_sample_count_percentile

    standard_unit

    statistic

    treat_missing_data

Code examples

Code examples

Manage cloudwatch

--- installs the cloudwatch module
SELECT * FROM iasql_install('<modules>');
--- adds a new log group
INSERT INTO log_group (log_group_name)
VALUES ('<logGroupName>');
--- check adds a new log group
SELECT *
FROM log_group
WHERE log_group_name = '<logGroupName>';
--- deletes the log group
DELETE FROM log_group
WHERE log_group_name = '<logGroupName>';
--- creates a log group in default region
INSERT INTO log_group (log_group_name)
VALUES ('<logGroupName>');
--- deletes the log group in the default region
DELETE FROM log_group
WHERE log_group_name = '<logGroupName>' AND region = default_aws_region();
--- checks the deletion of all of the log groups
SELECT *
FROM log_group
WHERE log_group_name = '<logGroupName>';
--- moves the log group to a new region
UPDATE log_group
SET region = 'us-east-2'
WHERE log_group_name = '<logGroupName>';
--- adds a new alarm
INSERT INTO metric_alarm (alarm_name, alarm_description, actions_enabled, comparison_operator, datapoints_to_alarm, dimensions, metric_name, namespace, period, statistic, threshold, evaluation_periods)
VALUES ('<alarmName>', 'Metric alarm description', true, 'GreaterThanThreshold', 1, '[{"Name": "InstanceId", "Value": "test"}]', 'CPUUtilization', 'AWS/EC2', 60, 'Average', 19327352832, 1);
--- check adds a new alarm
SELECT *
FROM metric_alarm
WHERE alarm_name = '<alarmName>';
--- tries to add metric actions
UPDATE metric_alarm SET evaluation_periods=3, alarm_actions='<alarmActions>' WHERE alarm_name = '<alarmName>';
--- check evaluation periods has been modified
SELECT *
FROM metric_alarm
WHERE alarm_name = '<alarmName>' AND evaluation_periods=3;
--- deletes the metric alarm
DELETE FROM metric_alarm
WHERE alarm_name = '<alarmName>';

Tail logs

--- installs modules
SELECT * FROM iasql_install('<modules>');
--- adds a new lambda function and role
BEGIN;
INSERT INTO iam_role (role_name, assume_role_policy_document, attached_policies_arns)
VALUES ('<resourceName>', '<attachAssumeLambdaPolicy>', array['<lambdaFunctionRoleTaskPolicyArn>']);

INSERT INTO lambda_function (name, zip_b64, handler, runtime, role_name)
VALUES ('<resourceName>', '<lambdaFunctionCode>', '<lambdaFunctionHandler>', '<lambdaFunctionRuntime14>', '<resourceName>');
COMMIT;
--- invoke function
SELECT * FROM invoke_lambda_function('<resourceName>');
--- tail logs function
SELECT * FROM log_group_tail('<lambdaLogGroupName>');