Build Google BigQuery "Stored Procedures" With Google Cloud SQL - Part 2
______________________
Part one described the Google Cloud SQL database the sample application uses for the BigQuery "stored procedure" technique.
Part two here will briefly describe important details about the BigQuery project behind the solution.
Part three has an overview of the Google Apps Script solution engineering.
Part four will explain the JavaScript objects behind the Google Apps Script solution.
Download the five Google Apps Script component files and scripts for the MySQL stored procedure and the MySQL user-defined function from the GitHub repository.
________________
The solution described in this specific article will use the BigQuery project described in this earlier article. For the solution here, name the BigQuery project
BigQuerySPDemoAppDS
and create one table called
zbp11totals
in it. Load it with data from zip file "Complete ZIP Code Totals File" from the U.S. Census Bureau. The earlier article has more details about how to do all this, but remember to name this BigQuery project here "BigQuerySPDemoAppDS".
_______________
Part two here briefly described important details about the BigQuery project behind the solution. Part three will give an overview of the Google Apps Script solution engineering.
Part one described the Google Cloud SQL database the sample application uses for the BigQuery "stored procedure" technique.
Part two here will briefly describe important details about the BigQuery project behind the solution.
Part three has an overview of the Google Apps Script solution engineering.
Part four will explain the JavaScript objects behind the Google Apps Script solution.
Download the five Google Apps Script component files and scripts for the MySQL stored procedure and the MySQL user-defined function from the GitHub repository.
________________
The solution described in this specific article will use the BigQuery project described in this earlier article. For the solution here, name the BigQuery project
BigQuerySPDemoAppDS
and create one table called
zbp11totals
in it. Load it with data from zip file "Complete ZIP Code Totals File" from the U.S. Census Bureau. The earlier article has more details about how to do all this, but remember to name this BigQuery project here "BigQuerySPDemoAppDS".
_______________
Part two here briefly described important details about the BigQuery project behind the solution. Part three will give an overview of the Google Apps Script solution engineering.