Understanding how Snowflake works helps you develop your strategy for implementing your contribution to the Snowflake Data Cloud. Snowflake is optimized for data warehouses but not OLTP. The distinction is clearly explained in this chapter. For the curious, search for micro-partitions.
Information is presented early in this book to clarify what is happening “under the hood” as you work through the sample code presented in later chapters. This chapter begins our deep dive into technical matters, and we focus on some ...