Objects Flashcards
What does the term ‘objects’ encompass in Snowflake?
Databases, tables, views, warehouses, and schemas
The term objects includes both familiar constructs and additional elements unique to Snowflake.
What is the meaning of ‘schema’ in Snowflake?
Roughly analogous to a database in traditional RDBMS
In Snowflake, a schema does not represent the structure of a single table.
What is the highest level in the Snowflake object hierarchy?
Organization
The organization is the root node in the Snowflake object hierarchy.
What are the components within an organization in Snowflake?
Accounts, users, roles
Accounts are provisioned within the organization, and roles are crucial for access control.
What is the role of ‘warehouses’ in Snowflake?
Top-level compute object
Warehouses are used for processing queries and data operations.
What is the role of ‘databases’ in Snowflake?
Top-level data object
Databases contain tables, views, and other related objects.
What is a ‘stage’ in Snowflake?
A staging area on some cloud storage location
Stages are used for data loading and unloading.
What must a table’s fully qualified name include in Snowflake?
Database name and schema name
The format is database.schema.table.
True or False: In Snowflake, every user has an associated role when signing in.
True
Role-based access control is a fundamental aspect of Snowflake.
What additional objects does Snowflake include beyond tables and views?
File format objects, stages, stored procedures, UDFs
These objects enhance the functionality and data management capabilities of Snowflake.
