We're working on adding identity column support for AUTO CDC! As of right now, we recommend adding the surrogate key in the source table before AUTO CDC. With regards to this, it might not be possible or even desired to add this complexity to the sou...
With standard tables we have the possibility to use columns with identity (sequence like) value. From the modeling perspective surrogate keys are considered as a good practice. How autocdc handles surrogate keys? You probably don't want your BI tool ...
Really nice post. I have a wish that someday I would see this solution in our company. @jeffreyaven Masking is great, but what about ABAC for table privileges? Are you planning something on this area?For example:I could tag the tables as domain = pro...
