SnowPro® Core Certification COF-C03 Masterclass Unofficial

Sign up for snowflake free trial on AWS in US West, select business critical, activate, and receive 30 days of trial plus $400 credit.

Explore the Snow Site UI through a comprehensive walkthrough, highlighting home, universal search, quick actions, projects, worksheets, notebooks, dashboards, and data tools, with guidance for exam topics.

Write Snowflake SQL in a worksheet to create a database, schema, and table, insert data, and note that not null is enforced while primary keys are not.

Navigate the new Snowflake UI update, moving from the old worksheet to the SQL file workspace, with worksheets, database options, and role and compute warehouse controls centralized.

Learn how to create and configure a Snowflake warehouse, including size, multi-cluster auto scale, query acceleration, auto resume and suspend, and standard versus snowpark optimized options.

Explore scaling out with multiple clusters in a single warehouse and auto scale. Compare scale up and scale down, and examine standard versus economy policies, including how clusters start.

Explore Snowflake data types and table types, from permanent, transient, and temporary tables to cloning, time travel, and failsafe, within the securable object hierarchy of organization, accounts, and schemas.

Learn to create permanent, transient, and temporary tables, clone between them, and manage data retention, time travel, show tables, and comments in this demo.

Discover how time travel retention lets you view data at a timestamp or before a query across databases, schemas, and tables, with failsafe recovery after retention ends.

Demonstrate time travel in Snowflake by querying past states with before and timestamp, cloning past data, and adjusting account retention settings for tables, schemas, and databases.

Explore how to transform data in Snowflake using simple functions like concat and trim left. Use like and ilike, and last query id for prior queries.

Explore insert overwrite in this demo, showing how the command truncates existing data and inserts new rows, versus standard insert into that preserves prior records.

Explore how Snowflake billing works across compute, storage, and data transfer, including user-managed and serverless warehouses, cloud services, and pricing by edition, region, and cloud provider.

Discover snowflake views, including non-materialized, materialized, and secure views. Learn when materialized views speed up repeated queries and how security wrappers add access control.

Create and manage standard views, materialized views, and secure views in Snowflake, granting usage on database, schema, and warehouse, and select on views while protecting view definitions.

Learn the Snowflake data loading concept, including why loads are needed, types, and how internal and external stages—table, user, and name stages—move data from cloud or on-prem to Snowflake tables.

Load data into Snowflake from a desktop file using stage and non-stage methods, configure stages, handle CSV formatting, and troubleshoot with query history.

Learn how to use Snow SQL to load data into Snowflake tables via the user stage, using put file and copy into, handling CSV files, purge and overwrite options.

Explore table stage and user stage in Snow SQL, load CSV files using copy commands, and purge data after loading. Discover practical steps for staging data and managing file lifecycle.

Create and manage a named stage in Snow, compare it with user and table stages, attach file formats, and load data using Snow SQL commands.

Unload data from Snowflake by copying a table to an internal stage, then download with the get command, with optional partition by and external-stage or cloud exports.

Explore bulk loading with copy into and continuous loading with snowpipe, with serverless vs user-managed warehouses and 64 vs 14 days metadata; supports CSV, JSON, Parquet, Avro, XML.

Explore bulk data transformation techniques during loading, including selecting columns, concatenating values, casting types, reordering fields, and using copy into with force and truncate options.

Learn to create, alter, describe, and use file formats in Snowflake, including csv, json, and parquet, and understand precedence for copy into, stage, and table operations.

Explore snowpipe for continuous loading in Snowflake, moving data from staging to tables via serverless compute. Learn how streams, tasks, and Kafka connectors enable end-to-end flow and key exam considerations.

Learn how Snowpipe loads data from a stage into a table using a pipe, with show, describe, and refresh commands, and automate via a scheduled task.

Explore how streams in snowflake enable change data capture to track deltas between source and target tables, including inserts, updates, and deletes, via hidden metadata columns.

