INSTALL dynamodb FROM community;
LOAD dynamodb;

-- Create a DynamoDB secret based on the credential_chain
CREATE OR REPLACE SECRET dynamo_secret (
  TYPE dynamodb
);

-- Query a DynamoDB table called 'orders'. The table has a GSI on status, to which this query restricts results. 
FROM dynamodb_scan('orders')
WHERE status='ACTIVE';

-- Perform a SUM aggregation on a full table, without a GSI or PK. This requires setting allow_full_scan to true.
SELECT SUM(amount) 
FROM dynamodb_scan('orders', allow_full_scan=True) 
WHERE createdAt::timestamp > '2026-05-01 00:00:00'::TIMESTAMP;