Multi-Source partitioned Azure Analysis Services tables – cold data from Azure Data Lake Store, hot data from Azure SQL Database
Modern data analytics platforms often follow a hub and spoke architecture in which a data hub is used as central data ingestion area that contains all data, usually in raw format. Data spokes deliver data to the majority of the end users in a data store that meets their specific requirements. The data hub can be build on Azure Data Lake Store (ADLS) and/or Azure SQL Data Warehouse. Data spokes can basically come in any form, dependent on the specific requirements. They are often build on Azure Blob Storage, Azure SQL Database (ASQLDB) and/or Azure Analysis Services (Azure AS). When ADLS is used as data hub to store data in raw unstructured format, a SQL DW/DB layer is typically used to deliver structured data to Azure AS models.