add a folder to maintain BQ QA queries

ImagingDataCommons / ETL

(CORE REPO)

Apache License 2.0

0 stars 1 forks source link

add a folder to maintain BQ QA queries #7

Closed fedorov closed 3 years ago

fedorov commented 4 years ago

Added query to count unique UIDs used for Study/Series/SOPInstanceUID.

@bcli4d let's keep queries of this sort in this folder, and then maybe they can be executed automatically as part of the ETL process, to reduce the risk of surprises like the one we had yesterday?

fedorov commented 4 years ago

TODO: need to ensure that in addition to no clashes across data model levels, a UID should be encountered only once at each level

fedorov commented 4 years ago

@bcli4d I think this is ready for your review. Checking for uniqueness within each level is not trivial, not actually sure how to do this, but this specific query should be useful as is. If it is correct!