BigQuery

The document with the recipes below needs to be updated to work with the layout of the public tables in IDC!
​This document contains various examples of using BigQuery for searching DICOM metadata in IDC BQ tables.
​This notebook provides some examples of using BigQuery for exploring metadata of a collection in IDC.
Learning resources
​Intro to SQL course on Kaggle​
Query performance considerations
​https://cloud.google.com/bigquery/docs/best-practices-performance-overview​
​https://cloud.google.com/bigquery/docs/best-practices-performance-compute​
Temporary tables: https://cloud.google.com/bigquery/docs/multi-statement-queries#temporary_tables​

Last modified 6mo ago