Data Management on SingleStore on the SAS® Viya® Platform
Available in:
Education Category Image


  
Data Management on SingleStore on the SAS® Viya® Platform
Duration: 4 hours
DM323W : DM323W
Introducing a true database management system into Viya opens the door to several new possibilities including easily managing data change. SingleStore’s UPSERT capability quickly and easily propagates source data change to the database that CAS reads directly. In this course, we continuously ingest data files that are dropped in real-time in a cloud object storage location (ADLS), load/update a SingleStore table accordingly and see if SAS Visual Analytics can capture those updates seamlessly.
Learn How To
  • Run pipelines in SingleStore to capture table updates from newly landed data files on ADLS2 cloud object storage.
  • Use SingleStore’s upsert capability to efficiently modify SingelStore tables that CAS reads for Visual Analytics reports and analyses.
  • Demonstrate Visual Analytics’ ability to push analytic calculations/actions to Singlestore.
  • Refresh Visual Analytics’ report contents on a near real time schedule.
  • Who Should Attend
    Data Engineers responsible for supporting near real time analytics with SAS Visual Analytics on Singlestore.
    Prerequisites
  • CAS Data Management
  • ;The attendee should have a good understanding of the SAS Cloud Analytic Server, Azure ADLS2, and relational databases.
    SAS Products Covered
    SAS Viya
    Course Outline
    SingleStore Overview
  • Overview
  • CAS and SingleStore
  • CAS – SingleStore Integration.
  • CAS – SingleStore Capabilities.
  • CAS Normalization Process.
  • SAS Visual Analytics and SingleStore
  • Capturing Updates from SingleStore in SAS Visual Analytics.
  • SAS Compute Server and SingleStore
  • SAS Compute Access to SingleStore.
  • THIS COURSE IS PART OF

    SAS Data Engineering Learning Subscription



    Skip Earn this badge

    Earn this badge