Microsoft Azure - no SQL Data Warehouse

0
votes

Microsoft refers to creating an instance of a SQL Data Warehouse on Azure (NB NOT SQL Database), but there is no instance there that I can see. Please see attached screenshot of the Azure Portal Marketplace after typing in "SQL Data Warehouse".

This is part of their Data Science Associate Certification (Step 1 here: https://docs.microsoft.com/en-gb/learn/modules/understand-the-sql-dw-connector-with-azure-databricks/2-setup-the-environment) so would really appreciate if anyone can advise on how to get around / resolve this ??

NB if I try to create instead a SQL Database I come unstuck at step 4 in the above link as there is no option for "Select Performance level".

KR, Barry Walsh

enter image description here

2
sqlazureazure-sql-databaseazure-sqldwazure-sql-data-warehouse
It has now been rebranded Synapse – Nick.McDermaid
search for synapse instead – SqlKindaGuy

2 Answers

0
votes

Please create Azure SQL Data Warehouse database using the following method.

  1. Click Create a resource in the upper left-hand corner of the Azure portal.

  2. Select Databases from the New page, and select SQL Data Warehouse under Featured on the New page.

enter image description here

  1. Fill out the form.

enter image description here

  1. Select an existing Server or click Create new to create and configure a new server for your new database.

When finished, make sure you create a firewall rule that adds your client IP so you can connect to your database.

0
votes

SQL Data Warehouse is now renamed as "Azure Synapse Analytics."