Twitter Data Pipeline using Airflow for Beginners | Data Engineering Project

Поділитися
Вставка
  • Опубліковано 11 лип 2024
  • Join Course Python for Data Engineering - bit.ly/4140KI9
    This is End-To-End Data Engineering Project using Airflow and Python. In this project, we will extract data using Twitter API, use python to transform data, deploy the code on Airflow/EC2 and save the final result on Amazon S3
    Code and commands used in the project - github.com/darshilparmar/twit...
    Other resources:
    Twitter API - / twitter-api
    Python (Installation & Basics) - • Python Tutorial - Pyth...
    Setup AWS Account - • AWS Account Setup - St...
    Airflow Doc - airflow.apache.org/docs/
    Join Data With Darshil Discord Server: / discord
    Timestamps
    0:00 Project introduction
    0:56 Section 1 (Prerequisite)
    2:21 Section 2 (Understand basic concept)
    7:55 Section 3 (Project execution)
    👦🏻 My Linkedin - / darshil-parmar
    📷 Instagram - / darshilparmarr
    🎯Twitter - / parmardarshil07
    🌟 Please leave a LIKE ❤️ and SUBSCRIBE for more AMAZING content! 🌟
    3 Books You Should Read
    📈Principles: Life and Work: amzn.to/3HQJDyP
    👀Deep Work: amzn.to/3IParkk
    💼Rework: amzn.to/3HW981O
    Tech I use every day
    💻MacBook Pro M1: amzn.to/3CiFVwC
    📺LG 22 Inch Monitor: amzn.to/3zk0Dts
    🎥Sony ZV1: amzn.to/3hRpSMJ
    🎙Maono AU-A04: amzn.to/3Bnu53n
    ⽴Tripod Stand: amzn.to/3tA7hu7
    🔅Osaka Ring Light and Stand: amzn.to/3MtLAEG
    🎧Sony WH-1000XM4 Headphone: amzn.to/3sM4sXS
    🖱Zebronics Zeb-War Keyboard and Mouse: amzn.to/3zeF1yq
    💺CELLBELL C104 Office Chair: amzn.to/3IRpiL2
    👉Data Engineering Complete Roadmap: • Data Engineer Complete...
    👉Data Engineering Project Series: • Data Engineering Proje...
    👉Become Full-Time Freelancer: • Best Freelancer Series...
    👉Data With Darshil Podcast: • Podcast Series - Data ...
    ✨ Tags ✨
    data engineering project, complete data engineering project for beginners, learn data engineering, data engineering roadmap
    ✨ Hashtags ✨
    #airflow #dataengineering #project

