Making Python code snippets available to internal non-technical userbase?
This is a more general question pertaining to a business need.
At my company many requests come through that require an analyst to run a mini "code snippet". These code snippets could be in SQL, Python, R, or a combination of the languages.
The code is often extremely simple (<30 lines) and either doesn't change or changes minimally from request to request (i.e. the "where" statement of a SQL query might change).
I am wondering what the best way is to give a "non-tech" interface to the users where they can run these code snippets while maintaining version control on my side?
Potential problems I've thought of:
- I want to ensure that the users don't have direct access to the code as they could easily break it.
- Additionally, if there was some way to version control the software that would be ideal as well. I'd rather that an update to Pandas (Python) or any other software/module not break all the scripts. I don't know how this is possible.
- The users have no tech background so running code from the command line, anaconda prompt, git bash or any other cmd like interface is probably not an option.
Thanks for your help!!