Automated team management table for PI review

[anngvu]

Currently, we cannot configure to have Synapse show a real-time "Permissions" view by team/user similar to a Project or Fileview, so we should run a script to create such a table, which requires using the team members API.

Note: we can also do this with Snowflake (create a dashboard on Snowflake), but Synapse might be nicer for researchers instead of yet another separate platform to remember (?).

[anngvu]

@cconrad8 This ticket is for the script option. We can use this to track development if you:

• adapt the script from Verena's example
• need help from me for adapting script / adding features

I think it's good to explore both for the learning experience / seeing the comparison for yourself, though I'm leaning towards the script option for simplicity. If script, it would be good for the code to live here so it can be modified as we add teams, etc.

[anngvu]

OK, @cconrad8 did a little exploration in Python, but it was decided that I can more easily make this happen with an R script for now to compile all teams into a single-page table view in Synapse real-time (+ also thinking as a report to be sent out at quarterly intervals?).