Join us for a FREE hands-on Meetup webinar on Deep Dive into Autoscaling in Apache Flink | Friday, March 28th, 2025 · 5:00 PM IST/ 07:30 AM EDT Join us for a FREE hands-on Meetup webinar on Deep Dive into Autoscaling in Apache Flink | Friday, March 28th, 2025 · 5:00 PM IST/ 07:30 AM EDT
Search
Close this search box.
Search
Close this search box.

Snowflake Data Engineer

Unlocking Business Insights: Mastering Data Analysis, Reporting, and Optimization with Snowflake AI Data Cloud

Duration

3 Days (8 hours per day)

Level

Intermediate to Advanced Level

Design and Tailor this course

Official Course

Edit Content

This three-day role-specific course covers key concepts, features, considerations, and Snowflake-recommended best practices through the lens of the data engineering workflow. It is intended for participants who will be accessing, developing, and querying datasets for analytic tasks and building data pipelines in Snowflake. This course consists of core data engineering concepts delivered through lectures, demos, labs, and discussions.

ACQUIRED SKILLS:

  • Describe the data engineering workflow and how the Snowflake AI Data Cloud features support the various components of the workflow.
  • Access Snowflake through the Snowsight UI and by using application methods.
  • Load and unload data sets.
  • Configure Snowflake features to cover a range of data ingestion and processing latencies.
  • Develop applications for Snowflake, including comprehensive ANSI standard SQL support.
  • Employ performance and cost optimization techniques.
  • Use Snowflake’s capabilities to work eectively with structured, semi-structured, and unstructured data in Snowflake.
  • Tune queries and improve performance using advanced techniques such as data clustering and materialized views.
  • Employ Snowflake SQL extensibility features such as user-defined functions and stored procedures.
Edit Content
  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators
  • Data Application Developers
Edit Content
  • Authentication Methods
  • Drivers, Clients, and Connectors Overview
  • Snowflake Connector for Python
  • SnowSQL
  • Role-based Access Control (RBAC) Overview
  • Introduction to Data Governance
  • Semi-structured Data
  • Query Semi-structured Data
  • Query Tags
  • Data Lake
  • Apache Iceberg Tables
  • External Tables
  • Document AI
  • Cortex LLM Functions Overview
  • Cortex LLM Functions Specialized Functions
  • Cortex LLM Functions Complete
  • Cost Monitoring
  • Bulk vs. Continuous Data Loading Approaches
  • Snowpipe
  • Snowpipe Streaming
  • Snowflake Connector for Kafka
  • Snowflake Connector for Kafka With Snowpipe Streaming
  • Snowflake Data Loading Best Practices
  • Loading Semi-structured Data
  • Schema Detection
  • Working With Unstructured Data
  • Creating and Managing Streams
  • Streams on Views
  • Creating and Managing Tasks
  • Using Streams and Tasks Together
  • Dynamic Tables
  • Extensibility Overview
  • Snowflake Scripting
  • UDFs and UDTFs
  • Extend Snowflake With Java and Python
  • External Functions
  • External Network Access
  • Introduction to Snowpark
  • Transformations With Unstructured Data
  • Natural Clustering
  • Explicit Clustering
  • Automatic Clustering Service
  • Search Optimization Service Introduction
  • SQL Performance Tips
  • Performance Bottleneck Scenarios
  • Materialized Views
  • Unloading Semi-structured Data
  • Data Sharing
  • Secure Views
  • Observability on Snowflake
  • Outbound Notifications
  • Snowflake Alerts
  • Data Metric Functions
  • System DMF
  • Custom DMF
  • Observability Within Snowsight
  • Cost Controls
  • Resource Monitors
  • Working With JupyterLabs
Edit Content
  • A background in data engineering is required.
  • Completion of “Snowflake Foundations” one-day course or equivalent Snowflake knowledge.

Connect

we'd love to have your feedback on your experience so far