Creating Your First Airflow DAG for External Python Scripts

I show how to start automatically triggering or scheduling external python scripts using Apache Airflow. Here are the steps:
Clone repo at github.com/vastevenson/vs-air...
Make sure that pip is fully upgraded prior to proceeding
Run command: pip install apache-airflow (note this will install the most recent, stable version of Airflow, no need to specify exact version or constraints)
Install Docker and Docker Compose
Run command docker-compose up -d from the directory with the Dockerfile exists
Confirm that you can hit localhost:8080 with a GET request, should see Airflow UI
You can also monitor the logs of the Airflow environment as follows: docker-compose logs
You can stop the Airflow environment as follows: docker-compose down
Note: referencing external Python scripts can only be done from the directory where you’ve configured Airflow to look for dags.

[@ruthlove7813]

I discovered your channel yesterday and i liked how your videos are short, organized, and cover most needed topics for Che Eng. Hope you will do videos on matlab, relating MATLAB with process control, and Che Eng process design. Thank you & looking forward to watching more videos.

[@krystianopala4299]

Simple, yet explanatory example. Thank you:)

[@ep23a4]

Amazing thank u so much for the easy explanation and for the repo!

[@vittaquant]

Amazing , that works perfectly, thanks.

[@hayathbasha4519]

Hi is it possible to get task/dag duration from context

[@jasonli1420]

Thanks a lot. Can you explain: - ./airflow-data/includes:/opt/airflow/includes

[@brendoaraujo9110]

instead of calling the script function, is there an operator that I can call the script completely to be executed?

[@algoJamming]

I am getting "modulenotfounderror" in DAG import errors. Can you please help me with this ?

[@Matias-eh2pn]

Nice video! Thanks!

[@tg8799]

Too many issues with this.
The external python file simply isn't being recognised by the python_callable function.

[@javiercasanuevamartos9997]

Hi! thanks for the video :) One question...how can we deal with the scenario where the external python script is using a package that is not installed in the Airflow environment? It will raise an error "'X' module is not found" in the Airflow UI, isn't?

[@samyrhelou2580]

i'd also like to know this!!

[@manoj-ul9vc]

Did you fix this issue.... Pls let me know

[@henrikpohlmann8394]

I am running into errors that say " NameError: name '_mysql' is not defined" when attempting to run docker-compose up. Do you know what the issue is here?

[@MiShell103]

I am getting this error too, did you ever figure it out?

[@saurabhruikar1131]

How to import files or modules which are located out of the root project directories somewhere in PC?

[@vishwasrchonu7134]

How is it that your editor has allowed you to strike off an import name and re-write a new one? What feature is this? Are there any alternates to this?

[@zahraelhaddi6980]

please the pip install apache-airflow command does not work, could you tell us how you've done it

[@ammadkhan4687]

Hi Vincent, nice video. I am wondering if you could also make a Demo for external Docker connectivity. For example I create a job and it runs other dockers microservices. This will help to unload the server itself and putting the calculation work on other microservices. I hope you understand what I am trying to say here.

[@yilu435]

why my DAG always in the queue

[@dmrirdmriririr]

for those who suffering from name ‘_mysql’ is not defined error... here's how i solve this.
- Make sure you following the instructions that he gave.
pip install -upgrade pip
pip install apache-airflow
- Check your docker-compose version is 1.29.1
- Revise image, context, PYTHON_DEPS section in docker-compose.yml file.
image: puckel/docker-airflow:1.10.9
context: {puckel/docker-airflow.git url}#1.10.9
(my comment is deleted bc of the this url.. change 1.10.1 to .9)
PYTHON_DEPS: sqlalchemy==1.3.0 markupsafe==2.0.1 wtforms==2.2

[@srishtiganguly6000]

Thank you for sharing the solution. I was looking on StackOverflow and did not find a solution. The steps you mentioned worked and saved my day :)

[@user-rs2ox7rm8f]

Thank you!

[@aqibfayyaz1619]

thank you

[@jorgealejandrorodriguez1941]

Thanks !!

[@oluwatobitobias]

Emphasis was to educate us on how to run external scripts...you did less than a minute on that...options like using bashoperator "bash_command" would have been nice.