[NoSQL Workbench] can't query GSI or scan with BETWEEN using string ISO Dates

Question

So for instance I can run this query
aws dynamodb query \
    --table-name ######## \
    --index-name eventName-createdAt \
    --key-condition-expression "eventName = :eventName AND createdAt BETWEEN :start AND :end" \
    --expression-attribute-values '{
        ":eventName": {"S": "orlando"},
        ":start": {"S": "2024-10-22T12:00:00.000Z"},
        ":end": {"S": "2024-10-23T00:00:00.000Z"}
    }' \
    --select "COUNT" \
    --profile #####

And I get the results I want.
However when I plug this same query (sans COUNT) into the NoSQL Workbench it just returns everything in the table.

This is on Win 11, Version 3.13.2

re:Post Agent · Answer

The issue you're experiencing with NoSQL Workbench not properly handling queries on Global Secondary Indexes (GSIs) or scans with BETWEEN using string ISO dates is likely a limitation or bug in the current version of the tool.

NoSQL Workbench is designed to provide a graphical interface for developing and testing queries for Amazon DynamoDB, including support for complex operations. However, it appears that the tool may not be correctly interpreting or executing the BETWEEN condition for string-based date fields in the context of GSIs.

Given that the AWS CLI command works as expected, the problem seems to be specific to NoSQL Workbench's implementation. This could be due to how the tool processes date strings or handles certain types of complex queries on GSIs.

As a workaround, you might consider:

1. Using the AWS CLI or AWS SDKs for these specific types of queries until the issue is resolved in NoSQL Workbench.

2. Checking if there's a newer version of NoSQL Workbench available, as the issue might have been addressed in a recent update.

3. Reporting this as a bug to AWS support or through the AWS forums, providing details about your query and the unexpected results you're getting in NoSQL Workbench.

4. Trying to modify the query in NoSQL Workbench to use a different date format or query structure that might be more compatible with the tool's current capabilities.

It's worth noting that while NoSQL Workbench is a powerful tool for DynamoDB development, it may occasionally have limitations or discrepancies compared to direct API calls or CLI commands, especially for more complex query scenarios.  
**Sources**  
[NoSQL Workbench for DynamoDB - Amazon DynamoDB](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/workbench.html)  
[Exploring datasets and building operations with NoSQL Workbench - Amazon DynamoDB](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/workbench.querybuilder.html)  
[Release history for NoSQL Workbench - Amazon DynamoDB](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/WorkbenchDocumentHistory.html)

[NoSQL Workbench] can't query GSI or scan with BETWEEN using string ISO Dates

Add your answer

Relevant content