What is a DynamoDB FilterExpression? (for Scan and Query!)

Filter Expressions are DynamoDB's way of restricting data as part of your scan or query operations. They are very similar to WHERE clauses in SQL, but have slightly different behaviour due to the nature of NoSQL. In this video, I tell you about what FilterExpressions are, How they work, some examples, and best practices.

📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚

🎙 MY RECORDING EQUIPMENT 🎙

💻 MY DESKTOP EQUIPMENT 💻

🌎 Find me here:

#DynamoDB
#AWS
#NoSQL

[aniketsalvi]

Hello, Thanks for video.
How to use document mode in dynamoDB.

[eugeneahn]

when filtering on an attribute, it doesn't return all the qualifying records. it's really annoying. it's not because of any filter limitation as i have set that to a very high number. i only have a couple of hundred records in my dynamodb table. any idea why is it happening? found a lot of posts about this on forums. Thanks

[जैराधाकृष्ण]

Thanks; need demo of conditionalexpression while PutItem method.

[peterlyon]

Hello, thank you for the video!
I am encountering an error while using
response = table.scan(FilterExpression=

{
"errorMessage": "name 'Attr' is not defined",
"errorType": "NameError",
"stackTrace": [
" File \"/var/task/lambda_function.py\", line 175, in lambda_handler\n response = table.scan(FilterExpression=
]
}

As you said it should be pretty straight forward to query this, but I am not able to figure out why is Attr not defined. Thanks in advance!

[jawnweak]

Does it make sense to populating a new table to avoid scan operation here? e.g. to have dynamo DB stream of this table to populate another table with partition key OriginCountry and value being the set of AccountId? Just wondering if it's a reasonable approach for NoSQL, great video btw