Category Data Science

Guide to setup Airflow step by step

Follow the below steps to set up the airflow from scratch without Docker. 1. python3 -m venv venv 2. source venv/bin/activate 3. Setup the airflow home path export AIRFLOW_HOME=/Users/piyush/workspace/airflow_demo_atrium 4. Setup Postgres database, first create one database and then change… Continue Reading →

All about Data Version Control (DVC)

What is Data Version Control (DVC)? Keeping track of all the production-level system data used for building models and experiments needs some kind of versioning. A single source of truth, but maintaining it takes a lot of time, you need… Continue Reading →

How to land into IT company and get a Software Engineer job

If you are here it means you have an interest in computer science or want to land in an IT company. If you have done your education in computer science then this journey might be easy for you but if… Continue Reading →

Steps to migrate data from MS SQL to MySQL using MySQL workbench

If you are most comfortable in the MySQL database but some of your data is in the MS SQL (Microsoft SQL Server) then you need to migrate the MS SQL database to the MySQL database. Fortunately, we have a MySQL… Continue Reading →

Error (‘01000’, [01000] [unixODBC][Driver Manager]Can’t open lib ‘ODBC Driver 17 for SQL Server’ : file not found (0) (SQLDriverConnect)) in Mac

If you get the Error (‘01000’, [01000] [unixODBC][Driver Manager]Can’t open lib ‘ODBC Driver 17 for SQL Server’ : file not found (0) (SQLDriverConnect)) in Mac then run the below command to fix the issue. brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew update… Continue Reading →

Data Preprocessing Steps in python

Whenever you are doing some preprocessing of data in pandas/python and reading data from any CSV file do the following things first. Trim space in all the columns. Convert each column in the right datatype. Contd.

How to set a variable in airflow admin UI and use it in DAG

Sometimes, we need a way to configure the variables from the admin UI of airflow so that we can change the value of that variable whenever required. Instead of digging into code and modify it and then deploy and test…. Continue Reading →

Set up or update base URL in airflow

The default base URL of airflow is http://localhost:8080 and because of this, you may get an issue that log files URL is still showing localhost and you have to remove localhost and replace it with your actual domain on which… Continue Reading →

How to trigger an email from airflow on failure or success of DAG

If you are using airflow in your production environment then you must have come across a requirement to trigger an email if any Dag fails so that you will be notified and fix the issue in the flow. We will… Continue Reading →

« Older posts

© 2024 My Beliefs

Write us at [email protected]