Section : 4 : Design & Implement Data Storage

 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.






Comments

Post a Comment

Popular posts from this blog

Azure Synapse

Image
Not a SQL Server or a Azure Synapse , you can make use of the Azure Synapse service. Earlier they only had the service for hosting a sql data warehouse and then they brought the service of Azure synapse.  Initially while using the Azure synapse was that you can host a sql data warehouse. Over the time they have introduced many services to Azure synapse itself . Now you can host a sql database using the sql option as part of the entire Eco-system as part of the Azure synapse . But at the same time you can also make use of Apache Spark when it comes to Analyzing your data . You can bring your data much more closer for your Analytical needs by bring your "Azure Data Lake" attaching it basically to your Azure synapse workspace . You can use the tools on the right hand side which can be used for visualization. You can actually ingest your data using data injection tools on the left. -- Creating an Azure Synapse workspace : The first thing about working with Azure Synapse is creati...
Read more