cross-posted from: https://lemmy.ml/post/16693054
Is there a feature in a CI/CD pipeline that creates a snapshot or backup of a service's data prior to running a deployment? The steps of a ideal workflow that I am searching for are similar to:
- CI tool identifies new version of service and creates a pull request
- Manually merge pull request
- CD tool identifies changes to Git repo
- CD tool creates data snapshot and/or data backup
- CD tool deploys update
- Issue with deployment identified that requires rollback
- Git repo reverted to prior commit and/or Git repo manually modified to prior version of service
- CD tool identifies the rolled back version
- (OPTIONAL) CD tool creates data snapshot and/or data backup
- CD tool reverts to snapshot taken prior to upgrade
- CD tool deploys service to prior version per the Git repo
- (OPTIONAL) CD tool prunes data snapshot and/or data backup based on provided parameters (eg - delete snapshots after _ days, only keep 3 most recently deployed snapshots, only keep snapshots for major version releases, only keep one snapshot for each latest major, minor, and patch version, etc.)
That's true, but how often have you heard a finance team member wanting a CSV file so they can more easily process the data using Pandas or visualize it with MatPlotLib? How many accountants or finance people (especially those that ask for everything in Excel) do you know that is comfortable writing even a single line of Python code? How many of the finance team's Excel-based tools will Python integrate well with? What feature(s) does Python within Excel provide that Excel (formulas, pivot tables, VBA, Power Query, Power Pivot, etc.) does not provide that someone on the finance team would need? What advanced charting/dashboarding functionality does Python in Excel provide that isn't better accomplished in PowerBI (if not handled by standard Excel charts/graphs)?
Don't get me wrong - Microsoft's implementation of Python in Excel has its merits and will solve some problems that otherwise would not be possible in Excel and will make some people happy. However, this is not the solution most people were expecting, asking for, or find useful.