Types of queries

Google offers two different types of queries. Interactive queries are BigQuery's most costly queries and will run as soon as possible when initiated. Users using Google's on-demand pricing will be subject to Google's concurrent query limits. These users can run 50 concurrent interactive queries and users can run 6 concurrent queries containing user-defined functions.
Batch queries are less costly and do not count against concurrent query limits. These queries are run when resources are available; therefore, these queries might not run as soon as possible when initiated. If a query does not run within 24 hours, its priority is set to interactive.

User-defined functions can be developed in both JavaScript and SQL. They are covered in detail in Chapter 5, BigQuery SQL Advanced.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.133.124.21