This quickstart demonstrates how to use [!INCLUDEname-sos] to connect to Azure SQL data warehouse, and then use Transact-SQL statements to create, insert, and select data.

To complete this quickstart, you need [!INCLUDEname-sos], and an Azure SQL data warehouse.

• [Install [!INCLUDEname-sos]](download.md).

If you don't already have a SQL data warehouse, see Create a SQL Data Warehouse.

Remember the server name, and login credentials!

Use [!INCLUDEname-sos] to establish a connection to your Azure SQL Data Warehouse server.

1. The first time you run [!INCLUDEname-sos] the Connection page should open. If the Connection page doesn't open, click the New Connection icon in the SERVERS sidebar:

   

2. This article uses SQL Login, but Windows Authentication is also supported. Fill in the fields as follows:

   Setting	Suggested value	Description
   Server name	The fully qualified server name	The name should be something like this: sqldwsample.database.windows.net
   Authentication	SQL Login	SQL Authentication is used in this tutorial.
   User name	The server admin account	This is the account that you specified when you created the server.
   Password (SQL Login)	The password for your server admin account	This is the password that you specified when you created the server.
   Save Password?	Yes or No	Select Yes if you do not want to enter the password each time.
   Database name	leave blank	The name of the database to which to connect.
   Server Group	Select	If you created a server group, you can set to a specific server group.

   

3. If you get an error about the firewall, you need to create a firewall rule. To create a firewall rule, see Firewall rules.

4. After successfully connecting your server will appear in the object explorer.

1. Right click on your server, in the object explorer and select New Query.

2. Paste the following snippet into the query editor:

    IF NOT EXISTS (
       SELECT name
       FROM sys.databases
       WHERE name = N'TutorialDB'
    )
    CREATE DATABASE [TutorialDB] (EDITION = 'datawarehouse', SERVICE_OBJECTIVE='DW100');
    GO  
    
    ALTER DATABASE [TutorialDB] SET QUERY_STORE=ON
    GO

3. To execute the query, click Run.

The query editor is still connected to the master database, but we want to create a table in the TutorialDB database.

1. Change the connection context to TutorialDB:

   

2. Paste the following snippet into the query editor:

   -- Create a new table called 'Customers' in schema 'dbo'
   -- Drop the table if it already exists
   IF OBJECT_ID('dbo.Customers', 'U') IS NOT NULL
   DROP TABLE dbo.Customers
   GO
   -- Create the table in the specified schema
   CREATE TABLE dbo.Customers
   (
      CustomerId        INT     NOT NULL,
      Name      [NVARCHAR](50)  NOT NULL,
      Location  [NVARCHAR](50)  NOT NULL,
      Email     [NVARCHAR](50)  NOT NULL
   );
   GO

3. To execute the query, click Run.

1. Paste the following snippet into the query editor:

   -- Insert rows into table 'Customers'
   INSERT INTO dbo.Customers
      ([CustomerId],[Name],[Location],[Email])
      SELECT 1, N'Orlando',N'Australia', N'' UNION ALL
      SELECT 2, N'Keith', N'India', N'keith0@adventure-works.com' UNION ALL
      SELECT 3, N'Donna', N'Germany', N'donna0@adventure-works.com' UNION ALL
      SELECT 4, N'Janet', N'United States', N'janet1@adventure-works.com'

2. To execute the query, click Run.

1. Paste the following snippet into the query editor:

   -- Select rows from table 'Customers'
   SELECT * FROM dbo.Customers;

2. To execute the query, click Run.

   

Other articles in this collection build upon this quickstart. If you plan to continue on to work with subsequent quickstarts, do not clean up the resources created in this quickstart. If you do not plan to continue, use the following steps to delete resources created by this quickstart in the Azure portal. Clean up resources by deleting the resource groups you no longer need. For details, see Clean up resources.

Now that you've successfully connected to an Azure SQL data warehouse and ran a query, try out the Code editor tutorial.