Follow these simple steps to load and query the Adventure Works Sample database. These scripts first use sqlcmd to run SQL which will create tables and views. Once tables have been created, the scripts will use bcp to load data. If you don't already have sqlcmd and bcp installed, follow these links to install bcp and to install sqlcmd.
Load sample data
- Download the Adventure Works Sample Scripts for SQL Data Warehouse zip file.
- Extract the files from downloaded zip to a directory on your local machine.
Edit the extracted file aw_create.bat and set the following variables found at the top of the file. Be sure to leave no whitespace between the "=" and the parameter. Below are examples of how your edits might look.
server=mylogicalserver.database.windows.net user=mydwuser password=Mydwpassw0rd database=mydwdatabase
From a Windows cmd prompt, run the edited aw_create.bat. Be sure you are in the directory where you saved your edited version of aw_create.bat. This script will...
- Drop any Adventure Works tables or views that already exist in your database
- Create the Adventure Works tables and views
- Load each Adventure Works table using bcp
- Validate the row counts for each Adventure Works table
- Collect statistics on every column for each Adventure Works table
Query sample data
Once you've loaded some sample data into your SQL Data Warehouse, you can quickly run a few queries. To run a query, connect to your newly created Adventure Works database in Azure SQL DW using Visual Studio and SSDT, as described in the query with Visual Studio document.
Example of simple select statement to get all the info of the employees:
SELECT * FROM DimEmployee;
Example of a more complex query using constructs such as GROUP BY to look at the total amount for all sales on each day:
SELECT OrderDateKey, SUM(SalesAmount) AS TotalSales FROM FactInternetSales GROUP BY OrderDateKey ORDER BY OrderDateKey;
Example of a SELECT with a WHERE clause to filter out orders from before a certain date:
SELECT OrderDateKey, SUM(SalesAmount) AS TotalSales FROM FactInternetSales WHERE OrderDateKey > '20020801' GROUP BY OrderDateKey ORDER BY OrderDateKey;
SQL Data Warehouse supports almost all T-SQL constructs which SQL Server supports. Any differences are documented in our migrate code documentation.