Azure SQL Data Warehouse now supports User-Defined Restore Points.
This feature enables you to trigger snapshots through PowerShell to create restore points of your data warehouse before and after large modifications. This capability ensures that restore points are logically consistent, which provides additional data protection in case of any workload interruptions or user errors for quick recovery time.
You can find more details on the documentation page.