Course contents

SnowPro Core COF-C03 Study GuidePart 6: Database objects and platformExam Focus: Part 6

Exam Focus: Part 6

Exam Focus · Part 6

Know where each object lives, which table type fits, and what streams, tasks, procedures and UDFs can do.

Know these cold

TopicRemember
Every database hasPUBLIC and INFORMATION_SCHEMA
Object levelsAccount: warehouses, users, roles, resource monitors, integrations. Schema: tables, stages, pipes, file formats
Info Schema vs Account UsageInfo Schema: one database, live. Account Usage: dropped objects, 365 days, lagged
Table types (Time Travel / Fail-safe)Permanent: 0–90 / 7 days. Transient: 0–1 / none. Temporary: same, session only
Dynamic tableA query plus TARGET_LAG. Snowflake refreshes it. No DML into it
Stream offsetMoves only when committed DML reads the stream, never on SELECT
TasksCreated suspended. AFTER chains them. No WAREHOUSE means serverless
Procedure vs UDFProcedure: CALL, DML, owner's rights by default. UDF: inline, no DML
Semi-structuredVARIANT, OBJECT, ARRAY. col:a.b::STRING. Arrays: LATERAL FLATTEN
Iceberg vs external tableIceberg: open format; Snowflake writes (own or REST catalog). External table: read-only

Traps

  • Myth A materialized view hides its definition.Fact Only SECURE ones do.
  • Myth A materialized view can join two tables.Fact It reads one table. Use a dynamic table for joins.
  • Myth LAST_QUERY_ID(2) is the second most recent query.Fact It's the session's second. -2 is the second most recent.
Before you turn the page
  • Sort pipe, file format, warehouse, resource monitor and integration by level.
  • Pick the table type for session scratch, rebuildable staging and source-of-truth data.
  • Write a cast path to a nested JSON field, and a LATERAL FLATTEN.