Connect to SQL Data Warehouse with SQL Server Management Studio (SSMS)

Use SQL Server Management Studio (SSMS) to connect to and query Azure SQL Data Warehouse.

Prerequisites

To use this tutorial, you need:

1. Connect to your SQL Data Warehouse

  1. Open SSMS.

  2. Open Object Explorer. To do this, select File > Connect Object Explorer.

    SQL Server Object Explorer

  3. Fill in the fields in the Connect to Server window.

    Connect to Server

    • Server name. Enter the server name previously identified.
    • Authentication. Select SQL Server Authentication or Active Directory Integrated Authentication.
    • User Name and Password. Enter user name and password if SQL Server Authentication was selected above.
    • Click Connect.
  4. To explore, expand your Azure SQL server. You can view the databases associated with the server. Expand AdventureWorksDW to see the tables in your sample database.

    Explore AdventureWorksDW

2. Run a sample query

Now that a connection has been established to your database, let's write a query.

  1. Right-click your database in SQL Server Object Explorer.

  2. Select New Query. A new query window opens.

    New query

  3. Copy this TSQL query into the query window:

    SELECT COUNT(*) FROM dbo.FactInternetSales;
    
  4. Run the query. To do this, click Execute or use the following shortcut: F5.

    Run query

  5. Look at the query results. In this example, the FactInternetSales table has 60398 rows.

    Query results

Next steps

Now that you can connect and query, try visualizing the data with PowerBI.

To configure your environment for Azure Active Directory authentication, see Authenticate to SQL Data Warehouse.