From the course: Implementing a Data Warehouse SQL Server 2019

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Develop tables in Azure SQL Data Warehouse

Develop tables in Azure SQL Data Warehouse - SQL Server Tutorial

From the course: Implementing a Data Warehouse SQL Server 2019

Start my 1-month free trial

Develop tables in Azure SQL Data Warehouse

“

- [Instructor] Once your cloud hosted Azure SQL Data Warehouse is fully deployed, you can connect to it from management studio just like you would with an on-premises SQL Server instance. To do this, we need to create a firewall rule on the Data Warehouse Server in order to allow our computer to connect. Click on the Dashboard link at the top of the screen, or over here in the left-hand side menu, in order to get back to your main Dashboard. Then if your resources aren't showing here like mine aren't, go ahead and refresh the page. Next, I'll click the link for the SQL Data Warehouse that was just created. Mine was called KinetEcoAzureDW. That'll take you to the overview configuration page for the database. In the upper right-hand corner will be the server name that we're going to connect to. Mine is called adam-kineteco.database.windows.net. You can hover your mouse over it, and then click on the little page icon to…

Contents