Snowflake - Functional Architecture




Snowflake - Functional Architecture

Snowflake supports structured and semi-structured data. Snowflake organizes and structures the data automatically once data loading is completed. While storing the data, Snowflake divides it on his intelligence and saves into different micro-partitions. Even Snowflake stores data into different clusters.

At functional level, to access data from Snowflake, the following components are required −

  • Choose proper roles after logging

  • Virtual Warehouse known as Warehouse in Snowflake to perform any activity

  • Database Schema

  • Database

  • Tables and columns

Snowflake provides the following high-level analytics functionalities −

  • Data Transformation

  • Supports for Business Application

  • Business Analytics/Reporting/BI

  • Data Science

  • Data Sharing to other data systems

  • Data Cloning

The following diagram shows the functional architecture of Snowflake −

The symbol of "settings" as in each block can be referred as Warehouse and XS, XXL, XL, L, S as sizes of warehouse requires to perform different operations. Based on requirement and usage, the size of a warehouse can be increased or decreased; even it can be converted from single cluster to multi-clusters.

Snowflake - Functional Architecture



Frequently Asked Questions

+
Ans: Snowflake - Data Architecture view more..
+
Ans: Snowflake - Introduction view more..
+
Ans: Snowflake Tutorial view more..
+
Ans: Snowflake - Functional Architecture view more..
+
Ans: Snowflake - How to Access view more..
+
Ans: Snowflake - Editions view more..
+
Ans: Snowflake - Pricing Model view more..
+
Ans: Snowflake - Objects view more..
+
Ans: Snowflake - Table & View Types view more..
+
Ans: Snowflake - Login view more..
+
Ans: Snowflake - Warehouse view more..
+
Ans: Snowflake - Database view more..
+
Ans: Snowflake - Schema view more..
+
Ans: Snowflake - Table & Columns view more..
+
Ans: Snowflake - Load Data From Files view more..
+
Ans: Snowflake - Sample Useful Queries view more..
+
Ans: Snowflake - Monitor Usage and Storage view more..
+
Ans: Snowflake - Cache view more..




Rating - NAN/5
489 views

Advertisements