Azure SQL Data Warehouse Surrogate Keys
<p>So Azure SQL Data Warehouse doesn't support identity columns, and therefore it's tricky to deal with surrogate keys.. anyone got any bold solutions on this one?</p>

<p><a href="https://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/04/12/parallel-data-warehouse-pdw-tip-surrogate-key-generation" rel="noreferrer">This</a> is best i have found, and it's pretty horrific.</p>