For the longest time, I've been using the interaction_log table to quickly and simply query real user utterances - i.e. "how many people typed in "x" to VA?" - but I'm finally asking for help after being frustrated by the 40 character limit on the Utterance field on that table which truncates many utterances.
I'm sure one option is to simply expand the max length on that table - no idea why it's so small ootb - but that only addresses data going forward and still I have to imagine that there's a better ootb table for this real data.
I'm aware of the open_nlu_predict_intent_feedback table which is incredibly valuable in debugging user utterances and their predictions - but the problem with this table is that individual utterance entries are not unique. i.e. if one utterance results in two predictions, there will be two entries in the table.
For this scenario I'm asking about, I just want to know each utterance that's used - I don't care about the predictions nor do I want to do data manipulation/exports to cull the non-unique entries. This may be a really simple and obvious question, but what table gets me this data?
