Question
How well does rockset work with dynamodb single table design? Do you have any customers who currently use this design pattern? Would rockset work better with multiple dynamo tables?
Answer
You can use single table modeling with Rockset using DynamoDB as a source. Most users using this model have implemented Rockset Views to provide a relational model for SQL development. You can find more information on views here: Views and Aliases.
Rockset would also work well with a multiple table model as we support Joins just like a standard SQL database. Using Views on a single collection can give you the same model and you can join multiple views together as needed. The performance should be about the same as long as you have an equality condition in your views to separate each table in the collection.