You are viewing as a ‘Guest’. Your progress will not be recorded.
Working with DuckDB in SAS Viya®
1h 16m + Hands-On Practice
START FREE TRIAL
Available in:
A person using a tablet to complete a video based eLearning course and hands-on lab.


  
Working with DuckDB in SAS Viya®
DOFF : DOFFV1
Working with DuckDB in SAS Viya(R) introduces how DuckDB is integrated into SAS Viya to enable efficient analytics on modern data platforms. You’ll learn how DuckDB complements SAS capabilities and how to work with open file formats such as Parquet, JSON, Delta Lake, and Iceberg—both locally and in the cloud. The course progresses from core concepts to more advanced techniques, giving you practical skills to design high-performance, flexible data workflows that combine the strengths of SAS Viya (R) and DuckDB.
Learn How To
  • Explain how DuckDB is integrated into SAS Viya(R) and how it complements native SAS processing.
  • Work with DuckDB using both in-memory and file-based databases.
  • Use implicit and explicit SQL pushdown to control where processing occurs (SAS vs. DuckDB.)
  • Access and process modern data formats such as Parquet, CSV, JSON, Delta Lake, and Iceberg
  • Query partitioned datasets and multiple files efficiently using globbing and Hive-style layouts
    • Work with data stored in cloud object storage (e.g., Azure ADLS) using SAS and DuckDB
    • Use advanced DuckDB capabilities including time travel, JSON processing, and spatial functions
    • Extend DuckDB with core and community extensions to support real-world use cases
    Who Should Attend
    This course is designed for data engineers, analytics engineers, and SAS practitioners who want to design performant data workflows with DuckDB and open file formats in SAS Viya (R).
    Prerequisites
    Before attending this course, students should be familiar with:
    • Data access and management concepts.
    • Relational databases.
    • SAS Viya(R) fundamentals.
    • Base SAS coding techniques.
    SAS Products Covered
    SAS Viya
    Course Outline
    Introducing DuckDB
    • DuckDB in SAS Viya: What It Is and Why It Matters
    • How DuckDB Runs Inside SAS Viya.
    • The Role of Open File Formats in Modern Platforms.
    • Supported Formats at a Glance.
    Working with DuckDB
    • Working with DuckDB Native Format.
    • Accessing Open and Common File Formats.
    • Going Further with SQL Pass-Through.
    • Extending DuckDB.