# BigQuery

Get started with using BigQuery with IDC data following our [Getting Started tutorial](https://github.com/ImagingDataCommons/IDC-Examples/tree/master/notebooks/getting_started)

[This document](https://docs.google.com/document/d/1qC5_qUFBQ2HmEjfYQa9WaH1Y-erMlfis00bbU8UPnRs/edit?usp=sharing) contains various examples of using BigQuery for searching DICOM metadata in IDC BQ tables.

## Learning resources

* [Intro to SQL course on Kaggle](https://www.kaggle.com/learn/intro-to-sql)
* 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>