December 2017
Beginner to intermediate
264 pages
5h 38m
English
Content preview from Learning Google BigQuery
Become 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
Execute query and copy results to a new table
The following method will execute the query and copy the results to the destination table. Set the allow_large_results flag to true if the data returned from the query will be more than 128 MB in compressed format. Specify the mode to insert the data into the destination table in the write_disposition flag. The SQL used in this method is Standard SQL dialect. Set the UseQueryCache flag to true to use the results of the query from cache to save money on billing:
Call this method in main method and pass the required parameters such as the new destination table name. Customize the method to be generic ...