Forum Discussion
DevOps Source Control not tracking changes in data warehouse
Hi dzav ,
You may normally see at least a change recognized at the warehouse level when something is updated, even if it’s not granular down to each table or view.I’d suggest double-checking the Source Control configuration and adding a small change to see if it gets recognized , that might help to determine whether it’s a one-time miss.
Thank you.This is still an issue for us. However, I discovered that if I make any changes in the service directly even if it's not technically a change - i.e. scripting a create or alter view with no changes - this allows DevOps to pick up all the code changes that were made since the last commit. It looks like any change that we make in SSMS aren't being picked up by source control. We tested this in both SSMS 20 & SSMS 21.
Hi KPInapple ,
Can you please confirm whether you have resolved issue. If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.