I'm new to DynamoDB, we are recently looking for options to migrate our existing MySQL applications to DynamoDB. Since DynamoDB limits the table count to 256 per AWS region. We have multiple micro-services Eg: service for orders, Quotes, Product costing, Service support etc. So now even for a single customer We need to create tables = # of micro service. Hence we will be reaching this limit of 256 soon. As I'm new I'm learning about the Data modeling. Is there any way to model our DB to make it robust in such a way it supports multiple application.
You should try and make sure that items have a common relationship for items (i.e. they're all order records vs a single table containing orders, products and CMS content) vs using them as a multi purpose table to handle what is essentially multiple tables records compounded together with no relation.
The 256 table limit, is actually a soft limit.
For any AWS account, there is an initial quota of 256 tables per AWS Region.
You can contact AWS support to request an increase, this is simply to prevent a new user who might not be aware of how the service works from creating a substantial number of resources and incurring large costs.
I suggest going through with contacting AWS support to increase this quota, and then continue with architecting your tables for the purpose they should be used for.
Also take a look at Best Practices for Designing and Architecting with DynamoDB.