Mastering Snowflake Objects

The previous chapter introduced the innovative architecture that powers the Data Cloud and unlocks possibilities that have never been possible in other databases. In this chapter, we will explore the database objects that Snowflake customers will use in their modeling journey. Objects such as tables and views will undoubtedly be familiar to most people who have previously worked with SQL. Still, even here, Snowflake’s unique features unlock potential efficiencies in designing physical models, so users should be well acquainted with them.

Due to its variable spend pricing, Snowflake data modeling requires users to be well acquainted with the cost/performance trade-offs of its supported objects and their parameters. For those who have never worked with Snowflake, exclusive features such as streams and external tables may still be unfamiliar. But making good design decisions demands that users have a firm grasp and a thorough understanding of Snowflake...