Published inSnowflake·PinnedMember-onlySnowflake: 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 — you pay only for the storage and compute that you actually use, however this phrase is not necessarily accurate when we’re talking about storage, you could…Snowflake5 min readSnowflake5 min read
Published inSnowflake·PinnedMember-onlySnowflake: Accelerate Query PerformanceSnowflake by nature is “optimized”, it stores the data granularly via micro-partitions, organized in columnar fashion. This enables fine-grained partition pruning and effective scanning of individual columns (only the columns referenced by a query are scanned). Snowflake also takes care of compression and statistics collection which are performed automatically as…Snowflake5 min readSnowflake5 min read
Published inSnowflake·PinnedMember-onlySnowflake 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 have location-specific data access restriction. …Snowflake4 min readSnowflake4 min read
PinnedMember-onlySnowflake 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 ordeal. Like when we thought we've updated a small chuck of a table and later realised that we missed defining a WHERE clause. …Snowflake5 min readSnowflake5 min read
PinnedMember-onlySnowflake: Query Optimization Using Materialized ViewRequirements Snowflake Enterprise edition and up. CREATE MATERIALIZED VIEW privilege on the Schema where the MV will be created. SELECT privilege on the MV’s source table. SELECT privilege on the MV itself (Only if you will directly query the MV) Snowflake Dynamic Optimization Before we get into the Materialized View, it is important to…Snowflake6 min readSnowflake6 min read
Published inSnowflake·Mar 1Member-onlySnowflake: 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 that allows Snowflake virtual warehouses to have essentially boundless amount of resources as it needs to accelerate parts of queries. What is Query Acceleration Service? It’s a common situation where a virtual warehouse…Snowflake5 min readSnowflake5 min read
Published inSnowflake·Dec 24, 2022Member-onlySnowflake: 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 I looking to get at the end of it? …Snowflake5 min readSnowflake5 min read
Published inSnowflake·Jun 20, 2022Member-onlySnowflake: 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 neglected. Today I’m hoping to uncover other benefits of using it and share how it’s helping me day by day. If you’re not familiar…Snowflake Data Cloud3 min readSnowflake Data Cloud3 min read
Published inSnowflake·May 23, 2022Member-onlySnowPro Advanced: Administrator — Exam TipsEarly this year (2022), Snowflake announced a new addition to the Advanced Series of their Certification, the SnowPro Advanced: Administrator! The Beta version was up for the whole of March and the refined final version will be released on June! I was looking forward to this as it is relevant…Snowflake Data Cloud5 min readSnowflake Data Cloud5 min read
Published inSnowflake·Feb 22, 2022Member-onlySnowflake SWAP WITH: The Common MisconceptionSnowflake supports swapping two tables using the ALTER TABLE … SWAP WITH command. It is however very easy to make assumptions that are completely different from what it actually does. …Snowflake3 min readSnowflake3 min read
