Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: ✅ Warehouse in Microsoft Fabric
This article describes how to get started with Warehouse in Microsoft Fabric using the Microsoft Fabric portal, including discovering creation and consumption of the warehouse. You learn how to create your warehouse from scratch and sample along with other helpful information to get you acquainted and proficient with warehouse capabilities offered through the Microsoft Fabric portal.
Tip
You can proceed with either a new blank Warehouse or a new Warehouse with sample data to continue this series of Get Started steps.
You can start creating your warehouse from the workspace. Select + New Item and look for the Warehouse or Sample warehouse card under the Store data section.
An empty warehouse is created for you to start creating objects in the warehouse. You can use either sample data to get a jump start or load your own test data if you prefer.
Another option available to create your warehouse is through the Create button in the navigation pane. Look for the Warehouse or Sample warehouse cards under Data Warehouse.
Once initialized, you can load data into your warehouse. For more information about getting data into a warehouse, see Ingesting data.
In this section, we walk you through creating a sample Warehouse from scratch.
Select the Warehouse sample card.
Provide the name for your sample warehouse and select Create.
The create action creates a new Warehouse and start loading sample data into it. The data loading takes few minutes to complete.
On completion of loading sample data, the warehouse opens with data loaded into tables and views to query.
If you have an existing warehouse created that's empty, the following steps will show how to load sample data.
Once you have created your warehouse, you can load sample data into warehouse from Use sample database card on the home page of the warehouse.
The data loading takes few minutes to complete.
On completion of loading sample data, the warehouse displays data loaded into tables and views to query.
The following sample T-SQL scripts can be used on the sample data in your new warehouse.
Note
It is important to note that much of the functionality described in this section is also available to users via a TDS end-point connection and tools such as SQL Server Management Studio (SSMS) or Azure Data Studio (for users who prefer to use T-SQL for the majority of their data processing needs). For more information, see Connectivity or Query a warehouse.
/*************************************************
Get number of trips performed by each medallion
**************************************************/
SELECT
M.MedallionID
,M.MedallionCode
,COUNT(T.TripDistanceMiles) AS TotalTripCount
FROM
dbo.Trip AS T
JOIN
dbo.Medallion AS M
ON
T.MedallionID=M.MedallionID
GROUP BY
M.MedallionID
,M.MedallionCode
/****************************************************
How many passengers are being picked up on each trip?
*****************************************************/
SELECT
PassengerCount,
COUNT(*) AS CountOfTrips
FROM
dbo.Trip
WHERE
PassengerCount > 0
GROUP BY
PassengerCount
ORDER BY
PassengerCount
/*********************************************************************************
What is the distribution of trips by hour on working days (non-holiday weekdays)?
*********************************************************************************/
SELECT
ti.HourlyBucket,
COUNT(*) AS CountOfTrips
FROM dbo.Trip AS tr
INNER JOIN dbo.Date AS d
ON tr.DateID = d.DateID
INNER JOIN dbo.Time AS ti
ON tr.PickupTimeID = ti.TimeID
WHERE
d.IsWeekday = 1
AND d.IsHolidayUSA = 0
GROUP BY
ti.HourlyBucket
ORDER BY
ti.HourlyBucket
Tip
You can proceed with either a blank Warehouse or a sample Warehouse to continue this series of Get Started steps.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Get started with data warehouses in Microsoft Fabric - Training
Understand the key components and design considerations for implementation of data warehouses in Microsoft Fabric.
Certification
Microsoft Certified: Fabric Data Engineer Associate - Certifications
As a Fabric Data Engineer, you should have subject matter expertise with data loading patterns, data architectures, and orchestration processes.