Sentiment Analysis is a powerful feature, either as a standalone tool for something like monitoring product reviews, or part of a larger solution like a Customer 360. Building a simple example of this using Snowpark and Python is really easy and so for Snowflakes Build 2022 Dev Summit, I created…

As data analysts, we often find ourselves needing specialized functions in Snowflake. Working in Financial services, there are specific Excel functions that provide significant value. I had a need but developer resources were not readily available… Until ChatGPT changed everything! What is Chat GPT? ChatGPT is a large language model trained by OpenAI that…

With the coming demise of cookies and other online identifiers, there has been a lot of interest surrounding the increasing importance of first-party data for brands. Recognizing its strategic importance, brands are going to great lengths to increase their first-party data: Molson Coors recently released a direct to consumer zero-proof…

Read Time:1 Minute, 54 Second During this post we will discuss about COPY and UNLOAD the data into snowflake via Javascript procedure. As per the requirement, Process should create the Stage in Database based on the input pass to the procedure. Once the stage is created, process should load the…

Snowflake Object Identifier Requirements Working with column identifiers in Snowflake that require case sensitivity can be difficult. This behavior is described in the Identifier Requirements documentation. Still, it can be slightly confusing for users learning Snowpark for Python to grasp how we can work with these lower or mixed-case columns. In this article, I’ll…

Today in this article, I will be focusing on how we can model our entire snowflake database in just a few clicks and begin taking advantage of all the time-saving features that SqlDBM delivers. Executive Summary Creating a project Reverse engineering from a Snowflake database Configuring project defaults and the look and…

In today’s retail industry, the pressure to efficiently manage the supply chain has never been greater. With ever-changing consumer behavior and channel choices, retailers must navigate through a number of challenges such as avoiding excess inventory and stock-outs, maintaining order profitability, and responding to disruptions. …

It’s no coincidence that ChatGPT gained 1 million users in 5 days. Just about everybody in or around tech has awareness of it at this stage. While the possible use cases are vast, we will focus on using ChatGPT as an assistant for coding on the Snowflake Data Cloud. We…

Read Time:1 Minute, 27 Second During this post we will discuss an interesting use case about SHARES. With Data Sharing, the customer doesn’t create a copy of a dataset and moves it across organizational boundaries. Consider the scenario when you have multiple data SHARES object in your Snowflake Account. …