aws_secrets_manager

Components

Tables

    secret

Code examples

Manage secrets

--- installs the secret module
SELECT * FROM iasql_install('<modules>');
--- adds a new secret
INSERT INTO secret (name, description, value)
VALUES ('<secretName>', 'description', '<secretValue>');
--- check secret is available
SELECT * FROM secret WHERE name='<secretName>';
--- tries to update secret description
UPDATE secret SET description='new description' WHERE name='<secretName>';
--- checks that secret has been been modified
SELECT * FROM secret WHERE description='new description';
--- tries to update secret value
UPDATE secret SET value='newvalue' WHERE name='<secretName>';
--- tries to update version
UPDATE secret SET version_id='fakeVersion' WHERE name='<secretName>';
--- checks secret count
SELECT * FROM secret WHERE name='<secretName>';
--- moves the secret to another region with a new value
UPDATE secret SET region='us-east-1', value='new_secret' WHERE name='<secretName>';
--- confirms that the secret was moved
SELECT * FROM secret WHERE name = '<secretName>';
--- deletes the secret
DELETE FROM secret
WHERE name = '<secretName>';