Want to read 25 Million records of Data (3.656384GB) through DynamoDB which method should i apply on demand or provisioned , can someone plz help with how much will it cost?

On-demand

Price

On-demand pricing for reads is $0.25 per million read request units.

1 read unit is defined as one strongly consistent read of an item which is up to 4KB in size.

Cost

• Read units required: (3.656384 gigabytes) / (4 kilobytes) = 914 096 read units

• Strongly Consistent: 914096 * 0.25 / 1000000 = $0.22

• Eventually Consistent: 914096 * 0.25 / 1000000 / 2 = $0.11

Provisioned

Price

Provisioned pricing is $0.00013 per RCU per hour.

Cost

• Read units required: Depends how quickly you need to read the data. Lets assume you can consume 250 RCU, that would allow you to read the data in approximately 1 hour

• Strongly Consistent: 250 *0.00013 = $0.03

• Eventually Consistent: 250 *0.00013 / 2 = $0.016

Advice

My advice to you is to make yourself familiar with the Pricing Docs and also with the DynamoDB Capacity Docs, that will help you make the choice based on your specific needs.

The easiest pricing model to understand is on-demand because it's based only on usage. Also there's no need to move a provisioned amount up or down, which is great when you want to do some rare activity.

To scan 3.6 GB in on-demand mode will require approximately 3,600,000,000 bytes / 4,096 per read-request-unit / 2 for eventual consistency = 439,453 read request units. The price in us-east-1 for these is you get a million for 25c. That means it's about 12 cents to do a full table scan of a 3.6 GB table.

I'd leave the table as on-demand and with 5 full scans a month you're under $1.