Temporal Table support in AzureSQLDW
Is this on the roadmap? Currently they are not a thing in the Parallel DW:
Thanks for your suggestion. We are looking into this scenario for a future release. 10714515
Paul Oster commented
This would be a great benefit. Is there an update on this?
Any updates? Last post was in 2017 for a future release.
Frederic Forest commented
Any news on this. This is hailed as a killer feature of Snowflake by our clients...
This will be a massive improvement to our ETL process any update about this ?
Alexandre Delarue commented
As part of an ETL process to SQL DW, temporal tables can be a great asset to track dimensional changes. I'd love to understand as well what the likelihood of having this feature in SQL DW is to advise my customer. Current workaround is to have an Azure SQL DB hosts some of the metadata and make sure things are in sync with SQL DW.
We utilize temporal tables in our Azure SQL DB instances and it provides considerable value. It would be great if Azure SQL DW would support this feature also.