Deploying and Managing BigQuery
BigQuery is a fully managed database service, so Google takes care of backups and other basic administrative tasks. As a Cloud Engineer, you still have some administrative tasks when working with BigQuery. Two of those tasks are estimating the cost of a query and checking on the status of a job.
Estimating the Cost of Queries in BigQuery
In the console, choose BigQuery from the main navigation menu to display the BigQuery query interface, as shown in Figure 12.12.
FIGURE 12.12 The BigQuery user interface. Note that this is a beta version of the new interface; older versions will look different.
In this form you can enter a query in the Query Editor, such as a query about names and genders in the usa_1910_2013 table, as shown in Figure 12.13.
FIGURE 12.13 Example query with estimated amount of data scanned
Notice in the lower-right corner that BigQuery provides an estimate of how much data will be scanned. You can also use the command line to...