КОМЕНТАРІ • 501

  • @DarshilParmar
    @DarshilParmar  Рік тому +99

    EDIT:
    Elon Musk ruined the API part, you can use some other APIs
    Here's one of the subscriber built the same project using other APIs - chenmeiqiao.notion.site/How-I-Reach-Out-to-UA-camrs-I-Like-As-A-Data-Engineer-c37bdddefde54c3789229ffa5a789432
    or you can use a static dataset from Kaggle and then use Airflow to process it
    www.kaggle.com/datasets/mmmarchetti/tweets-dataset
    FAQ:
    1. Twitter removed free access: It still has free access but with limits of requests you can make - developer.twitter.com/en/docs/twitter-api/getting-started/about-twitter-api
    2. You need to request for V2 access: You will get an error but just by reading the doc you should be able to access Elevated Access
    Worked very hard for this project🤞
    Don’t forget to hit the like button and if you want to support my work you can join channel membership, it's only 59rs per month so that I can keep these content for free

    • @mohammadtanvirhossain5576
      @mohammadtanvirhossain5576 Рік тому +1

      already did !!! appriciate your efforts brother !!

    • @akshunjain968
      @akshunjain968 Рік тому

      Hey! Are you using Elevated access level because Essential doesn't work with the code you are using

    • @nishantagarwal8016
      @nishantagarwal8016 Рік тому

      Amazing Darshil!! I was able to replicate the same in GCP

    • @DarshilParmar
      @DarshilParmar  Рік тому

      @@nishantagarwal8016 Awesome!
      Create linkedin post and tag me

    • @DarshilParmar
      @DarshilParmar  Рік тому

      @@Soulfulreader786 There is a free version also

  • @sumantaghosh9299
    @sumantaghosh9299 Рік тому +157

    this is what is called content and actual do something for community ..rather than just doing faltu things...thank u so much Darshil ❤️

  • @faramarzzrn
    @faramarzzrn Рік тому +1

    one of the best tutorials I've ever seen on UA-cam, a real-world example that was really interesting

  • @ThankGod143
    @ThankGod143 Рік тому

    I came here seeing your LinkedIn post with comments,Being a fresher I was struggling for a project. This is Absolutely what I was looking for. Just Awsome. Thank you so much for your time and efforts.

  • @venkatah9847
    @venkatah9847 Рік тому +14

    My sincere thanks to your efforts for contributing these kind of real time scenario based use case examples. 🙏

  • @ANKITKUMAR-nv8ur
    @ANKITKUMAR-nv8ur Рік тому +27

    In data engineering community you are the GEM. Thanks from the bottom of my heart Darshil. Keep growing keep inspiring.

  • @eternal2187
    @eternal2187 Рік тому +1

    You always continue to be great asset in data engineering content, thanks again!

  • @kanui3618
    @kanui3618 Рік тому

    this is awsome !
    can't wait for the next data engineering projects, darshil🔥
    greetings from indonesia

  • @AshisRaj
    @AshisRaj 6 місяців тому +3

    Mr. Darshil you have saved a lot of time for us by this video. This video has more content than others talkative videos of other youtubers. Thanku so much

  • @manuprakash1989
    @manuprakash1989 Рік тому

    Great! Got broader understanding of api, airflow and aws. Thank you!

  • @owennowakowski7558
    @owennowakowski7558 Рік тому +7

    This was a very helpful video for me. I have spent the last year learning web development, and I am expanding my skills to include ETL. This video gave me a great overview of the process.

  • @chandrakantsingh9568
    @chandrakantsingh9568 9 місяців тому

    Thanks for creating this project, with the help of this i schedule my data extraction task ,currently i am using solcast API to fetch weather data .

  • @raimanisha5197
    @raimanisha5197 Рік тому +1

    Hi Darshil, Thank you for this .It was a great learning experience and it was fun too ! 😛.I am eagerly waiting for more such videos on airflow

  • @gabrielfds3461
    @gabrielfds3461 Рік тому

    Darshil, amazing! I do not have words to say thank yoU!

  • @gomes8335
    @gomes8335 Рік тому +2

    Excellent job Darshil.

  • @TehWaver
    @TehWaver 5 місяців тому

    Hey Darshil, thank you so much for this. Of course I got errors but as you said in the beginning, those are part of the journey. Definitely going to follow other tutorials from you as well regarding Airflow and AWS!

  • @pearlr.2411
    @pearlr.2411 Рік тому

    Darshillllllll this is Gold. I literally love you rn 😭

  • @kanduladivya5804
    @kanduladivya5804 Рік тому +1

    This video is worth more than paid content on many websites.Thanks for such content.

  • @kirankv1956
    @kirankv1956 Рік тому

    Really love the content darshil.
    Very precise explanation.

  • @iamdare
    @iamdare Рік тому

    Good job mate. I thoroughly enjoy the video. Thank you.

  • @keyursolanki
    @keyursolanki Рік тому +1

    Love the way you have explained things. Loads of success to you😇

  • @hritikapal683
    @hritikapal683 Рік тому +2

    Hey thanks man I've been eagerly waiting for this. Would now explore and learn!

  • @mrcrblr850
    @mrcrblr850 9 місяців тому

    Amazing Video Darshil, i really appreciate your video, you are a great professor!! Thank you very much keep doing this great content!!

  • @rajivjani8594
    @rajivjani8594 Рік тому

    Awesome! Thanks for sharing it!

  • @shaikusman536
    @shaikusman536 Рік тому

    Awsome brother...Loved the way to teach...Hoping for detailed projects.....thanks a ton brother.....

  • @mehmetkaya4330
    @mehmetkaya4330 Рік тому

    Thank you for another great tutorial!!

  • @mikitaarabei
    @mikitaarabei Місяць тому

    Thanks for this content, Darshil :)

  • @karunakaranr2473
    @karunakaranr2473 Рік тому

    Thank you for your time and effort to make these videos. Really helpful.

  • @AmitSharma-mv5xe
    @AmitSharma-mv5xe Рік тому

    precise and clear content. Amazing

  • @jashanbansal2613
    @jashanbansal2613 Рік тому

    Great Video Darshil. Keep up the Good Work :)

  • @harshalrana1336
    @harshalrana1336 Рік тому +1

    This is really Amazing Darshil. I would also like to see Architecture level videos and how all tools all integrated into the cluster.

  • @kundan8618
    @kundan8618 Місяць тому

    This video is very helpful. Keep up the good work Darshil.

  • @aaosoto
    @aaosoto Рік тому

    Keep up the good work! Your project is the best. Greetings from Chile 😁

  • @SomeThinkingOFF
    @SomeThinkingOFF Рік тому

    clear and concise content!! Great!

  • @namvu607
    @namvu607 Рік тому

    Super practical, valuable tutorial. Thank you for sharing, sir.

  • @yhsreddy
    @yhsreddy 10 місяців тому

    Awesome demonstration, truly appreciated l, waiting to see lot more soon

  • @partabparmar5537
    @partabparmar5537 Рік тому

    THANK YOU SO MUCH FOR SUCHA QUALITY CONTENT ......GOD BLESS YOU

  • @mirirshadali33
    @mirirshadali33 Рік тому +4

    As usual very nice content and appreciate your effort. If you could make a video with OOPs approach and include some test cases that will be really great.

  • @bilalhassankhan221
    @bilalhassankhan221 9 місяців тому

    This is what exactly whay I'm looking for! Thanks brother.

  • @gopi10aug
    @gopi10aug Рік тому

    I really appreciate the effort and simplicity..! I was looking for actual content like this ... Thank you Darshil 😇

  • @shahriarentertainer4749
    @shahriarentertainer4749 Рік тому

    This is so impessive. Keep up your good work. I wish for a true success in your life

  • @abdulrazakshaik1128
    @abdulrazakshaik1128 Рік тому +4

    Really Appreciate your efforts to the Data Community you are doing a great job. Thank you ❤️

  • @anshujaiswal5622
    @anshujaiswal5622 2 місяці тому

    Really like your approach towards Learning Data Engineering concepts by doing project stuff. A good short smart project to learn basic working of a Data-pipeline using Python, AWS services and Beginner usage of Airflow. Thanks Darshil :)

  • @jitendraparihar56
    @jitendraparihar56 Рік тому

    Eagerly waiting for this project. Thank you darshil for such amazing projects...

  • @rolinejohnaguilar5272
    @rolinejohnaguilar5272 Рік тому

    cool man, just what I needed

  • @amirazad1762
    @amirazad1762 6 місяців тому

    Great and useful video. Thanks Darshil 🙏

  • @avshekraj
    @avshekraj 11 місяців тому

    Amazing...got to know something intresting. Thanks for the detail explanation.

  • @realsrvbhtngr
    @realsrvbhtngr Рік тому

    great content
    Thanks Darshil bhai, very cool

  • @lylabata6813
    @lylabata6813 Рік тому

    I have been following u for a long time now I don't even look at others videos......u r just great ....keep up the great work

  • @dhruvingandhi1114
    @dhruvingandhi1114 26 днів тому

    Great efforts!!!

  • @cheedellagupta1459
    @cheedellagupta1459 Рік тому

    Very clean and understandable 🎉

  • @ogissgi7441
    @ogissgi7441 Рік тому +2

    Thank you! thank you! thank you!

  • @santoshchavan1929
    @santoshchavan1929 Рік тому

    Awesome sir...... That's what I actually want...

  • @sohailhosseini2266
    @sohailhosseini2266 Рік тому

    Thanks for the video!

  • @ashishveer4591
    @ashishveer4591 Рік тому

    Perfect Explanation .. keep it up .. thank you 🙌

  • @Cosmos1987
    @Cosmos1987 Рік тому

    Now with the arrival of ChatGPT, even though one can generate CODE without analyzing all these, it is always better to understand the logic, nuance and intricacies of CODING. This vid helps a lot in deconstructing this step-by-step.👌

  • @marionagi2914
    @marionagi2914 Рік тому

    amazing as usual

  • @nomadicengineer22
    @nomadicengineer22 Рік тому +5

    Please keep on bringing content like this it will be really helpful for freshers who want to understand, gain knowledge and shape their career in Data engineering🙏.

  • @sujeetnair1748
    @sujeetnair1748 Рік тому

    i m elder than u.. but u r an inspiration bro... i m new to data engineering..

  • @africarising360
    @africarising360 Рік тому

    Your video was really helpful. Thank you very much

  • @user-zh9lh4hw1f
    @user-zh9lh4hw1f 8 місяців тому

    excellent, thanks for the content

  • @AjaySharma-jv6qn
    @AjaySharma-jv6qn Рік тому

    thanks for sharing info - A step by step guide

  • @abhijeetpradhan143
    @abhijeetpradhan143 Рік тому

    Best content ever..👍
    So nice of you..
    Really want more such Projects..

  • @mohsinrajpoot3780
    @mohsinrajpoot3780 9 місяців тому

    great work you helping lot of people.

  • @ini_affiah
    @ini_affiah Рік тому

    Thank you for the video. It was helpful.

  • @jeeteshkumartiwari7389
    @jeeteshkumartiwari7389 Рік тому

    Great tutorial, appreciate it, keep up the good work brother. :)

  • @gimmestonks5333
    @gimmestonks5333 Рік тому

    Thanks for teaching basics of air flow and Dags..

  • @maheshbhatm9998
    @maheshbhatm9998 Рік тому

    great video. Thank you

  • @apoorvpandkar
    @apoorvpandkar Рік тому

    Real content is finally here ❤ Loved the tutorial.

    • @rohitpandey9920
      @rohitpandey9920 Рік тому

      Bro I am unable to get access to Twitter API v2. Could you please help me out with that part?

  • @tassamoo
    @tassamoo Рік тому +2

    Thanks sir, I learn a lot following this project guide. I understand more about how to use tweepy, AWS services and airflow by following this tutorial. I hope you always have a nice day.

    • @DarshilParmar
      @DarshilParmar  Рік тому

      You are welcome, check out more projects available on channel

  • @avnishgupta1903
    @avnishgupta1903 Місяць тому

    Awesome Work !!!

  • @mayurb6088
    @mayurb6088 2 місяці тому

    Great work!

  • @shubhampatil-xx5qq
    @shubhampatil-xx5qq Рік тому

    Thank you soo much darshil sir❤

  • @karangupta_DE
    @karangupta_DE Рік тому

    this is perfect, thank you Darshil

  • @mangeshgawali7683
    @mangeshgawali7683 Рік тому

    Great explanation. Thanks, Darshil! 😊

  • @aoffyclub
    @aoffyclub Рік тому

    thank you for this project

  • @kunalberry5776
    @kunalberry5776 Рік тому

    thanks, very helpful video

  • @PrincessNaveena
    @PrincessNaveena Рік тому +3

    Wowww., Wonderful explanation.., never before ever after...
    True master for Big Data ,🙂Darshil

  • @aaravkumarsingh4018
    @aaravkumarsingh4018 Рік тому +3

    Thanku darshil for making this project, please make this type of project on regular basis so that it will help us to enhance our skill

  • @dele_data
    @dele_data Рік тому

    I find it worthy to join a youtube channel membership for the first time. I hope with smart and harwork from myself and your help, I am able to land a Data Engineering job soon.

    • @rohitpandey9920
      @rohitpandey9920 Рік тому

      Bro I am unable to get access to Twitter API v2. Could you please help me out with that part?

  • @user-yd6bq3kr3g
    @user-yd6bq3kr3g Рік тому

    Mentor of many data engineer ❤

  • @payday_1150
    @payday_1150 Рік тому +2

    Please keep making more videos like this!

  • @may_win
    @may_win 9 місяців тому

    good video, very detailed

  • @manisha4130
    @manisha4130 Рік тому

    Very informative👍

  • @hrsh3329
    @hrsh3329 Рік тому

    Thanks for sharing this

  • @barutistudio1397
    @barutistudio1397 Рік тому

    Thanks for this content

  • @pradeepdhanola1327
    @pradeepdhanola1327 Рік тому

    You are best bhai ❤️

  • @tejasborkar5917
    @tejasborkar5917 Рік тому

    Great darshil this is really helpful video
    Thank you.. keep uploading content like this please

  • @aritra1414
    @aritra1414 Рік тому +8

    Please take out time and create deeper conceptual projects like this. If possible please provide real time scenario based projects. We will be really interested to get further depth. This one is awesome!!

  • @arnavroy5663
    @arnavroy5663 Рік тому

    Very knowledgeable

  • @abegpatel5300
    @abegpatel5300 Рік тому +1

    Thank you👍 for the awesome content We want more data engineering real world end to end project with real time streaming to deal with real world problem and situation.

  • @mesumrazahemani3163
    @mesumrazahemani3163 Рік тому

    Very good! Make more of such videos.

  • @Bhagwata_shlok
    @Bhagwata_shlok Рік тому

    Thanks a lot ❤️

  • @turquoisetravels
    @turquoisetravels Рік тому +1

    Great videos, Darshil! Also a side note, I often watch UA-cam videos at 1.5. Yours feel faster even at a normal pace. :)

    • @DarshilParmar
      @DarshilParmar  Рік тому +1

      My natural talking pace is faster, many people complained about it but I can’t help it

  • @shreyagrawal3806
    @shreyagrawal3806 Рік тому

    thank you very much😀

  • @aishmash5325
    @aishmash5325 Рік тому

    Thank you so much 😇❤

  • @aarthi1163
    @aarthi1163 Рік тому

    Thanks you... Waiting for this

  • @ABDA-zk5sm
    @ABDA-zk5sm Рік тому +2

    Thank you for the great content!
    I just have a question. I'm trying to run Airflow locally on my machine by using Ubuntu to extract tweets from Twitter with Twint library and load it to BigQuery. However, when I copied the dag scripts and the ETL scripts to Airflow folders in Ubuntu and try to load the dag it seems like it fails because Airflow doesn't have access to packages and modules installed locally (e.g. Twint). What do you recommend in this case?

  • @reypaulobae4895
    @reypaulobae4895 Рік тому

    Thank you so much! I encountered some issues along the way, but was able to resolve them!

    • @rohitpandey9920
      @rohitpandey9920 Рік тому

      Bro I am unable to get access to Twitter API v2. Could you please help me out with that part?

    • @reypaulobae4895
      @reypaulobae4895 Рік тому

      @@rohitpandey9920 Yeah, just delete the default and create a new one. Worked after

  • @PinkuKumar-ro8bw
    @PinkuKumar-ro8bw Рік тому

    Thank you so much