In this article, we’ll cover how a user continued their analytics in SSAS after transferring terabytes of data into a Snowflake data warehouse.
Join the DZone community and get the full member experience. SQL Server Analysis Services (SSAS) is used to create high-level aggregated views of data, allowing users to quickly create dynamic reports and dashboards to centralize business measurable values like Key Performance Indicators (KPIs). In this article, we’ll cover how a user continued their analytics in SSAS after transferring terabytes of data into a Snowflake data warehouse. After migrating 150 TB of business data to Snowflake, a major global retailer wanted to keep using SSAS for analytical processing and data mining. Based on their old data model, their business teams created a set of OLAP cubes (see below) in SSAS. When their teams tried to make the identical cubes with Snowflake, they discovered that the native connectivity and open-source connectivity options were not able to work with SQL Server.
