Recent Snowflake feature improvements mean that it’s becoming easier to generate monitoring and administrative email notifications from within the platform. Welcome to the latest edition of Snowflake in a Nutshell, where we will explore: The new SYSTEM$SEND_EMAIL() Stored Procedure* It’s close companion, the NOTIFICATION_HISTORY table function But first, let’s take…

Welcome to the latest edition of Snowflake in a Nutshell, where we explain various Snowflake topics in straight forward terms. Today’s topics are “The Snowpipe Streaming API & Dynamic Tables”. These features were originally announced at the Snowflake 2022 World Summit (Dynamic Tables originally labelled as Materialized Tables), and in…

One of the many new feature announcements at this year’s Snowflake Summit was Snowflake Unistore Hybrid Tables. The Hybrid Table offering stores data to support fast single-row transactions along with storing the data in columnar format. In other words: The data is stored to support both operational and analytical workloads …

Data sharing including cloud-based data marketplaces are appearing at a growing rate to match data consumers with the right data suppliers. Data sharing has a long history in academic, research, and public policy circles. In more recent years it has made enormous inroads into private enterprises. Direct data sharing between…

“Organizations cannot just pump out data for the sake of data and hope that maybe someone will find it”- Jaimie Boyd, Chief Digital Officer for the government of British Columbia during the Summer of Open Data. The Summer of Open Data which took place in 2020, brought together Open Data…

Looking at the new Access History functionality through the eyes of the great detective! — Sherlock Holmes, the fictional private detective, uses a combination of observation, deduction, forensic science, and logical reasoning to investigate cases. He applies these facets to great effect in solving those cases. This process is known as “Holmesian deduction”. We can use various facets of Data Governance as inputs into investigating…