Database Reference
In-Depth Information
You can do this by running a query command that sets the
dryRun flag
to
true
in the query configuration, which tells BigQuery to not actually run
the query.
>>>
service.jobs().query(
…
projectId=project_id
,
…
body={'query': query, 'dryRun': True}
…
).execute()['totalBytesProcessed']
u'552786'
The same options for determining query cost are also available in the UI. If
you click the green query validation icon under the query, you can see how
many bytes would be processed if you ran the query. Likewise, after you run
the query, it tells you how many bytes were processed when the query was
run.
Figure 7.1
shows both of these indicators.
Figure 7.1
Query byte estimation
