Snowflake Concepts & Fundamentals with Full Mock test[2020]

Snowflake's storage layer stores data independently from compute with unlimited capacity. It uses physical micro-partitions, a logical table view, triple replication, immutable files, and updates rewrite partition files.

The compute layer, the bathhouse, enables data access from storage via scalable virtual warehouses, supporting separate workloads, on-demand resizing, and auto suspend for credit-based pricing.

See how the service layer acts as the brain of snowflake, handling authentication, security, and metadata. It caches results and tracks partition mappings to enable efficient, consistent querying.

Snowflake operates as a cloud-based service using cloud storage and compute layers, with a central service layer managing security and scaling from a pool of instances, hence not on premises.

Sign up for snowflake by selecting enterprise edition, choosing a cloud provider and Mumbai region, and activating via email to access the snowflake console.

Explore the snowflake console, create a new warehouse with a unique name, select a size, and configure scaling and suspend policies to optimize idle costs.

Create and explore databases and schemas in Snowflake, including a sample shared database, view tables and data via worksheets, and learn how storage decouples from compute with warehouses and caching.

Explore how Snowflake uses a staging area to load data, including default internal stages like user and table stages, and named stages (external and internal) created by users or Snowflake.

Explains how to load data into snowflake using bulk loading with the copy command and a provisioned warehouse, and continuous loading with snow pipe that runs without user-provisioned compute.

Learn bulk data loading in Snowflake using external stages and a CSV file format to load data into a table, then preview the results.

Learn how Snowflake loads data from internal and external stages, creates and validates stages from a bucket, loads into tables, and handles duplicates and verification steps.

Access data without loading into Snowflake via external tables and stages, define column types, preview data, and note copy limitations while preparing for Knobi transformations.

Learn how Snowpipe enables continuous data loading from an S3 bucket into Snowflake by configuring a pipe and S3 event notifications to trigger copy as new files arrive.

Learn how to set up Snowpipe for continuous data loading in Snowflake by configuring a stage, using the copy command, and wiring AWS S3 events to automatically ingest files.

Learn how Snowflake clustering improves query performance by reorganizing data into optimized clusters, reducing partition scans. Understand retention and credit implications of automatic versus manual clustering.

Learn how Snowflake stores data with micro partitions and partitions, and how warehouse size and caching affect query performance by running and profiling sample queries in a lab.

Explore how to create and populate a table, compare large vs small data loads, and optimize performance by clustering in Snowflake, including multi-attribute clustering on date and store.

Discover zero-copy cloning in Snowflake, where clones share metadata without physical data copies. Updates write files only for changed records, enabling fast cloning of databases, tables, or schemas via metadata.

Snowflake time travel lets you query data as of a precise timestamp. Include minutes and seconds to see past states without compute overhead.

Enable data recovery with Snowflake fail-safe, which allows seven-day recovery beyond time travel retention for disaster scenarios, reducing backups while incurring separate storage costs.

In this lab, learn how Snowflake time travel lets you revert to earlier data states using timestamps, history views, and undo to recover accidentally modified data.

Discover how to create zero data clones of tables, schemas, and databases in Snowflake, using metadata-only cloning to keep clones independent from the source.

Learn how to use Snowflake clone with time travel to capture a table state before a statement, then retrieve and clone data for verification.

Explore data share in Snowflake, enabling read-only data sharing to internal or external consumers, with provider and consumer roles, and how shares, reader accounts, and databases enable controlled access.

Learn to create and share data in Snowflake by acting as an account admin, configuring a provider share, selecting databases and tables, validating accounts, and viewing default inbound shares.

This lab demonstrates how to create a data share in snowflake, provision a reader account, and grant access to a shared database for a consumer, including login flow and troubleshooting.

Explore how to monitor Snowflake resource usage and billing through the account admin dashboard, review usage by date, warehouses, storage, credits, and auditing, and set monitors and alerts.