O'Reilly logo

Microsoft Azure SQL Data Warehouse - Architecture and SQL by Todd Wilson, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2 – The Azure SQL Data Warehouse Table Structures

“Let me once again explain the rules.The Azure SQL Data Warehouse Rules!”

- Tera-Tom Coffing

The 5 Concepts of Azure SQL Data Warehouse Tables

1.Tables are either Distributed by Hash or Replicated

2.The rows of a table are either sorted or unsorted

3.Tables are stored physically on disk in either a row or columnar Format

4.Tables can be partitioned

5.Tables are either permanent, temporary or external Tables

Above, are some basics about concepts for Azure SQL Data Warehouse tables. The next five pages will cover each point one at a time. This will allow you to see exactly what is going on immediately.

Tables are Either Distributed by Hash or Replicated (1 of 5)

The Azure SQL Data Warehouse ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required