September 2020
Beginner to intermediate
539 pages
12h 57m
English
Content preview from BigQuery for Data Warehousing: Managed Data Analysis in the Google CloudBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Index
A
Abigail’s Flowers (AF)
Amazon Web Services (AWS)
Analysis of variance (ANOVA)
Analytic functions
aggregate functions
definition
navigation functions
numeric functions
order of operations
partitions
window frame syntax
Artificial intelligence (AI)
autodetect flag
Automatic vs manual refresh
AutoML Tables
bonus analysis
BQML
configuring training
defining
evaluating model
importing dataset
predictions, making
training model
Avro
B
Backward-compatible model
BigQuery
aliasing
API
assignments
bq command line
column-oriented approach
commenting
compute costs
datasets
data storage
data structures
data warehouse
flat-rate pricing
FROM
GCP projects
GROUP BY
hierarchical data structure
LIMIT
normalization/denormalization
on-demand pricing
ORDER BY
partitioning
principle
query timing
reservations ...