Same question here - from the docs it seems like storing text in the metadata is not the way to do it:
High cardinality consumes more memory: Pinecone indexes metadata to allow for filtering. If the metadata contains many unique values — such as a unique identifier for each vector — the index will consume significantly more memory. Consider using selective metadata indexing to avoid indexing high-cardinality metadata that is not needed for filtering.
I’m assuming text qualifies as high cardinality. I haven’t seen any example showing where to put text! Only thing I can assume is that it’s supposed to exist in some other DB and we retrieve it using the ID? Seems round about… so hoping there’s another answer…??