Every few months, someone discovers the Google Sheets QUERY function and has the same reaction: why did nobody tell me about this? Here is what it does and why it changes how you work with data.

After previously bridging the gap between Sheets and BigQuery - its service for interactive analysis of big datasets -, Google has now announced the ability to refresh BigQuery data by using either ...