Table Types and Views

Snowflake Architecture

Emily Melhuish

Technical Curriculum Developer, Snowflake

Table Types and Views

Table Types.png

Views.png

Snowflake Architecture

Permanent, Transient and Temporary

Groups showing the table types

timeline.png

Snowflake Architecture

Permanent, Transient and Temporary

table_types.png

Snowflake Architecture

Dynamic, External, and Hybrid

See dynamic, external and hybrod

Snowflake Architecture

Dynamic, External, and Hybrid

dynamic_external_hybrid_v2.png

Snowflake Architecture

Apache Iceberg™

Apache Iceberg open table format

Snowflake Architecture

Apache Iceberg™

iceberg_managed.png

Snowflake Architecture

Time Travel and Fail-safe (with table types)

Time Travel

  • Way to recover data

Timeline showing now and 90 days ago

Fail-safe

  • Separate, short safety net after that window

Timeline showing options

Snowflake Architecture

Standard View and Materialized View

See view and materialised view

Snowflake Architecture

Secure View

Secure views

Snowflake Architecture

Let's practice!

Snowflake Architecture

Preparing Video For Download...