I am currently planning out how to best handle separating out client data. The most obvious answer is to pay for several databases, but I was curious if there was some way to have one database and somehow have different tables to separate data. The database is only open to the AWS Gateway so in theory with proper precautions I control the queries and show table data to only those authorized to see their tables. It would seem I could change the name of the edge gateway, which would trigger a new table, but is there any other way to accomplish this or is this the only way to create new tables?
Another scenario I can imagine is if say we wanted to separate data for a location change. This would be a good reason for separating a table.