search

clingen-data-model / clinvar-ingest-reports

ClinGen generates several google sheet based reports from the ClinVar ingested data that originates from the Broad BigQuery data.
0 stars 0 forks source link

Implement Filter View Updates across VCEP Tracker Sheets. #97

Closed RyanFWebb closed 2 months ago

RyanFWebb commented 2 months ago

Use working Filter View Update Function to update VCEP Tracker Sheets in the BQ Support Table, iterating through each sheet ID. This should be added as an admin option in the BQ Support Tables sheet.

RyanFWebb commented 2 months ago

This is finished. All of the filter views across each sheet that we manage can be automatically updated now so that their ranges and specs are concordant with what's entered in the BQ Support Tables VCEP Tracker Configs Sheet.

We may want to update the How To Use VCEP Variant Tracker Report to reflect that filter views that are preceded by "**" are managed by ClinGen and not to play with them.

Additionally, I noticed I needed to authorize my Google account for each sheet to refresh the filter views, so this would need to be done by whichever admin is running the update for any sheets they are not yet authorized for. It may be helpful to find a way to bypass this in the future, but I wrote in a feature to the function that indicate which sheet(s) you may need to add authorization for if it throws an error.

RyanFWebb commented 2 months ago

How should we handle refreshing the filter views to update their ranges whenever a VCEP refreshes their tracker? Embed the function in the sheet specific refresh function? Run the admin function every few days? Let me know what makes the most sense.

larrybabb commented 2 months ago

I don't think we need a process for executing this. We will be building on this feature to expand the ability to reset more than just the filter views. I think for now if we are told or happen to notice a filter view is not correct in a vcep tracker sheet then we manually execute this feature to reset them all.