Analytical – Honest – Passionate
If a particular user has been added read access to a table these permissions can be removed using the REVOKE keyword in SQL:
A code snippet to add a user as read only on a BigQuery table. To add different permissions, other BigQuery roles can be seen in the Google documentation.
A collection of video resources to on using and understanding SQLite. SQLite case study SQLite with Python SQLite for beginners …although some of the topics don’t seem like beginner topics …
In BigQuery when running a query, the costs associated with doing so include a “scan” of the data that may be processed as part of executing the query. For example, …
A code sample to create a random forest machine learning model in BigQuery and make predictions all using SQL.
A short code example which loads a csv file from Google Cloud Storage into a table using SQL.
For those interested in the field of Digital Analytics I have put together this project based curriculum to take someone from “digital analytics curious” to having the technical skill set …
In this part of the series we will walkthrough how to set up a query to run at a regular interval using Python and Cloud Functions. This is useful particularly …
For a little while now I have been using a personal health tracking tool to monitor my progress in various areas such as strength exercises, weight management and mental hygiene …