many steps, save tables : the cost of the storage is not expensive, so don’t hesitate to split the complexity of a query into many steps instead of writting a complicated query.
window functions : window functions are present in BigQuery. It’s very interesting in this kind of database especially if you want the last occurrence of a row. https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#window-clause
User Defined Functions (UDF) : User defined functions allow to BigQuery to execute javascript code. The restrictions are big, number of UDF launched in the same project in the same time. Query are longer and you may have a timeout. Try to avoid it if you can.
Explanation Plan and query information : you have tabs just above the result grid and you can see where BigQuery spent the time to display the result of your query and you can see the number of bytes billed for the execution of the query.
Saved queries : you can save queries for you or for the project. could be interesting when you are working on a complex query
The best way to get IT support is to use the new
Service One Platform.