- Snowflake Tutorial
- Snowflake - Home
- Snowflake - Introduction
- Snowflake - Data Architecture
- Snowflake - Functional Architecture
- Snowflake - How to Access
- Snowflake - Editions
- Snowflake - Pricing Model
- Snowflake - Objects
- Snowflake - Table and View Types
- Snowflake - Login
- Snowflake - Warehouse
- Snowflake - Database
- Snowflake - Schema
- Snowflake - Table & Columns
- Snowflake - Load Data From Files
- Snowflake - Sample Useful Queries
- Snowflake - Monitor Usage and Storage
- Snowflake - Cache
- Unload Data from Snowflake to Local
- External Data Loading (from AWS S3)
- External Data Unloading (Into AWS S3)
- Snowflake Resources
- Snowflake - Quick Guide
- Snowflake - Useful Resources
- Snowflake - Discussion
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.
Here is the list of Snowflake objects −
- Virtual Warehouse
- Resource Monitor
- Stored Procedure
- User Defined Functions (UDF)
- File Format
Objects after Schema are tied up with Schema and Schema is tied up with Database. Other entities like 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 individually.
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
Kickstart Your Career
Get certified by completing the courseGet Started