NLP Dialogflow to BigQuery Connection

[gaurya95]

Hello,

I am from TAP team and I am currently exploring what it takes to send the intent to the NLP table in BigQuery from DialogFlow. At the backend, I can currently see the nlp_results table which is being populated with the classification related information. However, this table doesn't have the actual message for which the classification was done( the message body).

I tried using a join on the messages table which has the body of the messages, however, there is no unique key bw both the tables. The uuid which seemed to be the unique key, is practically not the unique key as for the nlp_results table it only has one distinct value.

Do let me know how to achieve what I am trying to achieve here.