Support SEQUENCE types in SQL DW
Thanks for your suggestion. We are looking into this scenario for a future release. 10703657
Nava Jeevan commented
This is a must have feature in the Azure SQL Data Warehouse as it doesn't maintain the order/sequence of the IDENTITY field.
Ralph Kemperdick commented
Having SEQUENCES makes porting DW solutions from SQL onprem to QL DW much easier.
Would make the life of DW architects much easier, specifically with regards to Data Vault models.
Did this is achieved by any means in SQL DW ?
I am unable to identify correct replacement for SEQUENCE in SQL dw.
This seems like it would be required for partition swap loading mechanisms, or? I am new to SQL DW and coming from Oracle, so perhaps the identify columns can handle that scenario.
Created due to the completion of IDENTITY. See here: https://feedback.azure.com/forums/307516/suggestions/12303591