Data-Engineer

 64: Building a Fact Table:  We are going to make use of the existing SQL server database that we have this database has the adventure works sample data.  We will be using SQL Server Management Studio to connect both to the my SQL Database SQL Datawarehouse . we are not connected to Azure sql Database and our Dedicate SQL pool -- which is the Datawarehouse. We are creating a View based out two tables in "SalesOrderDetails" & "SalesOrderHeader" and create a table out of it and the copy it to the Datawarehouse on Azure Synapse.

 -- Working with external Tables External Table can be used to read and write data in Hadoop , Azure Blob Storage, Azure Data Lake. 59: Loading Data using Polybase :  62 : To be continued : Designing a Data Warehouse