© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
R. SoniSnowflake SnowPro™ Advanced Architect Certification CompanionCertification Study Companion Serieshttps://doi.org/10.1007/978-1-4842-9262-4_6

6. Tables and Views

Ruchi Soni1  
New Delhi, India

To store data in Snowflake, users first create a database that contains one or more schemas that includes various objects such as tables, views, etc. This Snowflake object hierarchy is discussed in detail in Chapter 14. Understanding different types of Snowflake tables and views and their specific business use case is very important for Advanced Architect exams. Hence, in this chapter, let’s do a deep dive into both these objects.

Snowflake Tables

Snowflake stores ...

Get Snowflake SnowPro™ Advanced Architect Certification Companion: Hands-on Preparation and Practice now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.