how to get total row count in dynamodb?

Question

In MySQL total number of rows found using "select count(*) from TABLENAME".

Similarly, how to get total number of rows in dynamodb table. using metrics is possible to know total number of rows.

Possible duplicate of How can I get the total number of items in a DynamoDB table? — dmulter
– dmulter, Commented Feb 22, 2019 at 16:10
how can i get today or particular date added records count only — samson
– samson, Commented Feb 25, 2019 at 13:46

F_SO_K · Accepted Answer · 2019-02-22 12:42:29Z

3

If you just want to know the count, and don't need the number programmatically, go into the DynamoDB console, click on the table, and it will show you the item count

answered Feb 22, 2019 at 12:42

F_SO_K

15k6 gold badges64 silver badges90 bronze badges

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

1 Comment

Charles Over a year ago

note the count shown is roughly 6hrs behind (fine print out the bottom) "live count" can be done to update the count...but it runs a scan and consumes RCU

Charles · Accepted Answer · 2019-02-22 15:43:32Z

0

If you don't mind a count that's roughly 6 hours behind, then Stu's answer works. IIRC, it's available programmatically also.

But if you want real-time counts, re-think your need for them ;)

If you really, really, need them, configure a DDB stream to a lambda that will update another DDB table (or a row in the table in question) with the record count and any other aggregate info you want to track. A GSI is often useful here as discussed in Using Global Secondary Indexes for Materialized Aggregation Queries

answered Feb 22, 2019 at 15:43

Charles

24.2k3 gold badges23 silver badges50 bronze badges

Collectives™ on Stack Overflow

how to get total row count in dynamodb?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related