Road to Snowflake SnowPro Core Certification: Tables & Views

Sixth Chapter: Tables & Views

Sixth Chapter of the Snowflake SnowPro Core Certification Complete Course.

As we saw in the chapter on Snowflake Architecture, a Database contains Schemas, which contain other objects. This chapter will discuss two of the most important ones in more detail: the tables and the views.

1. Tables
2. Views
3. Typical Exam Questions

Remember that all the chapters from the course can be found in the following link.

TABLES

Tables are database objects that contain all the data, like in any other SQL language. There are different types of tables, and there are some differences between them, which are shown in the following diagram:

Difference between Snowflake tables.

Permanent tables

The tables that we can create on Snowflake by default. They have the following characteristics:

• 0–90 days of Time Travel (Enterprise Edition necessary, 0–1 in Standard Edition).
• Seven days FAIL-SAFE.
• You can create a temporary, transient, or permanent table as a clone from permanent tables. If…