Database Reference
In-Depth Information
how to move the computation from operations over rows in tables to
operations over the tables. All the complexity of the query was inside the
FROM
clause with a simple boilerplate in the other clauses. Clearly this was
a bit contrived. Real-world applications have most of the logic in the clauses
operating on the data in the table with a little bit of logic in the
FROM
clause
to specify a relevant set of tables (or table slices). The sample application has
examples that use this functionality, which you can explore.
Summary
This chapter covered strategies for managing data within BigQuery and
across the Google Cloud Platform as it relates to data warehousing. Some of
these strategies are related to schemes you can use in a traditional database
or data warehouse but implement in a manner better suited to operating in
the cloud and within BigQuery. The sample application combines a few of
these strategies to illustrate how they fit together in a realistic application.
Similarly, you can find the right combination of features to support your
analytics applications.
