Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days Airflow Amazon Web Services AWS Azure Batch CAP Coders At Work cron Data Databases Data Warehouse Django Edsger W. Dijkstra Excel Git Google Hadoop Hellerstein Hive Javascript Knowledge Transfer MVC Network Address Translation Networking Notes on Structured programming PHP Power Bi Powershell Public Subnet Python Redash Social Skills Software Developer Spark Spark: The Definitive Guide SQL SSH SurrogateKeys Testing The Elements of Programming Style Traversy Media Understanding Distributed Systems whale-alert Yaml

Archives

Category: Others

Resolving ‘index.lock’ Issue in Git

When working with Git, you may encounter an error preventing you from switching branches or performing other operations. A common issue is the following: This typically happens when another Git process is running or if a previous operation was interrupted, leaving a stale index.lock file. How to Fix the ‘index.lock’ Error 1. Check for Running
Read More

How to Rename a Git Branch Locally and Remotely

Renaming Git branches can be necessary when adhering to naming conventions or correcting errors. This guide will walk you through the process of renaming a branch locally and remotely. Scenario: You accidentally pushed a branch named old-branch-name to the remote repository but realize it should follow the convention feature/new-branch-name. Steps to Rename the Branch 1.
Read More

Route Summarization and Subnetting

We will walk through the process of subnetting a network and performing route summarization using an example. Subnetting Example Let’s consider the following four subnets: Binary Representation To better understand these subnets, let’s convert the IP addresses to their binary form: Common Bits With a subnet mask of /22, we need to consider the first
Read More

SODA: SSL: CERTIFICATE_VERIFY_FAILED – Solved

When you tried to connect to soda it is possible you find this error: SSL: CERTIFICATE_VERIFY_FAILED. All the message look like similar to this one: This happens because there is a conflict between the permissions your machine have to connect to other places in the network and the usage statistics that SODA does. In fact,
Read More

SODA: Connect SQL Server without Password

When you do your first steps using soda, it is possible you want to connect to an SQL Server database. In that case you can create an specific user and give him the proper rights I wrote about that in the following post: Connect Soda to SQL Server. But, Is it possible to use the
Read More

SODA: Check count distinct elements

Categories in Data Quality When you are doing a quality you’re looking for six levels of knowledge about it. It might change depends on your requirements and what is the usage about it. Because, in general speaking the that not always work in a synchronous way, it’s possible that it could be from outside your
Read More

SODA: Connect to SQL Server

After deciding to install SODA to make your quality check you have to connect the data source to SODA. We are going to see how to connect soda to Microsoft SQL Server. Remember that this is a tutorial in order to use, in an easy way the SODA quality check tool on your machine .
Read More

ASTRONOMER: Install on Windows

Install Astronomer is quite simple In windows you have to follow the following steps: 1 – Install docker Go to the docker’s webpage, download the executable and install it. Installation succeeded 2 – Install Linux on Windows with WSL As you can see on the Microsoft documentation you have to run on PowerShell the following
Read More