Posts

Showing posts from April, 2016

Front-end Google Cloud Products With a Google Apps Script Application - Part 1

Image
_________________________ In an earlier article , I showed how to front-end Google BigQuery with a Google Docs Spreadsheet / Google Apps Script application. Later articles generalized the engineering: this article  described a Google Cloud SQL front-end application and  this article  explained how to integrate BigQuery and Cloud SQL to build BigQuery stored procedure functionality. This engineering works well enough, but it has some drawbacks: First, it offers no way to save a result set as a finished file. Second, it offers no way to print a result set. Third, the sample applications rely on a container‑based architecture - in other words, the application script files are bound to a Google Sheets file as components of that file. This article describes a sample Google Apps Script application that front-ends a BigQuery project. However, the application also offers file save and print features. Additionally, while its engineering relies on Google Sheets, it br...