This may be a very stupid question, but I can't seem to find an answer in the forums or other sites:
If I use a uuid as the partition key, how would I find the value of the uuid to perform a query if the uuid was generated on INSERT using the uuid() function?
In the academy exercises, the uuid is usually found by performing a SELECT * query with no WHERE clause and then finding a row's uuid from a visual scan. Obviously, this would only work for very small data sets.
How is this accomplished in real-world scenarios?
Would I create another table with a natural key for the partition key (such as a person's name or email) and then use the result of that query to find the uuid for my original query?
Thank you for helping me understand what I'm sure is a very simple answer.