PinnedClark PeruchoinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake: Minimize Storage CostThe two main drivers of Snowflake cost are storage and compute; The good thing about Snowflake pricing is that all charges are usage-based…5 min read·Jul 1, 2022--1--1
PinnedClark PeruchoinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake: Accelerate Query PerformanceSnowflake by nature is “optimized”, it stores the data granularly via micro-partitions, organized in columnar fashion. This enables…·5 min read·Mar 29, 2022--1--1
PinnedClark PeruchoinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Data Protection: Incorporate Object-Tagging With Data Masking PolicyOn large, global enterprises collecting, processing and providing data to and from multiple locations across the world, it is common to…·4 min read·Oct 19, 2021----
PinnedClark PeruchoSnowflake Time Travel: A Window To The PastLet's face it, we make mistakes. Sometimes, even when we're just trying to fix a minor issue, we end up escalating it to an even greater…·5 min read·Aug 1, 2021----
PinnedClark PeruchoSnowflake: Query Optimization Using Materialized ViewRequirements·6 min read·Aug 15, 2021--1--1
Clark PeruchoinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake: Query Acceleration Service — The Warehouse BoosterThe Query Acceleration Service (QAS) is now generally available to all Snowflake Accounts — Enterprise edition and up. It is a feature…·5 min read·Mar 1, 2023----
Clark PeruchoinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake: Query Tuning GuideBefore we dive into the steps of query optimization, it is important to ask ourselves this question: Why do I need to tune queries? What am…·5 min read·Dec 24, 2022----
Clark PeruchoinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake: EXPLAIN is more than just explanationsI’m using EXPLAIN in my day to day life as a Snowflake Administrator. It is a simple and straightforward feature which makes it easy to be…·3 min read·Jun 20, 2022----
Clark PeruchoinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowPro Advanced: Administrator — Exam TipsEarly this year (2022), Snowflake announced a new addition to the Advanced Series of their Certification, the SnowPro Advanced…·5 min read·May 23, 2022--1--1
Clark PeruchoinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake SWAP WITH: The Common MisconceptionSnowflake supports swapping two tables using the ALTER TABLE … SWAP WITH command. Is it however very easy to make assumptions that are…·3 min read·Feb 22, 2022--3--3