A Gen AI Specialist is building a pipeline in Snowflake to gather data that will be used to summarize customer chat messages.
The following table, CHAT_MESSAGES, was created:
| CONVERSATION_ID | MESSAGE_TEXT |
| :--- | :--- |
| 1 | Hi, I need help with my order. |
| 2 | It’s not been delivered yet. |
| 2 | How can I reset my password? |
| 3 | I received the wrong item. |
| 3 | Can I exchange it? |
The Specialist wants to use the Snowflake Cortex COMPLETE function with the llama3-8b model to generate a summary of each conversation. The prompt should begin with: "Summarize this chat:" followed by the full text of all messages in that chat conversation.
Which query will achieve this?
```sql
Submit