Compare Azure Data WareHouse vs Azure Data Lake Analytics

761 Views Asked by At

How do Azure Data warehouse & Azure Data Lake Compare in respective to 1) External Table 2) Internal Table 3) Column store Clustered Index 4) connecting to Internal & External Table from SQL Server Management Studio to Internal/External Tables.

1

There are 1 best solutions below

1
On

I'd be happy to help. Can you tell me more about the holistic thing you're trying to do here. SQL DW and Azure Data Lake have their own scope and things they are best at. Picking a narrow set of features without understanding your holistic goal could get us started in the wrong direction. Guy