Snowflake Object Type Hierarchy

2022-09-10 snowflake

This diagram summarizes the basic concepts in Snowflake:

  • Accounts
  • Database
  • Schema
  • Tables
  • Views
  • Stages
  • File Formats
  • Sequences
  • Stored Procedures
  • UDF(s)
  • Streams
  • Tasks
Snowflake Account
[Not supported by viewer]
Database
[Not supported by viewer]
Database
[Not supported by viewer]
Database
[Not supported by viewer]
Schema
[Not supported by viewer]
Schema
[Not supported by viewer]
Schema
[Not supported by viewer]
Tables
[Not supported by viewer]
Views
[Not supported by viewer]
Stages
[Not supported by viewer]
Permanent Tables
[Not supported by viewer]
Temporary
Tables
[Not supported by viewer]
Transient
Tables
[Not supported by viewer]
External
Tables
[Not supported by viewer]
Standard Views
[Not supported by viewer]
Secured Views
[Not supported by viewer]
Materialized Views
[Not supported by viewer]
Table Stages
[Not supported by viewer]
User Stages
[Not supported by viewer]
Named Stages
[Not supported by viewer]
Internal
[Not supported by viewer]
External
[Not supported by viewer]
Azure
[Not supported by viewer]
AWS
[Not supported by viewer]
GCP
[Not supported by viewer]
File Formats
[Not supported by viewer]
Sequences
[Not supported by viewer]
Stored Procedures
[Not supported by viewer]
UDF
[Not supported by viewer]
Streams
[Not supported by viewer]
Tasks
[Not supported by viewer]
Standard
[Not supported by viewer]
Business Critical
[Not supported by viewer]
Enterprise
[Not supported by viewer]
VPS
[Not supported by viewer]
User
[Not supported by viewer]
Role
[Not supported by viewer]
Integrations
[Not supported by viewer]
Resource Monitor
[Not supported by viewer]
MsPortalFx.base.images-4 public:true sdk: MsPortalFx.Base.Images.Polychromatic.Table() category: General image/svg+xml MsPortalFx.base.images-4