Snowflake learning path: everything to study, topic by topic

Cloud services, query processing, and database storage layers; separation of compute and storage; metadata management

Warehouse sizes, auto-suspend, auto-resume, multi-cluster warehouses, scaling policies, and credit consumption

Databases, schemas, tables, views, sequences, object hierarchy, INFORMATION_SCHEMA, and SHOW commands

Permanent, transient, temporary, and external tables; table-level properties and storage implications

QUALIFY, FLATTEN, LATERAL, PIVOT/UNPIVOT, SAMPLE, MATCH_RECOGNIZE, and result_scan()

VARIANT, OBJECT, ARRAY data types; dot notation, bracket notation, PARSE_JSON, STRIP_NULL_VALUE, type casting

SQL UDFs, JavaScript UDFs, Python UDFs, UDTFs, secure UDFs, and external functions

Transaction management, AUTOCOMMIT, BEGIN/COMMIT/ROLLBACK, scoped transactions, and isolation levels

Snowpark for Python, Java, and Scala; DataFrame API, UDFs in Snowpark, stored procedures in Python, lazy evaluation and pushdown optimization

VARIANT optimization strategies, schema-on-read patterns at scale, nested data flattening performance, JSON/Parquet hybrid approaches, and search optimization on VARIANT

Internal stages, external stages (S3, Azure, GCS), named file formats, stage operations (PUT/GET/LIST/REMOVE)

COPY INTO table/stage, column mapping, transformations, ON_ERROR options, VALIDATION_MODE, PATTERN, FORCE

Snowpipe auto-ingest, REST API, pipe management, Snowpipe Streaming, serverless compute for loading

External tables, data lake integration, partitioned external tables, materialized views over external tables, Apache Iceberg support

Apache Iceberg integration in Snowflake, external tables via Iceberg, catalog integration, time travel on Iceberg, and schema evolution

Kafka connector for Snowflake, S3/Azure Blob/GCS integration patterns, external functions, API integration, and event-driven architectures with Snowflake

Time travel queries with AT/BEFORE, UNDROP, retention periods, storage implications, and table-level configuration

Fail-safe period, data recovery process, storage costs, relationship between time travel and fail-safe

CREATE ... CLONE, zero-copy behavior, cloning scope (database, schema, table), metadata-only operation, storage implications on modification

Data sharing with shares, reader accounts, listings, Snowflake Marketplace, secure views for sharing

Database replication, replication groups, failover groups, cross-region and cross-cloud replication, RPO/RTO considerations

Snowflake Clean Rooms for privacy-preserving analytics, approved templates, overlap analysis, differential privacy, and cross-company collaboration

Snowflake Marketplace data sharing economy, listings, data products, monetization strategies, shared databases, and provider/consumer model

Snowflake failover and failback, database replication, cross-region DR strategies, account replication, RTO/RPO planning, and business continuity architecture

Micro-partition structure, natural clustering, clustering keys, reclustering, clustering depth, and partition pruning

Result cache, metadata cache, local disk cache (SSD), query profile analysis, and query acceleration service

Materialized view creation, automatic maintenance, query rewrite, limitations, and cost implications

Credit monitoring, resource monitors, warehouse scheduling, storage optimization, query cost attribution, and Snowflake budgets

Declarative data pipelines with Dynamic Tables, target lag, refresh scheduling, incremental processing, and DAG dependencies

Optimizing Snowflake performance: clustering keys, search optimization service, query profiling, and warehouse sizing

Managing and optimizing Snowflake costs: credit consumption analysis, warehouse auto-suspension, resource monitors, and storage optimization

Advanced credit usage analysis, warehouse sizing methodologies, auto-suspend strategies, resource monitors, query cost attribution, and FinOps practices for Snowflake

Query profiling deep-dive, warehouse queuing analysis, spilling to local/remote storage, partition pruning analysis, and query acceleration service

Role hierarchy, system-defined roles (ACCOUNTADMIN, SYSADMIN, SECURITYADMIN), custom roles, privilege grants, and DAC vs RBAC

Network policies, private connectivity (AWS PrivateLink, Azure Private Link), encryption at rest and in transit, key management, and tri-secret secure

Column-level security, dynamic data masking, row access policies, object tagging, data classification, and Snowflake Horizon

Change data capture with streams, task scheduling, task trees, serverless tasks, and stream types (standard, append-only, insert-only)

Implementing Snowflake Secure Data Sharing and publishing on the Snowflake Marketplace for data monetization

Building data pipelines and ML models in Snowflake using Snowpark for Python, Snowflake ML, and Streamlit

Implementing Snowflake security: RBAC, dynamic data masking, row access policies, object tagging, and governance

Object tagging strategies, data classification automation, access history auditing, data lineage tracking, Snowflake Horizon catalog, and compliance frameworks

Snowflake Cortex ML functions, LLM integration, vector search, document AI, sentiment analysis, text summarization, and AI-powered analytics

Building Snowflake Native Apps, application packages, versioning, Marketplace publishing, app security model, and consumer experience

Snowflake CLI (snow), Git integration, schema change management, Terraform Snowflake provider, Schemachange, and deployment automation

Account-level isolation patterns, organization-level features, reader accounts, data clean rooms advanced, cross-account governance, and multi-tenant security models