athena_ddb_queries.txt

SELECT 
    Item.OrderId.S as OrderId,
    Item.CustomerId.S as CustomerId,
    Item.OrderDate.S as OrderDate,
    Item.State.S as State,
    Item.TotalAmount.N as TotalAmount,
    Item.CancelledReasons.L as CancelledReasons,
    Item.CancellationMetadata.M as CancellationMetadata
FROM data;


SELECT 
    Item.OrderId.S as OrderId,
    Item.CustomerId.S as CustomerId,
    Item.OrderDate.S as OrderDate,
    Item.State.S as State,
    Item.TotalAmount.N as TotalAmount,
    Item.CancelledReasons.L as CancelledReasons,
    Item.CancellationMetadata.M as CancellationMetadata
FROM data
WHERE Item.CustomerId.S = 'CID-100'


SELECT 
    Item.OrderId.S as OrderId,
    Item.CustomerId.S as CustomerId,
    Item.OrderDate.S as OrderDate,
    Item.State.S as State,
    Item.TotalAmount.N as TotalAmount,
    Item.CancelledReasons.L as CancelledReasons,
    Item.CancellationMetadata.M as CancellationMetadata
FROM data
WHERE Item.CustomerId.S = 'CID-100' AND Item.OrderId.S = '5'

SELECT Item.CancellationMetadata.M.canceldate.S as CancelData from data;


SELECT transform(Item.CancelledReasons.L, i -> i.S) AS CancelledReasons FROM data
WHERE (
    contains(transform(Item.CancelledReasons.L, i -> i.S), 'ITEM_DAMAGED')
);