Jorg Klein • 12/19/2017

Multi-Source partitioned Azure Analysis Services tables – cold data from Azure Data Lake Store, hot data from Azure SQL Database

Read Original

This article details a method for building partitioned tables in Azure Analysis Services that source data from multiple locations. It explains how to integrate cold, historical data stored as CSV files in Azure Data Lake Store with hot, current data from an Azure SQL Database, leveraging Power Query for transformations without an intermediate ETL layer or structured SQL store.

0 comments
#Azure SQL Database #Data Partitioning #Azure Analysis Services
Multi-Source partitioned Azure Analysis Services tables – cold data from Azure Data Lake Store, hot data from Azure SQL Database

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
React, useEffect, and Stale Closures: How to Avoid Them with Dependencies and useRef
Jivbcoop • 4 votes
2
Better react-hook-form Smart Form Components
Maarten Hus • 2 votes
3
AGI, ASI, A*I – Do we have all we need to get there?
John D. Cook • 1 votes
4
Quoting Thariq Shihipar
Simon Willison • 1 votes
5
Dew Drop – January 15, 2026 (#4583)
Alvin Ashcraft • 1 votes
6
Using Browser Apis In React Practical Guide
Jivbcoop • 1 votes