Analytical – Honest – Passionate
The following command will create a gzipped (compressed) tar file (many files into one file) for a folder called “Downloads”. In other words all the files and folders in the …
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 code snippet showing how to trigger a DAG in Cloud Composer (managed Airflow) using the gcloud command line tool.
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 …
Use the bq command line tool to list the users who have access to a particular dataset in BigQuery
In case you haven’t heard, UV is a relatively new python package and project manager. UV allows for you to define package dependencies and the Python version to run the …
With the bq command line tool moving multiple tables at a time from one BigQuery dataset to another can be done with a few lines of code. The tool can …