Create an Azure SQL Data Warehouse

This tutorial uses the Azure portal to create a SQL Data Warehouse that contains an AdventureWorksDW sample database.

Prerequisites

To get started, you need:

Note

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

  1. Sign in to the Azure portal.
  2. Click + New > Databases > SQL Data Warehouse.

    Create

  3. In the SQL Data Warehouse blade, fill in the information needed, then press 'Create' to create.

    Create database

    • 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.
    Note

    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.

  4. Click Create to create your SQL Data Warehouse.

  5. 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.

    portal view

Create a server-level firewall rule in the Azure portal

  1. On the SQL server blade, under Settings, click Firewall to open the Firewall blade for the SQL server.

    sql server firewall

  2. 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.

    your IP address

  3. Assuming that the IP addresses match, click Add client IP on the toolbar.

    add client IP

    Note

    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.

  4. Click Save on the toolbar to save this server-level firewall rule and then click OK.

    add client IP

Next steps

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.

If you are trying to migrate an existing database to SQL Data Warehouse, see the Migration overview or use Migration Utility.

Firewall rules can also be configured using Transact-SQL. For more information, see sp_set_firewall_rule and sp_set_database_firewall_rule.

It's also a great idea to look at the Best practices.