Understanding data export scenarios
As much as possible, when you are thinking about building your analytical environment, you should work with the premise of keeping a single point of truth in your data, meaning, you have one repository that holds the true version of your data. This is a structural principle of data management, especially in analytics, to ensure everyone makes decisions based on the same data. If someone needs to know how much product the company sold the previous month or the failure rate of IoT sensors, this one repository holds the truth that helps answer these questions. The moment you start copying data to different places, it becomes susceptible to user changes that affect a table’s layout, or even the data itself, creating several different versions of the data and removing that single point of truth.
However, not every analytical problem is solved in one single platform. The ability to export data to a different location is an essential tool in any...