Automated team management table for PI review

gf-dcc / jobs

Containerized jobs and microservices

0 stars 0 forks source link

Automated team management table for PI review #7

Open anngvu opened 4 months ago

anngvu commented 4 months ago

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 commented 4 months ago

@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 commented 3 months ago

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?).