Snowflake - Objects

Snowflake logically organizes data in three stages − Account, Database and Schema.

Database and Schemas organize data logically within a Snowflake Account. An Account can have multiple databases and schemas, but a database must be tied up with only one schema and vice versa.

Snowflake Objects

Here is the pst of Snowflake objects −

Account

User

Role

Virtual Warehouse

Resource Monitor

Integration

Database

Schema

Table

View

Stored Procedure

User Defined Functions (UDF)

Stage

File Format

Pipe

Sequence

Objects after Schema are tied up with Schema and Schema is tied up with Database. Other entities pke User and Role are used for authentication and access management.

Important Points Related to Snowflake Objects

Here is a set of important points regarding Snowflake objects that you should be aware of −

All snowflake objects fall under logical containers where the top level container is Account, i.e., everything is under Snowflake s Account.

Snowflake secures all the objects inspanidually.

Users can perform operations and tasks on objects based on the privileges granted to roles.

Privileges Example −

Create a virtual warehouse

List Tables in a schema

Insert data into a table

Select data from a table

Not delete/truncate a table