This tutorial uses the Azure portal to create a SQL Data Warehouse that contains an AdventureWorksDW sample database.
To get started, you need:
- Azure account: Visit Azure Free Trial or MSDN Azure Credits to create an account.
- Azure SQL server: See Create an Azure SQL database with the Azure portal for more details.
Creating a SQL Data Warehouse might result in a new billable service. See SQL Data Warehouse pricing for more details.
Create a SQL Data Warehouse
- Sign in to the Azure portal.
Click + New > Databases > SQL Data Warehouse.
In the SQL Data Warehouse blade, fill in the information needed, then press 'Create' to create.
- Server: We recommend you select your server first.
- Database name: The name that is used to reference the SQL Data Warehouse. It must be unique to the server.
- Performance: We recommend starting with 400 DWUs. You can move the slider to the left or right to adjust the performance of your data warehouse, or scale up or down after creation. To learn more about DWUs, see our documentation on scaling or our pricing page.
- Subscription: Select the subscription that this SQL Data Warehouse will bill to.
- Resource group: Resource groups are containers designed to help you manage a collection of Azure resources. Learn more about resource groups.
- Select source: Click Select source > Sample. Azure automatically populates the Select sample option with AdventureWorksDW.
The default collation for a SQL Data Warehouse is SQL_Latin1_General_CP1_CI_AS. If a different collation is needed, T-SQL can be used to create the database with a different collation.
Click Create to create your SQL Data Warehouse.
Wait for a few minutes. When your data warehouse is ready, you should be returned to the Azure portal. You can find your SQL Data Warehouse on your dashboard, listed under your SQL Databases, or in the resource group that you used to create it.
Create a server-level firewall rule in the Azure portal
On the SQL server blade, under Settings, click Firewall to open the Firewall blade for the SQL server.
Review the client IP address displayed and validate that this is your IP address on the Internet using a browser of your choice (ask "what is my IP address). Occasionally they do not match for a various reasons.
Assuming that the IP addresses match, click Add client IP on the toolbar.
You can open the SQL Database firewall on the server to a single IP address or an entire range of addresses. Opening the firewall enables SQL administrators and users to login to any database on the server to which they have valid credentials.
Click Save on the toolbar to save this server-level firewall rule and then click OK.
Now that you have created a SQL Data Warehouse, you are ready to Connect and begin querying.
To load data into SQL Data Warehouse, see the loading overview.
It's also a great idea to look at the Best practices.