Analytical – Honest – Passionate
In a previous post we used sweetviz to make a summary of a csv file, and ydata profiling to compare 2 different csv files. Well Sweetviz can also be used …
When using SQLfluff to format sql files it is possible to set certain formatting rules that should be followed when formatting the the files. These rules can be specified in …
SQL is a very flexible language when it comes to formatting. As long as the commands and syntax are in the right order then the SQL query will work. Whitespace …
Below is a python script that uses the ydata-profiling library to create a report that compares two csv files. This is proving useful in verifying the similarity between original and …
A collection of YouTube videos I have found useful in learning about hooks in Git. In no particular order:
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 …
A short python script that uses the Sendgrid API to send a basic email.
I came across this great tool today called gitleaks. This tool will search through directories and git repos (all locally) to see if it can find any secrets, API keys, …
If a particular user has been added read access to a table these permissions can be removed using the REVOKE keyword in SQL:
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 …