John RyanAchieving Time Travel Mastery in Snowflake: Useful Tips and StrategiesThis article will explain what you need to know about time travel in Snowflake. In addition to explaining what it is and how it works…Aug 51Aug 51
John RyanSnowflake Best Practices: Time Travel, Fail-safe and Data RetentionIn my previous article on Snowflake Time Travel, I explained the basics of how Snowflake deploys data versioning at the micro-partition…Aug 5Aug 5
John Ryan10 Effective Strategies to Lower Snowflake Costs while maximizing qHaving worked at Snowflake for nearly five years, I’ve seen many customers make avoidable but understandable mistakes and waste vast…Jul 29Jul 29
John RyaninSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceTurbo-charge Snowflake Query Performance by Avoiding Spilling to StorageThis article will demonstrate how a simple Snowflake virtual warehouse configuration change can turbo-charge your query performance, with…Feb 125Feb 125
John RyaninSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceTop Snowflake Data Engineering Best PracticesThis article is a summary of the most popular blog I've ever written: Top Snowflake ETL Best Practices for Data Engineers published on my…Dec 5, 20221Dec 5, 20221
John RyaninSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceWhat is Snowflake Query Acceleration Service?What is Snowflake Query Acceleration Service?Nov 28, 20221Nov 28, 20221
John RyaninSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Dynamic Data Masking Best PracticesThis article describes Dynamic Data Masking in Snowflake and indicates the best practices to implement data masking policy. Using the…Aug 2, 2022Aug 2, 2022
John RyaninSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceWhat are Snowflake Hybrid Tables and Unistore?Snowflake Hybrid Tables were announced in the June Summit of 2022 and represent a seismic shift in database technology. For the past 40…Jun 18, 20221Jun 18, 20221
John RyaninSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceIntroducing Snowflake Role Based Access ControlCredit: Georg Brommeli , Unsplash.Apr 2, 2022Apr 2, 2022
John RyanBuilding near real-time pipelines with SnowflakeBuilding real-time data pipelines are hard. Data needs to be captured, transformed, and analyzed within minutes. The Snowflake database…Jul 23, 2020Jul 23, 2020