aws_dynamo

Components

Tables

    dynamo_table

Enums

    table_class

Code examples

Manage Dynamo DB

--- installs the dynamo module
SELECT * FROM iasql_install('<modules>');
--- creates a Dynamo table
INSERT INTO dynamo_table (table_name, table_class, throughput, primary_key)
VALUES (
'<prefix>test',
'STANDARD',
'"PAY_PER_REQUEST"',
'{"key": "S", "val": "S"}'
);
--- checks the table was added
SELECT *
FROM dynamo_table
WHERE table_name = '<prefix>test';
--- changes the column definition
UPDATE dynamo_table
SET primary_key = '{"key": "S", "val": "N"}'
WHERE table_name = '<prefix>test';
--- removes the dynamo table
DELETE FROM dynamo_table
WHERE table_name = '<prefix>test';
--- creates a table in a non-default region
INSERT INTO dynamo_table (table_name, table_class, throughput, primary_key, region)
VALUES (
'<prefix>regiontest',
'STANDARD',
'"PAY_PER_REQUEST"',
'{"key": "S", "val": "S"}',
'us-east-1'
);
--- checks the table was added
SELECT *
FROM dynamo_table
WHERE table_name = '<prefix>regiontest';
--- changes the region the table is located in
UPDATE dynamo_table
SET region = '<region>'
WHERE table_name = '<prefix>regiontest';
--- checks the table was moved
SELECT *
FROM dynamo_table
WHERE table_name = '<prefix>regiontest';