Skip to main content
NOW AVAILABLE

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

  • Azure Synapse Analytics