Databases are repositories of sensitive, confidential, and valuable business data. databases contain the gold of every organization. Successful businesses not only supply accurate and timely data, but they must also safeguard data as well. Security provides a critical competitive edge for any high-functioning database. …

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…