In this book, readers will learn the Snowflake architecture with an excellent level of detail. Readers will also learn the clever tricks and tips that make Snowflake unique, including failsafe, time travel, and min-max pruning. In addition, Reader can create all types of Snowflake tables and views and learn how to performance tune Snowflake tables and queries. Readers will also gain significant knowledge of SQL, starting at the most basic level and building to intermediate and advanced levels. Advanced topics include date functions, non-structured data (JSON), advanced analytics, User Defined Functions (UDF), and Stored Procedures. There are over 600 examples of managing Snowflake and SQL. The book is 90% hands-on examples. The readers can download and use the SQL_Class database with 28 tables representing the tables in the book.
