This is part 2 of the Snowflake Massive Scale Testing project I wrote a month back and am eager for you to check it out. The first part of this work is in the link below: Snowflake Massive Scale Testing — Part 1 WARNING… READ AT YOUR OWN RISK! USE AT YOUR OWN RISK!!johnthuma.medium.com A quick background: A customer of mine, while I was working at Snowflake, wanted…

A couple of weeks ago a customer of mine wanted to know how to auto provision a user from their SCIM/SSO integration. What they wanted to do was auto provision a sandbox schema for the user. I had already shared my Sandbox script with the user which is located here: …

Should I go with Snowflake or Databricks? I hear this almost every day. It is a very important question. It is like the truth between any two foes: There is one version of the truth from one perspective, there is another version from the opposing perspective; then there is the…

SnowPark is a new feature Snowflake recently announced at Snowflake Summit. It enables data engineers, data scientists, and developers to use Python, Scala, and Java to build processes that can be pushed down into the Snowflake environment. Most data scientists and data engineers do not prefer to use SQL and…

Data Pipelining and Change Data Capture: In databases, change data capture (CDC) is a set of software design patterns used to determine and track the data that has changed so that action can be taken using the changed data. CDC is an approach to data integration that is based on…

Classification enables answering questions about the data stored in tables and views, such as: Does the table/view contain PII (Personally Identifiable Information) or sensitive data? Where is the data stored and how long has it been stored? How can the data be protected from exposure while still deriving insights? The…

Ever need to hide something? Work for a government? Need to redact things like Social Security Numbers, birthdays, addresses, or any other kind of personal data? Snowflake has a feature called Dynamic Data Masking that will allow you to do just that! But it will also allow you to let…

Note: This feature is in Private Preview What is Unistore? Probably the biggest announcement to come out of Snowflake Summit this year! That is what Unistore is! I am excited and this feature will change the way customers use Snowflake. Don’t worry you don’t have to change what you already have. The Unistore/Hybrid tables can be used…

Hurricane Ian is on its way! What a great time to discuss forecasts! In Snowflake, you can produce a forecast for a univariatetime seriesby using the FORECAST function. The FORECAST function is a shared user-defined table function (UDTF) that you access by installing a Snowflake Native Application. When you call…