How to use Snowflake Cortex Functions with Sigma
Table of Contents
![How to use Snowflake Cortex Functions with Sigma](https://cdn.prod.website-files.com/666bbba4ff7240a20f4cccf8/666bbba4ff7240a20f4ceae1_665f9a82ccf31084b31f0281_Snowflake-Cortex-with-Sigma.png)
Snowflake announced access to large language models (LLMs) including Mistral, Llamas 2, and Snowflake Arctic at the start of May 2024. These functions–which can be called by either SQL or Python–became instantly accessible via Sigma, Snowflake's AI Data Cloud Product Business Intelligence Partner of the Year.
Sigma’s user interface acts as a front end to cloud data platforms like Snowflake and opens up Cortex functions to the average spreadsheet user. Sigma supports all existing Snowflake Cortex functions such as COMPLETE, EMBED_TEXT, EXTRACT_ANSWER, SENTIMENT, & TRANSLATE. Sigma integrates with existing functionality to make Snowflake Cortex more accessible than ever.
Why Sigma Makes it Easy
Without any SQL or Python expertise business users can call LLMs to complete prompts, enrich and summarize data, or even translate entire columns of data.
![](https://cdn.prod.website-files.com/6614927b96b533f59ffa5473/6663363d2d6dfce8e00a713d_665d256725a906e108435e95_M1b1tuFhG0gZA7cPUG5_iagg_HS5HBjconNajT3PI0xNYNUzT6K1KQNLZFeNtiA_aQIHBAKSkLg_WET5vg7BnhqClOZ1tL-gM0aY72YPudSzLSNMJ1dII85ce0ELZn0JjV_qaOVovvsFh2mUZOZloh8.png)
Sigma Custom Functions can be wrapped around LLM prompts and put in place for business users to add data as easily as new spreadsheet calculations. Analysts, Data Engineers, Product & Business Leaders can…
- Call SENTIMENT and return a number value for a customer review.
- Ask an LLM anything with COMPLETE to query Mistral, Llamas 2, Snowflake Arctic and others.
- SUMMARIZE a block of text. (For when they don’t want to wrap text in a Sigma table)
- Use EXTRACT_ANSWER to pluck out the answer from an overly verbose LLM response. (Pairs nicely with COMPLETE.)
Sigma makes LLM functionality approachable all while keeping your data completely secure within Snowflake. No extracts and no ungoverned 3rd party AI services. Which is why we are already using Snowflake Cortex internally at Sigma.
Sigma’s Internal Use Cases with Snowflake Cortex
With Snowflake Cortex the AI revolution is just beginning. Our Sigma data team immediately saw value in adding Snowflake Cortex to our sales and support processes. Here’s how Sigma is deploying Cortex functions across our entire company:
- Sentiment enrichment of Gong calls
- Predictive account scoring for propensity to buy– Here’s where we can prompt an LLM to scrape the web for content indicators an account will buy.
Sample Prompt:
Complete, Mistral, ”Your goal is to analyze different companies across the globe and understand what they do, such that you can enable employees to have a better understanding of who they are selling to.”
- Salesforce opportunity “Why we win” analysis
- Support chat summarization
Sigma allows transparency into Snowflake Cortex costs as well. We can help track and control spend across departments, service accounts, and down to individual users.
![](https://cdn.prod.website-files.com/6614927b96b533f59ffa5473/6663363d2d6dfce8e00a7136_665d2567a2260686742c921a_Xz_4zLuyY8u_DIRlpZi5JIz3tCJOTDo29Boz2sU8hvYWdBN7FsDGTwsW7bgRBYklKW_FKOBexxkpv39cQ0SPREEWlXTWRCzy7H-9P8wnVOlz4H5WU0cYYUAZvESs92U1yVamcSKoZipl9fVqWzF0kP0.png)
Sigma and Snowflake are working together to bring the latest generation of LLMs to business users with Snowflake’s AI Data Cloud, helping customers further unlock the value of their data.
Interested in learning more about Sigma and Snowflake Cortex use cases? Learn more here.