- This document outlines the steps to create authorized views in your projects: https://cloud.google.com/bigquery/docs/views
- This document outlines how to specify nested and repeated fields when creating the tables: https://cloud.google.com/bigquery/docs/nested-repeated
- An overview of partition tables and best practices are outlined here: https://cloud.google.com/bigquery/docs/partitioned-tables
- This document outlines how to query wildcard tables using standard SQL: https://cloud.google.com/bigquery/docs/reference/standard-sql/wildcard-table-reference
- How to query nested and repeated fields using legacy SQL: https://cloud.google.com/bigquery/docs/legacy-nested-repeated
- How to migrate from legacy SQL to standard SQL: https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql
- How to connect to external data sources: https://cloud.google.com/bigquery/external-data-sources