DynamoDB Table Count using Nodejs

Question

I need to get count of records in my DynamoDB table using Node.js?

Simply, How to write Node.js snippet for same?

aws dynamodb scan --table-name dev-xxx-table --select "COUNT"

Tried https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/DynamoDB/DocumentClient.html#query-property

const params = {
    TableName: Table(),
    Select: COUNT
  }

  try {
    const count = await dynamoDb.query(params).promise()

but got

"ReferenceError: COUNT is not defined",

I couldn't find anything in the documentation for the same(or finding aggregation for DynamoDB table). Any lead will be appreciated.

Nodejs sdk has scan. So what exactly is the issue?

Marcin
– Marcin

2021-08-17 05:58:24 +00:00
Commented Aug 17, 2021 at 5:58 — Marcin
– Marcin, Commented Aug 17, 2021 at 5:58

stijndepestel · Accepted Answer · 2021-08-17 06:17:18Z

3

Seems to me like there's two errors in the code, first you're using the wrong function (query instead of scan) and second, you're not passing COUNT as a String, but as a variable, which is why you're getting the error. Try the following code (untested):

const params = {
  TableName: Table(),
  Select: "COUNT",
};
const count = await dynamoDb.scan(params).promise();

That being said, be aware that this is a very expensive and probably slow operation that you do not want to be doing on a very large dataset.

answered Aug 17, 2021 at 6:17

stijndepestel

3,5742 gold badges20 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DynamoDB Table Count using Nodejs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related