Handle Various Data Forms
Data modeling is very critical because it represents all the entities of the business.
In the modern cloud world, data modeling is agile and can change overtime. To support this, Snowflake handles structured and semi-structured (JSON, XML, etc.) data very well. In addition to supporting the common SQL data types (Numeric, String & Binary, Data & Time), Snowflake has VARIANT, OBJECT, and ARRAY data types to support semi structured data. All the common database DDL operations can be performed using the SQL: ANSI.
The most common concern in cloud systems is the potential risk to the data security, security of users, and access to sensitive information. Snowflake provides the network, user, and data security similar to other cloud providers. In addition, there are some great features for data recovery and secure views offered by Snowflake.
Let’s say an object was deleted accidentally. Do you think it can be recovered to the state it was in at that point of time? The answer is yes. Snowflake offers a retention period up to 90 days to recover the objects that have been deleted.
Snowflake allows you to create a secure view when sharing needs to be restricted within a required data set. Snowflake strongly recommends sharing secure views and/or secure UDFs instead of directly sharing tables so that it does not expose all the sensitive data underneath. We can also add privileges to the secure view to other groups.
I hope this post gave you an overview for the importance of cloud data warehousing and the benefits of having Snowflake for your data warehousing needs.