Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days #DjangoDevToDeployment Airflow Amazon S3 Amazon Web Services AWS bash bastion host Batch code Coders At Work Computer Science Data Databases Databricks Data Intensive Applications data lakes Dijkstra Edsger W. Dijkstra faker Google Colab Hellerstein Jinja Knowledge Transfer Leadership Models of Computer Programming Networking Networks Protocols Python Redash Seweetviz Social Skills SODA Software Developer Spark: The Definitive Guide SQL SSH Testing The humble programmer Traversy Media Ubuntu Understanding Distributed Systems Virtual Box Web Development whale-alert

Archives

Category: Frameworks

Overview and opinions about different kind of frameworks

Run Redash Locally

This is only for educative purpose. You don’t have to do this in production 1 – Clone the project from the oficial github: Redash on GitHub – Y made a fork previously. Take Care 2 – Modifiy the compose 3 – Create the env in the opt/redash 4 – Run Docker 5 – Create database
Read More

Sellenium Vs Beautiful Soup

Web scraping is a widely recognized strategy for acquiring information. Before diving into this process, it’s crucial to familiarize oneself with two essential tools. Personally, this topic initially posed a significant challenge for me when attempting to extract data from the web. These tools serve distinct purposes in web scraping and automation. Selenium is primarily
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

TOX: First steps

Tox is a tool for Python testing. I’m doing my first steps because I found it in the project: Faker, which is: Faker is a Python package that generates fake data for you.  Faker Git Hub repository If you want an interesting video explanation about that you can see anthony explains #043 You can install it
Read More