ARTICLES


SNOWFLAKE AND SLACK INTEGRATION

Receiving notifications from Snowflake directly to your email is certainly helpful. However, centralizing these notifications can streamline processes and reduce reliance on individual team members… Continue reading ->


5 PERFORMANCE TIPS IN SNOWFLAKE

Snowflake holds the data in columnar format in the micro-partitions. Fetching all the columns will result in fetching all the micro-partitions. Continue reading ->


IMPLEMENTATION OF SNOWFLAKE OBJECT TAGGING WITH DBT MACROS

Object tagging extends beyond GDPR compliance, offering any kind of classification of Snowflake objects such as dynamic data masking, sensitive data and dependency tagging, project-based object classification, grouping virtual warehouses for better performance and anything you can come up with when it comes to object classification. Continue reading ->


ARCHITECTURE BEHIND TIME TRAVELLING IN SNOWFLAKE

Micro-partitions are where pre-indexed, fine-grained data is stored in columnar format along with metadata statistics in 16 MB variable length data chunks. They are written in immutable files in database storage layer… Continue reading ->