Provide a stored procedure or function to make it easy to copy sensitivity classifications from one table to another
Currently, it's very easy to accidentally drop data sensitivity classifications when loading a table through CTAS, rename, and drop. If you load a table in this manner and you have data sensitivity classifications, you need to copy them over from the old table to the new before dropping the old table. This is a rather tedious manual effort. This should be made much easier, or the issue should be resolved in some other manner where the classifications are not dropped at all. Otherwise, we won't be able to trust an audit of that information. For an explanatory demo, see https://github.com/mlongoria/AzureSQLDW/blob/master/Azure%20SQL%20DW%20Data%20Classifications.ipynb

1 comment
-
Mohit Kumar commented
Doing a CTAS also drops the data masking changes. Given CTAS is one of the recommended ways to maintain health of large tables as well as loading data in case of UPSERT, having a SPROC or support through SSDT will help us automatically apply the data masking and sensitivity classification of old table to the new one