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.
When creating or building a BigQuery Machine Learning model, the model itself is stored inside a BigQuery dataset. The code snippet below shows how to move a model from one …
A simple tool to create dates in a date range at the terminal. Each date in the date range is printed to the screen allowing for redirection or incorporation into …
A code snippet showing how to trigger a DAG in Cloud Composer (managed Airflow) using the gcloud command line tool.
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 …
Different approaches to load data into a SQLite database using the following Python libraries: Pandas Using the pandas library (alongside click, and uv) to load a csv file into a …
Working with data involves handling a lot of data files, most commonly CSV files. It can be very helpful to do some exploratory data analysis on the CSV file to …
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.