Learn how to create streams on a source table, enable change tracking, and merge changes into a target table using insert, merge, and append-only options.

Explore task concept in Snowflake, covering execution of statements, stored procedures, and Snowflake scripting, plus user-managed and serverless tasks, scheduling with cron, and DAG dependencies.

Learn to create and manage Snowflake tasks, schedule and resume them, and run one-off jobs, including serverless and user-managed warehouses, with stream integration.

Explore the data database and schema to view and manage tasks and dependencies. Learn to run, edit, and schedule tasks in the SnowSite UI with options like warehouse or serverless.

Explore copy into table options in Snowflake, focusing on on error handling with abort, continue, skip file, return failed only, and thresholds and percentage limits for load errors.

Explore copy into options: size limit, on error continue, written field only, match by column name case sensitivity, and enforce length with pass header and skip header handling.

Learn how validation mode and validate support error handling by simulating copy commands, returning errors from previous loads, and performing basic sanity checks with row limits.

Master user defined functions and stored procedures in Snowflake, including scalar and table UDFs, with create or replace and language options; understand calls, overloading, and differences with stored procedures.

Explore how to create and call user-defined functions and table-returning udtfs in snowflake, including function overloading, JavaScript and SQL language, and secure versus non-secure stored procedures.

Clone databases, schemas, or tables in Snowflake to create exact copies for testing and development without extra storage costs. Understand how time travel, data retention, and privileges affect clones.

Learn to clone tables and data, including cloning a clone, performing time travel with timestamp or offset, and restoring data from a prior state without affecting the original.

Clone a schema to copy tables, views, and streams, then verify how unconsumed records are affected when cloning a full schema versus individual objects.

Explore semi-structured data in Snowflake, using array, object, and variant types to read and query data from JSON, Avro, Parquet, and XML formats, with practicals.

Explore semi-structured data with json in Snowflake, loading a json file into a stage, querying into a raw source table, and using bracket and dot notation to access fields.

Demonstrates transforming semi-structured json data into a readable table by flattening arrays for zones, divisions, and orders, using dot notation and Snowflake functions.

Learn how to convert table data into unstructured formats like json and parquet by creating json and parquet file formats and stages, copying data, and unloading for cross-system data sharing.

Explore how Snowflake processes unstructured data such as PDFs, images, and videos alongside structured data. Learn to access cloud data with scoped, file, and pre-signed URLs and their functions.

consume unstructured data by creating internal stage in Snowflake, uploading an image, and generating scoped, pre-signed URLs to access files securely.

Understand how directory adds a metadata layer to a stage, storing file details and the build stage file url; enable on internal or external stages with manual or automatic refresh.

Explore predicates in Snowflake by using a variant column to identify data types with is null, is decimal, and array checks. Show how variant data holds json and nested objects.

Connect snowflake to cloud services such as Azure or gcp. Create s3 bucket, policy, and role, configure storage integration and stage, then use copy into to load data.

Create an AWS account by verifying email and phone, entering address details, and confirming a small card charge, then choose the $0 plan.

Connect Snowflake to AWS S3 by creating a bucket, IAM policy and role, configuring storage integration, creating a stage and file format, then copy into a table.

Learn to unload data to the cloud in Snowflake by configuring storage integration, creating stages, and unloading to S3 with private data considerations and stage and direct bucket options.

Learn how sequences work in Snowflake, create and name sequences, set start values and increments (including negative), retrieve next values, and insert into tables while noting gaps may occur.

Explore sampling from large databases to speed up testing and development, using fixed-size or fraction-based methods like Bernoulli (row-based) and system or block sampling, with seed handling and join sampling.

Explore sampling methods in Snowflake: block, Bernoulli, and fixed-size sampling, including seed control to reproduce results and applying sample data to a table or view for analysis.

Explore Snowflake estimation functions to approximate distinct counts, similarity, frequency, and percentiles using hyperloglog, minhash, space-saving, and t-digest algorithms, saving compute and time.

