PinnedInSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyClark Perucho·Jul 1, 2022Snowflake: 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…A response icon1A response icon1
PinnedInSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyClark Perucho·Mar 29, 2022Snowflake: Accelerate Query PerformanceSnowflake by nature is “optimized”, it stores the data granularly via micro-partitions, organized in columnar fashion. This enables…A response icon1A response icon1
PinnedInSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyClark Perucho·Oct 19, 2021Snowflake 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…
PinnedClark Perucho·Aug 1, 2021Snowflake 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…
PinnedClark Perucho·Aug 15, 2021Snowflake: Query Optimization Using Materialized ViewRequirementsA response icon1A response icon1
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyClark Perucho·Mar 1, 2023Snowflake: 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…
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyClark Perucho·Dec 24, 2022Snowflake: 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…
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyClark Perucho·Jun 20, 2022Snowflake: 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…
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyClark Perucho·May 23, 2022SnowPro Advanced: Administrator — Exam TipsEarly this year (2022), Snowflake announced a new addition to the Advanced Series of their Certification, the SnowPro Advanced…A response icon1A response icon1
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyClark Perucho·Feb 22, 2022Snowflake 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…A response icon3A response icon3