Google BigQuery Guide
- 1. Introduction
- 2. Query Execution
- 2.1. Service Account Credentials
- 3. Query Syntax
- 3.1. Identifiers
- 3.2. Character Sets
- 3.3. FLOAT64 and Rounding Errors
- 3.4.
WITH RECURSIVE - 3.5. Scripting
- 3.6. Stored Procedures
- 3.7. Cloud SQL Federated Queries
- 4. Query Performance
- 4.1. Partition Elimination
- 4.1.1. Partition Elimination - Filter, PF and Literal
- 4.1.2. Partition Elimination - Filter, PF and Expression
- 4.1.3. Partition Elimination - Filter, PF and SSQ
- 4.1.4. Partition Elimination - Filter, PFE and Literal
- 4.1.5. Partition Elimination - Filter, PFE and Expression
- 4.1.6. Partition Elimination - Filter, PFE and SSQ
- 4.1.7. Partition Elimination - Filter, NPF and Literal
- 4.1.8. Partition Elimination - Filter, NPF and Expression
- 4.1.9. Partition Elimination - Filter, NPF and SSQ
- 4.1.10. Partition Elimination - Filter, NPFE and Literal
- 4.1.11. Partition Elimination - Filter, NPFE and Expression
- 4.1.12. Partition Elimination - Filter, NPFE and SSQ
- 4.1.13. Partition Elimination - DTJ, PF and Field
- 4.1.14. Partition Elimination - DTJ, PF and Field Expression
- 4.1.15. Partition Elimination - DTJ, PFE and Field
- 4.1.16. Partition Elimination - DTJ, PFE and Field Expression
- 4.1.17. Partition Elimination - DTJ, NPF and Field
- 4.1.18. Partition Elimination - DTJ, NPF and Field Expression
- 4.1.19. Partition Elimination - DTJ, NPFE and Field
- 4.1.20. Partition Elimination - DTJ, NPFE and Field Expression
- 4.2. Troubleshooting Queries
- 4.2.1. Query Job Information Via SQL
- 4.2.2. Query Job Information Via Command Line
- 4.2.3. Interpreting Query Job Information
- 4.2.4. Troubleshooting Queries - Checklist
- 4.2.5. Troubleshooting Query Errors
- 4.2.5.1.
rateLimitExceeded - too many
concurrent queries
- 5. Projects, Datasets, Tables, and Arrays
- 5.1.
project_id - 5.1.1.
region - 5.1.1.1. INFORMATION_SCHEMA
- 5.1.1.1.1. JOBS_BY_USER
- 5.1.1.1.2. JOBS_BY_PROJECT
- 5.1.1.1.3. JOBS_BY_ORGANIZATION
- 6. Queries
- 6.1. Primary Key Test
- 6.2. Query Jobs
- 6.3. Query Job Stages
- 6.4. Query Jobs Delay Categories
- 6.5. Projects Query Jobs Elapsed Time Analysis
- 6.6. List In-Flight Query Jobs at a Given Time
- 6.7. Users Billing Jobs to a Project