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
- 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 Native Format.
- Accessing Open and Common File Formats.
- Going Further with SQL Pass-Through.
- Extending DuckDB.
Live Class Schedule
Duration: 7 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
SOLD SEPARATELY
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Coaching Services
Take your training to the next level with personalized coaching. While private training offers structured coursework, coaching provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.