Azure SQL Datawarehouse

 Data Types: Tips: only use small data types. Avoid defining columns to be a large default length.don't use nvarchar if you dont ned unicode.

Table Types:

1. clustered  columnstore : great for readonly large data. Default data type used by azure sql datawarehouse uses. High compression in data.
2. Heap: for storing temporary data  and no order in data. fast to load.
3. clustered B-tree Index:  index stored in a way data being indexed is stored

Table Partitioning:

To improve query performance, partitioning done. Can be done on basis of date columnstore.