The Data Lake resource will be created and configured from the Azure Portal. The prerequisites are:
- An Azure SQL Server instance
- A blob storage account
We have created the following view in the SQL Server database. The SQL Server Linked Service has already been created in a previous chapter:
CREATE VIEW ADFV2Book.Purchase ASSELECT Dimension.Date.Date,Dimension.Supplier.Supplier,Dimension.Supplier.Category,Dimension.[Stock Item].[Stock Item],Fact.Purchase.[Ordered Quantity]FROM Fact.PurchaseINNER JOIN Dimension.DateON Fact.Purchase.[Date Key] = Dimension.Date.DateINNER JOIN Dimension.[Stock Item]ON Fact.Purchase.[Stock Item Key] = Dimension.[Stock Item].[Stock Item Key]INNER JOIN Dimension.SupplierON Fact.Purchase.[Supplier ...