Name changes: Azure SQL Data Warehouse Gen1 and Gen2
Published date: May 07, 2018
Azure SQL Data Warehouse is a fast, flexible, and trusted analytics platform for enterprises. A new tier called “Gen2” is generally available in 20 Azure regions and offers these benefits:
- Improves individual query execution times by as much as 10 times over the Gen1 tier
- Provisions SQL Data Warehouse with five times the computing power and unlimited storage capacity, making it suitable for the most intensive analytics workloads
- Uses the latest generation of Azure hardware to improve compute and storage scalability
To reflect key investments and capability updates, “SQL Data Warehouse” is now renamed to “Compute Optimized Gen1” or “Compute Optimized Gen2,” respectively. See the following table for name change details.
Resource GUID | Old service name | New service name | Old service type | New service type | Old resource name | New resource name | Region name | Old EA portal name | New EA portal name |
f6522325-5263-4a7f-a8c3-0c0d127da4dd | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | AP East | Data Services SQL Data Warehouse - AP East | SQL Data Warehouse Compute Optimized Gen1 100 DWU - AP East |
c6067198-1a09-4382-8607-a750ad29560f | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | AP Southeast | Data Services SQL Data Warehouse - AP Southeast | SQL Data Warehouse Compute Optimized Gen1 100 DWU - AP Southeast |
19a35a32-daa5-4f03-8feb-0151ed734a17 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | AU East | Data Services SQL Data Warehouse DWU - AU East | SQL Data Warehouse Compute Optimized Gen1 100 DWU - AU East |
cfc04eb4-da44-457c-89e9-6547186c2408 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | AU Southeast | Data Services SQL Data Warehouse - AU Southeast | SQL Data Warehouse Compute Optimized Gen1 100 DWU - AU Southeast |
46a9341f-64e4-4601-a22c-33669b243676 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | BR South | Data Services SQL Data Warehouse - BR South | SQL Data Warehouse Compute Optimized Gen1 100 DWU - BR South |
64443c94-8202-4c8f-bdb3-9d00e7148dc6 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | CA Central | Data Services SQL Data Warehouse DWU CA Central | SQL Data Warehouse Compute Optimized Gen1 100 DWU - CA Central |
fe7a13af-d09a-4dc9-87f5-4360b9e3e84e | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | CA East | Data Services SQL Data Warehouse DWU CA East | SQL Data Warehouse Compute Optimized Gen1 100 DWU - CA East |
d5df636c-7dc1-47ec-9529-d4aee5bef56b | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | DE Central | Data Services SQL Data Warehouse - DE Central | SQL Data Warehouse Compute Optimized Gen1 100 DWU - DE Central |
c1df86ea-fad7-4bd0-bcea-8dad68aeeefb | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | DE Northeast | Data Services SQL Data Warehouse - DE Northeast | SQL Data Warehouse Compute Optimized Gen1 100 DWU - DE Northeast |
dfacce61-cae1-44de-9c39-1ada59995bda | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | EU North | Data Services SQL Data Warehouse - EU North | SQL Data Warehouse Compute Optimized Gen1 100 DWU - EU North |
061710cf-1114-4164-8f6d-54b1b4a52eb5 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | EU West | Data Services SQL Data Warehouse - EU West | SQL Data Warehouse Compute Optimized Gen1 100 DWU - EU West |
a7eb5d95-d003-4e4e-bcc5-381781b050d0 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | IN Central | SQL Data Warehouse IN Central | SQL Data Warehouse Compute Optimized Gen1 100 DWU - IN Central |
831bc3d3-78d6-4713-8262-4415317dfb43 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | IN South | SQL Data Warehouse IN South | SQL Data Warehouse Compute Optimized Gen1 100 DWU - IN South |
5c099bdb-e562-4ec7-8ecf-5a44dfa1e575 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | IN West | Data Services SQL Data Warehouse DWU - IN West | SQL Data Warehouse Compute Optimized Gen1 100 DWU - IN West |
c02d68cf-36b2-476b-8854-66fcf7c4a921 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | JA East | Data Services SQL Data Warehouse - JA East | SQL Data Warehouse Compute Optimized Gen1 100 DWU - JA East |
11dc0654-64fc-462b-ac12-54a2b6d2cd71 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | JA West | Data Services SQL Data Warehouse DWU - JA West | SQL Data Warehouse Compute Optimized Gen1 100 DWU - JA West |
cefd815c-1662-4b31-9423-cf1503649807 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | KR Central | Data Services SQL Data Warehouse DWU - KR Central | SQL Data Warehouse Compute Optimized Gen1 100 DWU - KR Central |
29be099a-4a54-4d01-9b59-ad9263159bdd | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | KR South | Data Services SQL Data Warehouse DWU - KR South | SQL Data Warehouse Compute Optimized Gen1 100 DWU - KR South |
1e2ef9a9-b011-49de-9097-e20558abd997 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | UK South | Data Services SQL Data Warehouse DWU - UK South | SQL Data Warehouse Compute Optimized Gen1 100 DWU - UK South |
d01174fe-3968-46a4-b62a-572550530e33 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | UK West | Data Services SQL Data Warehouse DWU - UK West | SQL Data Warehouse Compute Optimized Gen1 100 DWU - UK West |
22e690b0-183e-4266-bbeb-0c8ccf98f160 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | US Central | Data Services SQL Data Warehouse - US Central | SQL Data Warehouse Compute Optimized Gen1 100 DWU - US Central |
e40c606b-e16c-4803-aac4-1e47666f4609 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | US East | Data Services SQL Data Warehouse - US East | SQL Data Warehouse Compute Optimized Gen1 100 DWU - US East |
b8b9adcd-ab9d-4a0a-af03-8c24150dd027 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | US East 2 | Data Services SQL Data Warehouse - US East 2 | SQL Data Warehouse Compute Optimized Gen1 100 DWU - US East 2 |
7d497e63-48d8-4497-90ad-265412de9e25 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | US North Central | Data Services SQL Data Warehouse DWU - US North Central | SQL Data Warehouse Compute Optimized Gen1 100 DWU - US North Central |
8482b9d1-8fe9-4daa-9296-e5c93a9c0da6 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | US South Central | Data Services SQL Data Warehouse - US South Central | SQL Data Warehouse Compute Optimized Gen1 100 DWU - US South Central |
a9f53a13-21fc-45c6-aade-c42e2accf259 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | US West | Data Services SQL Data Warehouse - US West | SQL Data Warehouse Compute Optimized Gen1 100 DWU - US West |
016284cd-2b47-4ba4-9f41-2b3b26ee7d6e | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | US West 2 | Data Services SQL Data Warehouse - US West 2 | SQL Data Warehouse Compute Optimized Gen1 100 DWU - US West 2 |
546766c8-64f6-41ba-9131-5fac73e1339f | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen1 | DWU | 100 DWU | US West Central | Data Services SQL Data Warehouse - US West Central | SQL Data Warehouse Compute Optimized Gen1 100 DWU - US West Central |
dbe469a8-2f51-47da-b85f-633fde6e09d1 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | AP East | Data Services SQL Data Warehouse cDWU - AP East - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - AP East |
9a2d5618-db3d-4e80-a3e2-2725833f3aa2 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | AP Southeast | Data Services SQL Data Warehouse cDWU - AP Southeast - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - AP Southeast |
1e876796-02bc-4130-a247-0276f574cbc3 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | AU East | Data Services SQL Data Warehouse cDWU - AU East - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - AU East |
f1a3f75c-2d4b-4c0f-8837-2fd26f116d22 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | AU Southeast | Data Services SQL Data Warehouse cDWU - AU Southeast - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - AU Southeast |
82d0d3c5-c7d3-4e1a-98ae-8239d7ed620f | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | CA Central | Data Services SQL Data Warehouse cDWU - CA Central - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - CA Central |
5b3a11bf-fe9d-48ba-80d6-2e717833bfe6 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | EU North | Data Services SQL Data Warehouse cDWU - EU North - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - EU North |
74d767a6-ec36-4152-b86f-c1a25730fe5a | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | EU West | Data Services SQL Data Warehouse cDWU - EU West - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - EU West |
e06656c4-64f6-445c-87f4-d7d184bc45cd | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | IN Central | Data Services SQL Data Warehouse cDWU - IN Central - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - IN Central |
e18de903-3112-4474-a83b-497d20a19c9c | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | IN South | Data Services SQL Data Warehouse cDWU - IN South - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - IN South |
ed5da884-c08a-4795-887e-0d32c18a3df2 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | JA East | Data Services SQL Data Warehouse cDWU - JA East - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - JA East |
81d07263-6439-4648-81ef-a8bbb975bfe4 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | JA West | Data Services SQL Data Warehouse cDWU - JA West - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - JA West |
7ef9a871-3472-40d7-8fea-66da81268d43 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | KR South | Data Services SQL Data Warehouse cDWU - KR South - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - KR South |
83778534-91d7-4960-84ac-80307a16405b | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | UK South | Data Services SQL Data Warehouse cDWU - UK South - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - UK South |
a0f6a58f-7a76-4029-b6a9-e592ab40f71f | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | US Central | Data Services SQL Data Warehouse cDWU - US Central - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - US Central |
cc5e0b3e-9ebc-451a-8b78-904f230e975b | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | US East | Data Services SQL Data Warehouse cDWU - US East - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - US East |
6305804e-0202-4bf5-8a58-471c62a12bde | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | US East 2 | Data Services SQL Data Warehouse cDWU - US East 2 - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - US East 2 |
99d24c1c-93f5-4220-bb3b-8e94ccf4322a | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | US North Central | Data Services SQL Data Warehouse cDWU - US North Central - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - US North Central |
b8e19ca3-1e1f-4147-94d3-8ddd9e65ab65 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | US South Central | Data Services SQL Data Warehouse cDWU - US South Central - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - US South Central |
5258e1cf-ae14-42fd-9b31-eaa4283fce26 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | US West | Data Services SQL Data Warehouse cDWU - US West - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - US West |
f5f041ad-8a0f-4694-bf45-22326eb6ea25 | Data Services | SQL Data Warehouse | SQL Data Warehouse | Compute Optimized Gen2 | cDWU | 100 DWU | US West 2 | Data Services SQL Data Warehouse cDWU - US West 2 - Preview | SQL Data Warehouse Compute Optimized Gen2 100 DWU - US West 2 |