How do companies manage and document data flows in Smartsheet to ensure data integrity?
I’m new to Smartsheet and data meshing, and I’ve noticed that the original source data isn't always used consistently. For instance, someone might create a data mesh from a source to build their own sheet (Sheet B). Then, another person creates a data mesh from Sheet B, and this process continues.
How do companies manage and document these data flows to ensure that, if something breaks, we can trace back and identify where the issue occurred? I’m concerned that having too many sheets linked in this way could lead to data integrity risks.
Answers
-
@sarah.rohr17 This is a shortcoming from the platform, thus is a manual documentation process. I've seen it done in sheet form but it's a lot of typing etc. Or doing a diagram like a lucid chart or other diagram visualization software is one of the better ways I think. Of course this is still manual and should be done by a system admin / architect type person that understands the full structure. At that level you'd prob also want some kind of change management process to review changes, approve/deny them and indicate if those changes have been updated in the diagram also.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives