aws_sdk

Components

Code examples

Manage SDK

--- installs the aws sdk module
SELECT * FROM iasql_install('aws_sdk');
--- get IAM groups list
SELECT invoke_iam('listGroups', '{}') as result;
--- creates an IAM group
SELECT invoke_iam('createGroup', '{
"GroupName": "<prefix>"
}') as result;
--- gets the created IAM group
SELECT invoke_iam('getGroup', '{
"GroupName": "<prefix>"
}') as result;
--- installs vpc module
SELECT * FROM iasql_install('aws_vpc');
--- executes a request per each default vpc and checks vpc_id and cidr_block
SELECT vpc_id,
cidr_block,
invoke_ec2('describeVpcs', json_build_object('VpcIds', array [vpc_id]), region) -> 'Vpcs' ->
0 as cloud_data
FROM vpc
WHERE is_default;
--- creates a route table
SELECT invoke_ec2(
'createRouteTable',
json_build_object(
'VpcId',
(SELECT vpc_id FROM vpc WHERE region = default_aws_region() AND is_default LIMIT 1),
'TagSpecifications',
'[{"ResourceType": "route-table", "Tags": [{"Key": "Name", "Value": "<prefix>"}]}]'::json
)
);
--- checks the route table is created
SELECT *
FROM route_table
WHERE tags ->> 'Name' = '<prefix>';
--- deletes the route table
DELETE
FROM route_table
WHERE tags ->> 'Name' = '<prefix>';