Create and run a Python worksheet with Snowpark to query Snowflake data, filter information_schema.packages by language, and preview results for exam preparation.

Learn how to use SnowSight to create databases, schemas, and tables from files, configure data types and headers, and monitor queries through history and grouped queries.

Create normal, materialized, and secure views in Snowflake using create or replace view, materialized view, and secure commands, then verify with show views and sample selects.

Demonstrates building an access control framework in Snowflake by creating users and roles, granting privileges on databases, schemas, and tables, and establishing a role hierarchy.

Demonstrates granting ownership of a schema to a role and using information schema to inspect database metadata and objects.

Load json semi-structured data into a Snowflake table by creating a json file format and stage, then query nested fields with bracket or dot notation and insert using parse_json.

Explore how directory stores file-level metadata and file URLs in a Snowflake stage, enabled at create or alter, with manual refresh for internal stages and automatic refresh for external stages.

Explore permanent, transient, and temporary tables and their default creation syntax in Snowflake, and learn to view definitions, insert data, copy into, and load data for exam prep.

Learn how to clone tables in Snowflake and keep clones independent from the original. Then use time travel to restore deleted data with clone tables.

Learn how to use Snowflake data exchange to share data with internal and external partners, publish listings, manage access, and control direct shares or readers accounts.