Google BigQuery goes real-time with streaming inserts, time-based queries, and more

Google BigQuery has introduced several updates enhancing its real-time data processing capabilities, including the new tabledata().insertAll() endpoint, which allows immediate data loading and analysis, benefiting time-sensitive applications like log analysis and alert generation. This feature, free until January 1, 2014, will later be billed at a nominal rate, while the traditional jobs().insert() method remains free for bulk data loading. Additionally, BigQuery now supports "table decorators" for querying specific data subsets from the last 24 hours, reducing costs associated with full column scans. Furthermore, new statistical functions such as COVAR_POP(), COVAR_SAMP(), and others have been added, alongside improved query history retrieval in the browser tool. These updates aim to enhance user experience and analytical capabilities, encouraging feedback and discussion via Google Cloud Platform’s social channels.