DynamoDB PartiQL vs. Scan

Question

Hello,

Is there a rule for the PartiQL queries on DynamoDB Sort Keys (e.g. indexes on SK) ?   
The below query does not return anything from Table1 with Sort Key Table1SK and with condition on SK, while a scan on same table with filter `'level1#level2#level3#'` on SK, returns records.  
```
select Table1SK
from Table1
where begins_with("Table1SK", 'level1#level2#level3#')
```  
Thank you,  
Mihai ADAM

Oleksii Bebych · Answer

To correctly query using PartiQL, ensure you include the partition key:
```
SELECT Table1SK
FROM Table1
WHERE Table1PK = 'somePartitionKey' AND begins_with(Table1SK, 'level1#level2#level3#')
```
Here, Table1PK should be replaced with the actual partition key attribute name and 'somePartitionKey' with the specific partition key value you want to query.

DynamoDB PartiQL vs. Scan

Contenuto pertinente