Setup BQ table to read filterview specs and pull values from that table back into the function

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

Setup BQ table to read filterview specs and pull values from that table back into the function #93

Closed RyanFWebb closed 3 months ago

RyanFWebb commented 4 months ago

Met with Larry March 1 to review the filter view function. We have a working solution and now need to generalize it so that filter specifications can be stored and added here for VCEP Tracker Updates by ClinGen.

This will also be the first step in automating the generation of these reports going forward.

RyanFWebb commented 3 months ago

I created a new query called "15. filter_views_proc" in the clingen-stage project queries which correctly loads the table with the values we need. The issue I'm running into is trying to add the query to the read.me to generate an actual table to query in the variant tracker. I'm assuming it's a gap in my understanding of BQ. Planning to review with @larrybabb on Friday.