Explore Snowflake supported function types, including scalar, aggregate, window, system, and table functions, plus user defined and external functions.

Explore Snowflake's micro partition concept, where the system automatically divides tables into immutable, columnar micro partitions of 50-500 MB, enabling time travel, cloning, and optimized queries via partition metadata ranges.

Discover how query pruning in Snowflake automatically eliminates unnecessary micro partition scans, using where clause predicates to prune partitions and boost query performance.

Learn how Snowflake data clustering automatically co-locates same value data in micro partitions to boost performance while balancing storage and compute costs, and how to determine when to cluster.

Choose clustering keys by selecting columns used in where clauses or join predicates and balance cardinality to improve partition pruning in Snowflake tables and materialized views.

Demonstrate clustering by copying a 2 million record table from the Snowflake sample database into a cluster and disabling cache results, then evaluate clustering keys with the information schema.

Explore Snowflake caching concepts across query result, metadata, and warehouse caches at the cloud service and processing layers, including expiry rules, exceptions, and auto suspend trade-offs.

Explore Snowflake caching in a hands-on demo, covering query result, metadata, and warehouse caches. Enable the query result cache with alter session and observe cache effects in the query profile.

Explore the query profile to visualize data flow from tables through joins and filters, identify bottlenecks like table scans, and learn how warehouse size and spilling affect performance.

Learn how to use query profiling and query history in Snowflake, examine the explain plan, assess expensive nodes and spilling, and understand information schema and account usage views.

Learn to monitor credit usage for user-managed warehouses and cloud services (not serverless), set quotas and reset frequencies, define threshold actions, and configure monitors via SnowSite UI or code.

Learn to configure a resource monitor to track quotas, choose account or warehouse scope, set dates and frequency, and automate suspend or notify actions at thresholds.

Explore the search optimization service that boosts lookup and analytical query performance by maintaining a persistent search access path for selective column filters, such as variant object and array columns.

Explore how the search optimization service boosts query performance on a large customer table, comparing table scans with partition-based access, and outlining related storage and compute costs.

Apply the query acceleration service to speed up heavy or outlier queries in the warehouse, especially during unpredictable data volumes.

Monitor warehouse usage and query performance, tracking provisioning, queues, and history across hours to weeks. Optimize by resizing, adding clusters, or moving queries to balance load, storage, and credits.

Master storage, warehouse, and query optimization in Snowflake with clustering, search optimization services, materialized views, purge stage data, temporary tables, and memory monitoring to boost performance and cut costs.

Learn how Snowflake uses discretionary and role-based access control to grant privileges on securable objects through roles assigned to users, with ownership, role hierarchies, and default denial.

Explore system defined roles in snowflake, including org admin, account admin, security admin, sysadmin, and user admin. Understand privilege inheritance, public role, and how to design custom roles.

Master role hierarchy and privilege inheritance in SnowPro core certification, showing how dummy roles grant usage on schemas and select access to tables, and how role-to-role inheritance propagates privileges.

Master the access control framework by creating users and roles, assigning privileges, and using grant, revoke, and future grants to manage databases, schemas, and warehouses.

Learn how database roles bound to specific databases control access by assigning database roles to account roles, granting privileges within each database, and enabling isolated or multi-database access.

Learn to create and assign per-database roles in Snowflake, grant access at database and schema levels, and verify roles with show database roles.

Explore column level security in snowflake with dynamic data masking. Define masking policies to restrict sensitive data like email and credit card numbers to authorized users, including external tokenization options.

Demonstrates creating and applying a data masking policy to a credit card column, showing actual values for account admin and masked values for other roles, including policy alteration and unsetting.

Explore row-level security and masking concepts to isolate data by department, enforcing policies so sales, marketing, and IT users see only their respective records, with row-level before column-level checks.

Explore row level access policy with a department-based approach, mapping roles to data, granting usage and select on a table, and testing with dummy sales, marketing, and IT roles.