Тёмный

COVID 19 - Build End to End Data Engineering Project | PART 1 

Darshil Parmar
Подписаться 154 тыс.
Просмотров 67 тыс.
50% 1

Опубликовано:

 

3 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 111   
@DarshilParmar
@DarshilParmar 2 года назад
Don't forget to like it, it will help this channel to grow :D
@thuongleac3907
@thuongleac3907 2 года назад
Can you demo for hadoop??
@satishreddy7603
@satishreddy7603 2 года назад
awesome much Needed Darshil
@grandhisandeep007
@grandhisandeep007 Год назад
Can u plz share ur GitHub repository for this dharshil….very crispy and clear explanation…. Thanks
@ogissgi7441
@ogissgi7441 Год назад
I am amazed how clearly you explaining these things and how much work you put into these free video. Cannot thank you enough for this quality content! please do not stop, the work you do and talent you have are incredible!
@shubhamsengupta5693
@shubhamsengupta5693 2 года назад
Hi Darshil, i am currently working as a data engineer in an MNC and I find your projects amazing. This Gives us a handson to get a clear objective about the things and for practice for my portfolio.
@DarshilParmar
@DarshilParmar 2 года назад
Thank you Shubham
@ANKITKUMAR-nv8ur
@ANKITKUMAR-nv8ur 2 года назад
Hi Shubham, can we connect over whts app. I am also a DE aspirations.Currently working as ETL developer with one year if experience.
@newagegenre
@newagegenre Месяц назад
Thank you so much, You make every concept very easy to understand! Will be back when I get a major role in Data Engineering!!
@DarshilParmar
@DarshilParmar Месяц назад
Best of luck!
@karangupta_DE
@karangupta_DE 2 года назад
this was amazing Darshil, as a cloud enthusiast {i have most. of my experience on premise}, it was a perfect end to end data project, please create more such videos, it was a great learning and will add value to everyone's resume
@DarshilParmar
@DarshilParmar 2 года назад
I am glad that you liked it, just heads up these projects are for learning and to show how things work in real world, I do not recommend adding this project in your resume, you can take learning and apply learning into some different problem and then add it, that will hold more value. because everyone is going to add this project after watching my video so try to stand out
@akashbaptist3535
@akashbaptist3535 2 года назад
Hi Darshil! I somehow stumbled on your video, and I'm literally amazed by the way you are explaining things.You literally showed me the usecases of the services. Please bring more such end to end projects, as we don't really have such things on RU-vid.
@kingsleyelijah8461
@kingsleyelijah8461 2 года назад
Thank you so much Darshil for these videos you made, you are my mentor so far on this data engineering journey. God bless you bro ... keep the good job going. Because as a DevOps engineer and AWS SAA certified I know the energy it takes to build a single project...... Thank you once more.
@karangupta_DE
@karangupta_DE 2 года назад
Darshil bro, you are amazing, keep on creating more end to end data projects on cloud, amazing series.
@DarshilParmar
@DarshilParmar 2 года назад
Thank you, I will do my best
@smrutiranjannayak9449
@smrutiranjannayak9449 Год назад
its very helpfull DARSHIL.YOU are a HERO for us
@rohetoric
@rohetoric 9 месяцев назад
Good audio selection..it is from The Social Network..recognized it :)
@shashankagrahari
@shashankagrahari Год назад
this was very good and you are doing incredible job bhai Thanks for this video
@creator025
@creator025 2 года назад
Can you do more projects like this , since these give more hands on knowledge
@DarshilParmar
@DarshilParmar 2 года назад
I have been doing these things from so long, check out playlist. I first make small videos on fundamentals and then combine everything in one video
@BhupendraPatil-jh6ox
@BhupendraPatil-jh6ox Год назад
Dear Darshil your videos is good b ..Thanks u and keep it up
@snehalkumbhalkar7243
@snehalkumbhalkar7243 2 года назад
Add some project based on Google cloud platform. I will really help the fresher's data engineer to understand different cloud.
@DarshilParmar
@DarshilParmar 2 года назад
You can replicate same thing on AWS but I'll see in future what I can do on this
@sosso1078
@sosso1078 2 года назад
Thank you so much Mr Darshil.I really appreciate
@DarshilParmar
@DarshilParmar 2 года назад
You are most welcome
@hdr-tech4350
@hdr-tech4350 Год назад
Tables>3dots>generate Table DDL> Copy create table syntax athena_jhud>preview table same for other files
@amatacz
@amatacz Год назад
Thank you for your amazing work! :)
@2007selvam
@2007selvam Год назад
really very good work Darshil.
@chandraduggineni5932
@chandraduggineni5932 2 года назад
Good content, Subscribed. Looking forward for more hands on content.
@DarshilParmar
@DarshilParmar 2 года назад
Welcome aboard!
@ishaangupta4941
@ishaangupta4941 9 месяцев назад
Hi Darshil I dont see the aws DE playlist anymore, Please mput it back and don't monetise from it :( . It will really help us
@TusharSingh-of3vj
@TusharSingh-of3vj 2 года назад
Please Make more videos on Project we really loved this video
@DarshilParmar
@DarshilParmar 2 года назад
Sure
@niranjanjamkhande3773
@niranjanjamkhande3773 2 года назад
Thanks a lot for this. Can you please guide how to crawl nested json file to make catalogue out of it. Thanks.
@DarshilParmar
@DarshilParmar 2 года назад
There are many ways but one easy way is unnest it using python pandas and then crawl it
@snehalr4312
@snehalr4312 2 года назад
Really very helpful no doubt.. thanks
@DarshilParmar
@DarshilParmar 2 года назад
Glad it was helpful!
@AdityaVerma-uh5cj
@AdityaVerma-uh5cj Год назад
verry helpful ... thanks alott
@shobitgoyal385
@shobitgoyal385 Год назад
Hi Darshil, Your content is really very amazing and easy to understand. I am gaining great knowledge by watching your videos. But I am stuck with a problem and I can't find any proper solution anywhere online. While creating the crawler I attached proper policy and everything as told but in the end its throwing an error as: "One crawler failed to create The following crawler failed to create: "glue-enigma-jhud" Here is the most recent error message: Account ..................... is denied access." Please help me out with this issue. Thank You!
@DataJourney-di4wq
@DataJourney-di4wq 15 дней назад
Same with me
@richeshjena9389
@richeshjena9389 Год назад
Thank you
@akhilchitta8946
@akhilchitta8946 6 месяцев назад
Its perfect
@andreshernandocerquerameji2148
thank you
@krishj8011
@krishj8011 2 года назад
great tutorial.
@DarshilParmar
@DarshilParmar 2 года назад
Thank you! You can also watch entire series and other videos to learn more
@MohamedEssam-wc7cd
@MohamedEssam-wc7cd Год назад
All it free in aws
@MohamedEssam-wc7cd
@MohamedEssam-wc7cd Год назад
All it free in aws
@patrickbateman7665
@patrickbateman7665 2 года назад
waiting for the part-2 ☺️
@DarshilParmar
@DarshilParmar 2 года назад
Both part 2 and part 3 are already available
@flutterthangs
@flutterthangs 2 года назад
@@DarshilParmar I cannot see the part 2 and part 3. Could you please link those into the description?
@sapakunda1261
@sapakunda1261 2 года назад
Hey,Thanks for the project it gave me basic understanding. Can you please help me out the same for resume implementation
@prudhvilanka
@prudhvilanka Год назад
Hi Darshil, I really love your content and i'm into data engineering too. could you suggest me which laptop is the best for Data Engineering.
@DarshilParmar
@DarshilParmar Год назад
Any laptop is good enough as long as it has basic config such as 8-16GB ram, SDD 500GB, latest processor Most of the time you will be using Cloud Platform to do your work so your laptop config does not matter that much www.linkedin.com/posts/darshil-parmar_datascience-dataengineering-cloudcomputing-activity-6949973068303720448-OgF2?
@hamidoshaat
@hamidoshaat Год назад
Are you doing paid lessons for individuals or groups to learn data Engineering? I'm lost and don't know how to start.. i have tried to search for online courses but i couldn't find something i can learn what i want to learn ..
@MDARUN-ph1dw
@MDARUN-ph1dw 2 года назад
Keep doing some projects:)
@DarshilParmar
@DarshilParmar 2 года назад
Sure, thank you :)
@pulkitdikshit9474
@pulkitdikshit9474 Год назад
can we use redshift serverless here instead of redshift cluster? Please suggest
@DarshilParmar
@DarshilParmar Год назад
Yes
@VIMALANS-x5z
@VIMALANS-x5z 8 месяцев назад
Interested in connecting with you regarding the project.
@surbhivishwakarmavishwakar9265
@surbhivishwakarmavishwakar9265 8 месяцев назад
Hi Darshil , I have been getting an error while executing the querry on athena "The S3 location provided to save your query results is invalid. Please check your S3 location is correct and is in the same region and try again. If you continue to see the issue, contact customer support for further assistance." I have even checked the region specified for all my bucket but the error still persist. can you help?
@harshad3767
@harshad3767 2 года назад
Bro stonk markit mai bada karna hai profit bhai market data analysis kase karte hai batav zara
@DarshilParmar
@DarshilParmar 2 года назад
Stock Market ka knowledge nai hai itna par i'll see
@saaddar
@saaddar 5 месяцев назад
can i use aws s3 free in start ?
@pawankesharwani7831
@pawankesharwani7831 2 года назад
Hey Darshil, Trying to generate DDL from Athena database tables but getting below error ErrorCategory:USER_ERROR, ErrorCode:UNKNOWN_ERROR This query ran against the "covid-19_db" database, unless qualified by the query can you please help to resolve this
@renzcarillo7277
@renzcarillo7277 2 года назад
Athena couldnt query the hospital_beds table, the geojson file
@kennethlaw2528
@kennethlaw2528 2 года назад
Hi, I have faced the same problem. Do you get any solution
@renzcarillo7277
@renzcarillo7277 2 года назад
@@kennethlaw2528 Nope, google is no help either, im waiting for the youtuber's response
@DarshilParmar
@DarshilParmar 2 года назад
Hey @Kenneth Law and @Renz Carillo, we have a discord channel where you can ask your doubts and share issues, it's difficult to debug things on RU-vid comments so you can join the discord and ask your doubts
@lylabata6813
@lylabata6813 2 года назад
where is the discord link of this channel
@PranayData
@PranayData 8 месяцев назад
@@kennethlaw2528 I am facing the same issue, were you able to solve the problem. If so please let me know how you solved it.
@rayees_thurkki
@rayees_thurkki Год назад
@Darshil Parmar is it possible We can become a Data Engineer after follow your videos? I have don't have enough money to spend for to learn Data Engineer course from outside, please advise Bro
@DarshilParmar
@DarshilParmar Год назад
Yes, you can learn most of the things for free on my channel also I have added Data engineering roadmap for youtube - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5CA8LenDMig.html
@vamshikrishna6492
@vamshikrishna6492 Год назад
I am getting an error -- "An error occurred (403) when calling the HeadObject operation: Forbidden". Can someone help me with this
@shashibhushansingh1628
@shashibhushansingh1628 2 года назад
Can you suggest me how can implement this project in azure
@sarveshamrute4982
@sarveshamrute4982 2 года назад
Can I do this project on AWS without getting charged?
@DarshilParmar
@DarshilParmar 2 года назад
Yes, AWS provides 12 Month free trial and you can set billing alarm also if you get charged, check out my previous vides I have talked about this
@vemedia5850
@vemedia5850 9 месяцев назад
Can anyone follow along with this project using free services from AWS or is there payment needed?
@sukanyasahu1216
@sukanyasahu1216 Год назад
@DarshilParmar hy darshil, I'm using windows pc and I'm not able to preview data in table.Can you explain why? crawler works fine im able to create 10 table but there is no data in tables. I have checked my csv files they contain excel files.
@DarshilParmar
@DarshilParmar Год назад
Is it CSV or EXCEL, make sure it is CSV
@RajYadav-eb6pp
@RajYadav-eb6pp 2 года назад
What’s the point of using crawler ,when we can use Athena directly to work sql queries on s3
@DarshilParmar
@DarshilParmar 2 года назад
You will still have to create table on Athena to query data from s3 That means you’ll have to define schema, headers, other properties too. It’s a manual work but again there are different ways to solve one problem I just used glue Crawler to showcase one way
@surakshanaik1533
@surakshanaik1533 Год назад
For doing this project we need to create aws account right? Will it deduct money from account Can u please tell .
@DarshilParmar
@DarshilParmar Год назад
AWS Offers 12 Months free tier account so you won't get charged
@anukritikulshrestha5786
@anukritikulshrestha5786 Год назад
Can you please provide jupyter notebook
@ManishJindalmanisism
@ManishJindalmanisism 2 года назад
hi Darshil, what if we have multiple files under csv folder. Will crawler make multiple tables?
@DarshilParmar
@DarshilParmar 2 года назад
If the files have same structure then it will make one single table for all the data, if it has difficult files then it will give you an error while querying
@sembrueldorinvil4167
@sembrueldorinvil4167 Год назад
Is anybody having issues while crawling the us-states folder? The table does not display in Athena.
@sembrueldorinvil4167
@sembrueldorinvil4167 Год назад
Never mind. Policy issue.
@seifhossam7465
@seifhossam7465 Год назад
@@sembrueldorinvil4167 how did you solve it?
@studioTIMI
@studioTIMI Год назад
Crawler is not for free, right? Because it took me 0.5$
@DarshilParmar
@DarshilParmar Год назад
Raise the ticket to AWS and tell them you are a student, they won't charge
@studioTIMI
@studioTIMI Год назад
Thank you for advice!
@pradhyumansinghmandloi8240
@pradhyumansinghmandloi8240 2 года назад
You are using only tools then why this job is high paying? I think this demand is only because their are less people who can use this tool once enough people will learn this all then it will not demanding and high paying
@DarshilParmar
@DarshilParmar 2 года назад
So what's your plan bro? Can't learn tools that is used my less people because of demand will not be there in future and no point of learning tools that everyone know because of less pay
@pradhyumansinghmandloi8240
@pradhyumansinghmandloi8240 2 года назад
@@DarshilParmar bro point is as you told in one of your Vedio that it is one of thr high demanding and paying job in market but later it might not be like this. Their is no issue in learning the tools that everyone knows but one question in parallel with this is it good career for future then. I am started following roadmap but recently I watched your vedio how DE projects are made so that's why this question arise in my mind and only want your suggestion and guidance Thanks
@DarshilParmar
@DarshilParmar 2 года назад
​@@pradhyumansinghmandloi8240 I thought you made a statement But this goes for all of the career and if you just think and never take actions then you will stay behind While you are just thinking about tools and it's future there are other peole who already learned it, got the job and started thier career
@pradhyumansinghmandloi8240
@pradhyumansinghmandloi8240 2 года назад
@@DarshilParmar yes you are right I have already started my career as a software engineer but after watching your vedio and looking to switch into data engineering that's why I have some dout regarding this.
@mohamedrifky3413
@mohamedrifky3413 2 года назад
What is the end goal of this Project?
@DarshilParmar
@DarshilParmar 2 года назад
Building pipeline from Relational Data Model to Data Warehouse
@mohamedrifky3413
@mohamedrifky3413 2 года назад
@@DarshilParmar Thanks, I need idea to start small DE project can you suggest Small Datasets and inputs
@maybenew7293
@maybenew7293 2 года назад
I find it hard to understand you
@DarshilParmar
@DarshilParmar 2 года назад
Everyone learns diffrent way, lot of people found it helpful and easy to understand so maybe try someone else's channel if they work for you
@ajtam05
@ajtam05 2 года назад
i like the books, but you're doing it wrong. you're supposed to have them in a bookshelf in your garage...next to a lambo. lol
@DarshilParmar
@DarshilParmar 2 года назад
If Data Engineering does not work for me, that's my backup plan 😂
@skateforlife3679
@skateforlife3679 2 года назад
How i downloaded the data from the s3://covid19-lake : With the AWS CLI : aws s3 sync s3://covid19-lake// / I made 5 commands like this to uplad the 5 folders.
@SanthoshKumar-sl7zc
@SanthoshKumar-sl7zc 2 года назад
Далее
LOLLIPOP-SCHUTZ-GADGET 🍭 DAS BRAUCHST DU!
00:28
ОВР Шоу:  Семейные понты  @ovrshow_tnt
07:21
Fundamentals Of Data Engineering Masterclass
3:02:26
Просмотров 90 тыс.
Data Pipelines Explained
8:29
Просмотров 156 тыс.
Top AWS Services A Data Engineer Should Know
13:11
Просмотров 167 тыс.
LOLLIPOP-SCHUTZ-GADGET 🍭 DAS BRAUCHST DU!
00:28