Thanks , Join seems good idea.
I have a query on the same as we use stream technology of current data like customer in one db and stream to ES .
so will it be the "join" in mongo/dynamodb stream alone or both ES and mangodb/dynamodb . as we use stream of dynamodb to ES of customer details .
ie., we store the customer details in seperate db like mongodb /dynamodb and stream details to elasticsearch ,ES is used for search faster query .
in this case, can we still keep customer details in mongo/dynamo and add their photo details alone directly in elastic search by updating the mapping/index in elastic search directly ( directly means without stream of photo details) so do the join of customer table stream in mango /dynamodb and the customer id and images details directly in ES ?
storing binaary images base64 in dynamo or mango ie., having joins in mangodb/dynamo with images and then streaming in ES may be bad idea as the images size is large and has constrain in dynamodb like 400kb per item
please advise ?