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…Jul 1, 20221Jul 1, 20221
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…Mar 29, 20221Mar 29, 20221
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…Oct 19, 2021Oct 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…Aug 1, 2021Aug 1, 2021
PinnedClark PeruchoSnowflake: Query Optimization Using Materialized ViewRequirementsAug 15, 20211Aug 15, 20211
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…Mar 1, 2023Mar 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…Dec 24, 2022Dec 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…Jun 20, 2022Jun 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…May 23, 20221May 23, 20221
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…Feb 22, 20223Feb 22, 20223