Is there a way to run unit tests on Redshift / Azure SQL DW to detect these sorts of problems?
Or would you run a separate test enviroment in a...

So how would you reconcile the idea that "unique index on fact table is not negotiable" with a product like Azure Sql Data Warehouse where there are no constraints?
Columnar...