Cortex Sentiment

The Cortex Sentiment transformation component uses Snowflake Cortex to analyze English-language input text and return a sentiment for that text. The returned sentiment is one of the following strings:

• unknown: The component cannot determine the sentiment.
• positive: The sentiment is positive.
• negative: The sentiment is negative.
• neutral: The sentiment is neither positive nor negative.
• mixed: The sentiment is both positive and negative.

To use this component, you must use a Snowflake role that has been granted the SNOWFLAKE.CORTEX_USER database role. Read Required Privileges to learn more about granting this privilege. To learn more about Snowflake Cortex, such as availability, usage quotas, managing costs, and more, read Large Language Model (LLM) Functions (Snowflake Cortex).

​

Use case

This component can be used to analyze responses in a number of industries. The Example section of this guide shows how it could be used in the hospitality industry to analyze reviews of a coffee shop. You could also use it to analyze online product reviews, customer satisfaction survey responses, or employee engagement survey answers, to name a few examples.

---

​

Properties

​

Example

A coffee shop has been collecting customer reviews left on a website, and wants to obtain a sentiment for each review so that they can more easily sort them and focus on their positive and negative reviews. Today’s reviews look like this: Input data: The shop can use the Cortex Sentiment component to generate a sentiment from the review text. The sentiment indicates the level of negative or positive sentiment in the input text, and can then be used to sort the reviews. Cortex Sentiment component properties:

• Columns: REVIEW
• Include Input Columns: YES

By setting Include Input Columns to YES, the original columns from the table will be kept as part of the pipeline run, and the sentiment column is appended to the end of the table. Output data: