IDC User Guide
prod
Search
⌃K
IDC User Guide
prod
Search
⌃K
Welcome!
Getting started
Core functions
Frequently asked questions
Support
Key pointers
IDC team
Introduction
Features
Google Cloud Platform (GCP)
Amazon AWS platform
DICOM
Requesting GCP cloud credits
Requesting AWS cloud credits
Data
Introduction
Data versioning
Organization of data
Downloading data
Data release notes
Data known issues
DICOM
Introduction to DICOM
Data model
Original objects
Derived objects
Coding schemes
DICOM-TIFF dual personality files
IDC DICOM white papers
Portal
Getting started
Exploring data and cohorts
Cohort manifests
Visualizing images
Proxy policy
Viewer release notes
Portal release notes
Portal known issues
API
Getting started
IDC Data Model Concepts
Accessing the API
Endpoint Details
Release notes
Cookbook
Colab notebooks
BigQuery
Data Studio
Compute engine
NCI Cloud Resources
Powered By GitBook

BigQuery

Get started with using BigQuery with IDC data following our Getting Started tutorial​
​This document contains various examples of using BigQuery for searching DICOM metadata in IDC BQ tables.

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​
Cookbook - Previous
Colab notebooks
Next - Cookbook
Data Studio
Last modified 5mo ago
Export as PDF
Copy link