A database is a well-organized collection of information, or data, stored electronically on a computer. Think of it like a digital version of a highly organized filing cabinet. Instead of paper files, a database uses digital tables, and instead of manually searching through drawers, you use special commands called queries to quickly find the information […]
Understanding different types of views in Snowflake What is a View Views in snowflake are basically virtual tables and are result of a query acting just like a table. Views provides an abstraction over a query and are able to hide the actual data providing limited or only required information access, hiding complex logic etc.
Views In Snowflake – Protect the data Read Post »
Zero copy cloning is an interesting feature providing benefit of creating a copy of object without physically copying data.
Zero Copy Cloning – An Interesting feature Read Post »
What is Caching? Caching in snowflake is one of the query performance improvement techniques which is achieved by keeping or maintaining frequently accessed data in the memory. Since data can be accessed quickly from memory or SSD, it truly provides a performance improvement for data access. Quick Walkthrough of Snowflake Architecture should be understood before
Caching in Snowflake – Quick Results Read Post »
Time Travel is an excellent feature provided by Snowflake to restore deleted data
Time Travel and Fail Safe – Recover and Restore your data. Read Post »
Snowflake offers different types of tables to be created. Understanding types of tables in Snowflakes Permanent Table Temporary Table Transient Tables Note Ref : Snowflake Website External tables Iceberg Table An Iceberg table leverages the Apache Iceberg open table format specification, offering an abstraction layer over data files stored in open formats. It supports various
Types of tables in Snowflake – Suffice every Requirement Read Post »
This article provides more information about the data clustering in snowflake.
Data Clustering – Efficient Sorting and Storage Read Post »
The Snowflake Data Platform utilizes an innovative partitioning method known as micro-partitioning. This approach offers the benefits of static partitioning while circumventing its recognized constraints, along with delivering further substantial advantages. What is Micro-partitioning or Micro-Partitions? In Snowflake tables, all data is stored into micro-partitions, which represent continuous storage units. Each micro-partition contains uncompressed data
Snowflake Micro-Partitioning – Better way of Storage Read Post »
This article provides more information about best practices to be followed when selecting a virtual warehouse and from developers point of view.
This article provides more information about Multi cluster warehouse
Multi-Cluster Warehouse – Efficient Workload Management Read Post »
