SnowPro® Core Certification COF-C03 Crash Course Unofficial

Snowflake network policies control access by IP, using CIDR-based allowed and blocked IPv4 lists with a single active policy per account or user, where blocked takes precedence.

Explore how multi-factor authentication protects Snowflake access with MFA powered by Do security service, covering enrollment, login options, and SSO integration.

Understand federated authentication and single sign-on (SSO), where identity providers manage credentials for access to service providers like Snowflake. See how Okta authenticates users and redirects them for access.

Master keeper authentication with snowflake using a 2048-bit rsa key pair by generating and storing keys with openssl, assigning public key to the user, verifying fingerprint, and configuring the client.

Explore how Snowflake's access control framework blends discretionary access control and RBAC. See how privileges granted to roles, role hierarchies, and user assignments govern access to securable objects.

Explore Snowflake roles, from account and database roles to primary and secondary roles, and understand how privileges and grants control access across organizations and objects.

Clarify the difference between access roles and functional roles, and illustrate assigning low-level privileges to roles and aggregating them to IT developer and data analyst users.

Explore how privileges are granted to roles and how those roles grant access to users, highlighting granular object privileges, role hierarchy, and grant and revoke mechanisms for privilege inheritance.

Discover how an organization links snowflake accounts to provide a bird's eye view and consolidated management, including account identifiers and viewing current organization and account names via the profile.

Explore information schema as a read-only data dictionary with views and table functions, and contrast it with account usage schema for metadata, usage, dropped objects, refresh cadence, and retention.

Explore the access history view in account usage, detailing read and write activity for compliance auditing, including direct and indirect object access, query details, and modified objects.

Learn column level security in Snowflake using dynamic data masking and external tokenization. Create and apply a CC mask policy to protect credit card data, and manage policy references.

Understand row level security in Snowflake enterprise edition, restricting data by department, and see how column level security applies first, followed by row level security, via a department policy.

Learn how Snowflake object tags attach metadata to tables, views, and columns using key-value pairs, enabling centralized or decentralized governance, compliance monitoring, data discovery, and tracking resource usage.

Master bulk loading in Snowflake using copy into, performing transformations like reordering, casting, truncating, and concatenating columns, while noting metadata retention and copy behavior.

Explore bulk loading options in the Snowflake copy command, including on error behavior (default abort, continue, skip file), match by column name, enforce length vs truncate, force, and purge.

Discover how Snowpipe enables continuous loading from multiple sources into internal stages. It moves data to staging tables and finally to the target table via streams and tasks.

Define file formats with type, delimiter, and null handling for csv, json, avro, orc, parquet, and xml. Apply these formats in copy into, create stage, and create table.

Learn how the put command loads data from the local file system to a Snowflake internal stage, with file path, internal stage, parallel options, auto compress, and overwrite controls.

Learn to handle errors with validation mode and validate by simulating data, identify issues before copy commands, and view or save errors to a table.

Unload data from Snowflake by copying into a stage or cloud, with options like partition by, single file, header, and encryption, then get data from stage.

clarifies the difference between empty strings and null values, noting that empty strings have zero length and are quoted, while null means absence of data. define the compression extension used.

Learn how insert overwrite replaces existing table data by truncating employees and inserting new results from a select. It contrasts this with insert that appends records and can duplicate data.

Explore Snowflake caching options, including query result cache, metadata cache, and warehouse cache, their operation across cloud service and query processing layers, and when to enable or suspend.

Explore the Snowflake query profile to interpret execution steps, from table scans to data processing and spilling. Use explain plans and query history in monitoring to optimize warehouse performance.

Learn to create and manage virtual warehouses in the snow site UI, selecting type and size from extra small to six x large, with auto resume, auto suspend, and multi-cluster scaling.

Understand scale out and scale up concepts in Snowflake, including multi-cluster warehouses, minimum 1 to maximum 10 clusters, standard or economy policies, and scale between warehouses with query migration considerations.

Define a resource monitor in Snowflake, set a credit quota and monitor type (warehouse or account), schedule resets, and specify threshold actions like suspend or notify with email alerts.

Learn to monitor Snowflake warehouses, interpret run, provisioning, and queued load states, monitor query history, and optimize costs with detailed usage and cost insights.

Explore how the query acceleration service in Snowflake reduces outlier query impact. See how adjustable scale factors and QoS enable faster execution for ad hoc analytics.

Snowflake's search optimization service speeds selective lookups and analytical queries by creating a persistent search access path. Requires enterprise edition or higher; activate with alter table to add search optimization.

Master efficient Snowflake queries by selecting only needed columns, applying filters, using window functions and common table expressions, and leveraging materialized views, joins wisely, and clustering for performance.

Explore snowflake estimation functions, including distinct count similarity estimation, frequency estimation, and percentile estimation, using hyperloglog and mean hash to balance accuracy with compute efficiency.

Explore sampling methods to test large datasets efficiently. Learn fixed size, fraction-based (Bernoulli or rho), system or block sampling, and sampling on join, with seed options for repeatability.

Snowflake supports scalar, window, aggregate, table, and system functions, plus user-defined and external functions, with examples like ceiling, floor, sum, and avg.

Learn how snowflake table functions return a set of rows per input, with one-to-n and m2n outputs, used in from clauses, plus built-in and user defined options.

External function uses a udf to call remote service outside Snowflake. It uses api, sends json via http post with authentication, and may incur warehouse usage and third party charges.

Explore how Snowflake streams capture delta changes via change data capture, tracking inserts, updates, and deletes from source to target. Understand the hidden columns and metadata that surface these changes.

Explore how to create and manage tasks in Snowflake, including single SQL statements, calls to stored procedures, and Snowflake scripting, with user managed and serverless options, scheduling, and DAG-based dependencies.

Explore semi-structured data in Snowflake, using array, object, and variant types with JSON, Avro, Parquet formats; learn flatten and lateral flatten to turn nested data into queryable tables.

Learn how Snowflake processes unstructured data like pdf files, images, and videos, securely access cloud-stored files, load file metadata, and use scoped and pre-signed URLs via sql functions.

Directory stores file-level metadata for files in a stage, for internal or external stages. Enable during creation or by alter, refresh metadata manually or automatically (external only), with encryption.

Explore Snowflake's continuous data protection lifecycle with time travel and failsafe, including at or before timestamps, offsets, and query IDs, plus configurable data retention and cloning for recovery and backups.

Learn how snowflake encrypts data at rest with 256-bit encryption and in transit with tls 1.2, and manages multi level keys for tri secret secure.

Clone objects in Snowflake to create exact copies for backups, testing, or new development environments, while paying only the original storage; time travel enables cloning databases, schemas, and tables.

Explains database replication across regions and vendors, creating a primary and read-only secondary to mitigate geographic and vendor risks, including exceptions that can't be replicated.

Learn how to securely share data in Snowflake, create and manage shares, assign read-only access to databases and tables, and understand cost and constraint implications for providers and consumers.

Shows how to create a share in Snowflake and grant access to a reader's account using a secure view. Uses account admin and security admin roles to revoke access.

Explore data exchange in Snowflake, enabling broader access by sharing or publishing data with an invited group of entities, while maintaining full control to revoke or limit access.

Snowflake's data marketplace, where buyers and sellers meet to buy data, apps, and AI products with quick, native access and provider studio access.

Learn how Snowflake calculates billing across compute, storage, and data transfer, including user-managed and Snowflake-managed warehouses, and cloud services. Examine on-demand versus capacity reservations and the discounts they offer.