Hoppa till huvudinnehåll
HemSnowflake

course

Data Pipeline Automation in Snowflake

GrundläggandeFärdighetsnivå
Uppdaterad 2026-05
Load, automate, and optimize data pipelines in Snowflake using COPY INTO, Snowpipe, streams, tasks, dynamic tables, and query performance tools.
Börja Kursen Gratis
SnowflakeData Engineering
3 timmar
15 videos
48 exercises
3,350 XP
Uttalande om prestation

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Älskad av elever på tusentals företag

Group

Training a Team?

Try for Business

Kursbeskrivning

Master the tools and techniques for building reliable, automated data pipelines in Snowflake. You'll start by learning how to ingest data at scale — configuring stages and file formats, loading data with COPY INTO, and choosing between batch loading, Snowpipe, and Snowpipe Streaming for different latency and volume requirements. From there, you'll build end-to-end pipeline orchestration skills: capturing row-level changes with streams, chaining multi-step workflows with task DAGs, and creating declarative, auto-refreshed pipelines with dynamic tables. You'll also learn when to reach for external and Iceberg tables for multi-engine and cloud-native scenarios. The second half of the course sharpens your querying and transformation skills — extracting and unnesting semi-structured JSON from VARIANT columns, applying grouping extensions and window functions for advanced analytics, and encapsulating reusable logic in UDFs and stored procedures. Finally, you'll tackle query performance: reading Snowflake's Query Profile to pinpoint bottlenecks, selecting the right optimization tool — Search Optimization, Query Acceleration Service, clustering keys, or materialized views — and writing cache-friendly SQL that avoids the common anti-patterns that silently degrade performance.

Förkunskapskrav

Det finns inga förkunskapskrav för den här kursen
1

Data Loading, Ingestion, and Connectivity

Master Snowflake's data ingestion pipeline — from staging files through COPY INTO, Snowpipe, and Snowpipe Streaming — and connect Snowflake to the broader data ecosystem through connectors, drivers, and export tools.
Starta Kapitel
2

Pipeline Orchestration and Data Objects

Build robust data pipelines using Snowflake-native orchestration — streams for change capture, tasks for scheduling, dynamic tables for declarative transformation, and external and Iceberg tables for open-format storage.
Starta Kapitel
4

Query Performance and Optimization

Profile queries in Snowsight, identify bottlenecks with QUERY_HISTORY, apply Search Optimization, Query Acceleration Service, Automatic Clustering, and Materialized Views, and write SQL that benefits from Snowflake's three caching layers.
Starta Kapitel
Data Pipeline Automation in Snowflake
Kursen
är

Få ett prestationsutlåtande

Lägg till denna inloggningsuppgifter i din LinkedIn-profil, ditt CV eller ditt CV
Dela det på sociala medier och i ditt prestationssamtalRegistrera Dig Nu

Gå med över 19 miljoner elever och börja Data Pipeline Automation in Snowflake idag!

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Utveckla dina datakunskaper med DataCamp för mobilen

Gör framsteg när du är på språng med våra mobila kurser och dagliga 5-minuters kodningsutmaningar.