Working with SAS Viya and Databricks
VYDB : VYDBV1
Working with SAS Viya and Databricks introduces how SAS Viya can interact with Databricks to support analytics in modern data environments. You’ll learn how SAS efficiently accesses and processes data stored in Databricks, enabling you to analyze and prepare large datasets while minimizing data movement.
The course then explores how core SAS capabilities—such as DATA step processing, advanced analytics, and decisioning—can be applied alongside Databricks platforms. From foundational concepts to practical applications, you will gain the skills needed to build efficient, scalable analytics workflows that combine the strengths of SAS Viya and Databricks.
The course then explores how core SAS capabilities—such as DATA step processing, advanced analytics, and decisioning—can be applied alongside Databricks platforms. From foundational concepts to practical applications, you will gain the skills needed to build efficient, scalable analytics workflows that combine the strengths of SAS Viya and Databricks.
Learn How To
- Describe the core concepts of Databricks and navigate its user interface.
- Access and explore data directly within Databricks.
- Connect SAS Viya to Databricks and retrieve required connection information.
- Read and process Databricks data efficiently from SAS.
- Minimize data movement by leveraging in-place data processing strategies.
- Run SAS DATA step code directly in Databricks environments.
- Apply SAS analytics on data stored in Databricks.
- Publish and run SAS models in Databricks using SAS code and SAS Model Manager.
- Publish and execute SAS decisions using SAS Intelligent Decisioning
- Score Databricks data outside of SAS Viya
- Understand how the SAS Embedded Process enables advanced integration with Databricks
Who Should Attend
This course is designed for data engineers, analytics engineers, and SAS practitioners who want to integrate SAS Viya with Databricks to build efficient, scalable analytics workflows on modern data platforms.
Prerequisites
Before attending this course, students should be familiar with:
In addition, students are expected to have completed the course Understanding SAS® In-Database Technologies on the SAS® Viya® Platform.
- Data access and management concepts.
- Relational databases.
- SAS Viya fundamentals.
- Base SAS coding techniques.
In addition, students are expected to have completed the course Understanding SAS® In-Database Technologies on the SAS® Viya® Platform.
SAS Products Covered
SAS Viya
Course Outline
Working with Databricks
- A Quick Tour of Databricks.
- Unlocking Databricks with SAS Viya.
- Explore Databricks User Interface.
- Read Data with Databricks.
- Gather Required Connection Information.
- Access Databricks.
- Process Databricks Data from SAS.
- Connect to Databricks.
- Run SAS DATA Steps in Databricks.
- Publish and Run SAS Models in Databricks using SAS Code.
- Publish SAS Models in Databricks using SAS Model Manager.
- Publish SAS Decisions in Databricks using SAS Intelligent Decisioning.
- Score Databricks Data outside of SAS Viya.
- Appendix - Deploy the SAS Embedded Process in Databricks - Documentation Only.
The hands-on lab is preconfigured to support this course and will not support hands-on practice for all your enrolled courses.
Hands-On Lab Reservation System
Start the course to access the hands-on lab.
Resources
