I need to calculate a running total but need to reset the total on a condition (when expected reached = 0 and product_group and product changes). Got help here without the two extra fields: Calculate a running total with a condition in BigQuery I have this table and may use product_group and product as integers or strings as below. Any
Tag: google-cloud-platform
How to remove Repeated field in BigQuery schema?
I have a schema that has a repeated field nested into another repeated field like so: person.children.toys. I want to make this inner field not repeated (so child can have only single nullable toy). I …
Trouble deploying Laravel Passport with Google App Engine (GAE)
I have successfully deployed and maintained a Google App Engine + Laravel Project using Google Cloud SQL as a database. I’m using Cloud Build to deploy, however on manual deployment my problem occurs just the same. I’m trying to get the locally working Laravel Passport installation to work on Google App Engine. Laravel Passport needs to run php artisan passport:install
How to drop multiple tables in Big query using Wildcards TABLE_DATE_RANGE()?
I was looking at the documentation but I haven’t found the way to Drop multiple tables using wild cards. I was trying to do something like this but it doesn’t work: Answer I just used python to loop this and solve it using Graham example: