Chapter #9 - How to design data pipeline on gcp (Google Cloud Platform) ?
Вставка
- Опубліковано 25 вер 2024
- Chapter #9 - Designing data pipeline solution on GCP
#datapipeline #googlecloud #gcp
What is Data Pipeline? - • Chapter #8 - Cloud IAM...
**Google Cloud Platform Beginner Series**
Google Cloud Platform Beginner Series (2020) - • Google Cloud Platform ...
**Networking Basics Playlist**
Networking and Infra Concepts - • Networking & Infra Con...
** Other Popular Playlists**
Crunching Data Series (2020) - • Learn - Data Engineeri...
Latest technology tutorial (2020) -
• What is a Data Vault ?...
Hi Friends, I am Anshul Tiwari, and welcome to our youtube channel IT k Funde.
More about this video -
In this video, we will learn something different, instead of discussing any specific product on google cloud platform, we will learn how to design a data pipeline solution on google cloud platform.
This will help us in 2 ways -
1. This will helps us improve our design thinking
2. We will get an overview of all google cloud products that can be used in developing a data pipeline.
We will start with understanding a typical on premise data pipeline and enterprise data warehouse (edw) design. We will then take this same solution and try to implement it on google cloud platform.
On-Prem solution design contains below products -
#Streaming data - Apache Kafka
#ETL - Informatica, IBM Datastage, SAP Data Services
#EDW - Teradata
#Dashbaords & reporting - Tableau and SAP Business Objects
GCP cloud design contains below products -
#Streaming data - Cloud PubSub
#ETL - Cloud Data Fusion
#Storage - Google Cloud Storage
#EDW - Google Big Query
#Dashboards - Looker, Google Data Studio
#ML - AutoML
#Metadata Management - Data Catalog
PLEASE WATCH ALL THE VIDEOS IN ANY PLAYLIST FOR BETTER UNDERSTANDING !!
Credits & Resources for further study -
GCP resources documentation for detailed study -
#Cloud PubSub - cloud.google.c...
#Cloud Data Fusion - cloud.google.c...
#Google Cloud Storage - cloud.google.c...
#Google Big Query- cloud.google.c...
#Data Studio - cloud.google.c...
#Looker - docs.looker.com/
#AutoML - cloud.google.c...
#Data Catalog - cloud.google.c...
images - pixabay.com
**Social Links**
UA-cam - / itkfunde
Facebook - / itkfunde
Linkedin - / ansh9685
Twitter - / ansh9685
Instagram - / itkfunde
**About This Channel**
Friends ITkFUNDE channel wants to bring I.T. industry knowledge, information, career advice, and much more to every individual regardless of whether he or she belongs to I.T or not. This channel is for everyone interested in learning something new!
This is very informative. Clean and clear of complex Jargons. Coming from a non-IT background I felt this video was very informative and descriptive. Thanks!
Thanks Shubham
As a Data Engineer who worked on Cloud solutions for 7 years, I have never seen such a correct and clean solution. I am interested to see the same solution on AWS as well.
Incredibly helpful -- interviewing for senior level data engineering positions and many have data pipeline design sections. This is perfect for that
I'm trying to build a data lake for an undergrad cloud class and honestly I was feeling pretty hopeless but after watching your video I feel way more prepared to tackle this!!!! Thank you!!!
Thanks Antonio I am so happy it helped in some little way 😊
Siddhi baat no bakwass perfect way / An Eye opener to a beginner / wana Pursue GCP
Hi. So glad for posting this. I was going through the coursera course for this and I never understood the big picture. It's so clear now. Thank you so much.
Thanks Amey so happy it helped 🙏
Very informative to the beginners of cloud but helped with on-prem solutions, thanks tons!!!
This is one of the great video to make me understand how Project architecture is there in GCP, I would request to please create a series to build end to end demo project in GCP utilizing all these services.
I am glad you have tutorials in English (since I don't speak or understand Hindi). Thanks for this video!
Thanks Prithvi
Very nice ......thanks for enlightning with so many information
really enjoy watching your video, very clear and well-explained.
This video is too good !! So many topics covered crisply in 1 video ... Thank you very much Sir :)
Thanks Pankaj ☺️🙏
Thank you very much for all your hard work and the nice lecture.
Thank you, mate! I like your optimism as well as the explanation.
Thanks Leonid🙏
Thank you for sharing. Your explanation of the data lake structure for both on-prem and cloud solutions was very clear and easy to follow.
Thanks Joan ☺️🙏
Absolutely, absolutely wonderful and insightful presentation. Thank you very much.
Just an observation. With BigQuery as your data warehouse, companies need not go for datamarts any more. BigQuery being a scalable solution, personnel from the various departments such as Sales, HR, Marketing, Finance can run their queries against a single database and still get results back without compromising on performance. Security can be implemented at the user/department level.
Thanks Ananda I cant agree more, BQ could be a one stop solution for vatious diff use cases
Really Great video, been looking for such explaination
It’s perfect explanation….you are genius man
Thanks. it was good presentation. To the point.
Really great video. So humble you are and you give good first impressions at 1:25
Thanks Rizal ☺️🙏
This has been very helpful. Thanks a lot for the video, and your detailing.
Thanks a lot🙏☺️
Very nice video, great overview that is very helpful in navigating the jungle of google tools. Thanks a lot!
Thanks Pesche
I really learned a lot through your videos. Thank you very much, cheers from Brazil!
Thanku sir As i requested you really created a video❤️❤️🙏 so nice video...
Thanks Moushmi hope you learnt something new from it pls keep sharing ur suggestions
Great explanation. Can you also do a video on how the traditional DW system is used in AWS and AZURE?
Thank you for sharing the information really helpful
Thanks Syed
great lecture, well explained - Thank you
Sooooper Simple, you made sir, Thanks a lot
You are most welcome
Thank you. Very useful video.
Very nicely explained. All the best. thank you!
Thanks for posting and thanks for your hard working!! I'd like to see, whenever possible, similar videos for AWS and Azure cloud offerings. Using the same left side starting point. Cheers!
Very very informative and useful video.Thanks for sharing !
Thanks Ankita 😊
Loved it, Thank you soo much for this!
Awesome Explanation.....
Very Informative !! Thank you for the great efforts !!
Thank you very much. Great video.
Great stuff thank you
Phenomenal Content.
Great work.
We expect some realtime project design on GCP.
Great explanation, very well presented
Thanks Moises ☺️🙏
Really good video and explained very well.
Très intéressant merci
3rd party -> gcs stage can also be done via arbitrary code inside a container on "cloud run jobs". I did that, and downstream what is shown in the video almost exactly on one of my freelance projects.
For data transformation and enrichment in GCP, Dataprep is the best tool
Yes Vardan Dataprep is good tool
Thanks for this, I was waiting for one such video from long time.
Thanks Pritesh🙏
Okay
Too good learning material!
Thx a bunch! Excellent explanation.
Thanks Sreedhar☺️
Very informative and detailed! Thank you!
Reallly Helpful videos! An aadvanced video on Bigquery & one on Cloud data fusion too:). Thanks for sharing these videos
Thanks Swati sure will try ☺️
Nice explaination. 👍 Want to have some more videos like this for real time data processing with Google cloud (for example IOT data,sensor data)
You are amazing!! Thanks for the clear video
Thanks Meera ☺️
Profound knowledge you are sharing with us. Thank you so much! One request: whenever you refer your other videos, can you please display them in those bubbles in a corner so that we can click on them and go to those videos? You know those small bubbles with link that pop up..
great content..thank you so much...
this is indeed a helpful video
Thanks a lot
excellent
brilliant brilliant explaination!keep it up!
Thanks, Amazing video and very helpful
Awesome video - thank you! 👍
Would love to see an equivalent video for AWS and Azure also.
Very well explained, loved it !!
Thanks Ambar🙏🙏☺️☺️
Thank you so much for the hard work you have taken for making these concepts very easy to understand..
Great work.. Keep posting such informative videos
Dataform is another amazing tool for ELT jobs
You might make my next job a bigger paycheck,nice video
Thanks buddy
Amazing !
Excellent.
absolutely amazing video!!!!!!!!!!!!!!!!!!
Thanks John
Thanks for the video..!
Great explanation..one request .. please use mic 🎙️ as voice is Little low as compared to other educational videos.... great job..
Sure Rakesh thx for feedback and support 🙏
Very informative boss, keep going
This is really helpful ..
Thanks Pradeep
It's really excellent with kind of explanation .
Sir do you have gcp pde paid course as well,plz comment
Thanks a lot
Most welcome
Thank you ❤
Informative video. Why haven't you used cloud dataflow for ETL? Can cloud data fusion perform better ETL tasks than cloud dataflow?
can you do an end to end project in google cloud using this services.Then it will good for us.A lot of thanks to you for giving this type of content.
thanks for suggestion
In your architecture where is the pub sub messages are saving is in cloud storage and then etl pupeline pick and load in to big query?
Great
good one. what is datamart, for datamart you have been using data studio,automl,looker? can u pls explain why??
very helpful video.. one question.. do we need to create a VM instance if we go by this approach for GCP. Where do we trigger the gsutil command ? How do we go to the backend of fusion instance?
Very good explanation, please make some videos related to complete data engineer project flow with pyspark or SQL
Thanks Sathish ☺
@@ITkFunde hi , is this is roadmap for data engineer using google cloud ?
Gud explanation
Thanks Rahul
This is soo good
Hey Thanks for this video, I have 1 question. If we want to do performance test for this type on msging queue application, what should be our approach.?? and how we can do this.. plz
Please make a video real time projects in gcp
Question sir: on the Google solution, why do you have two separate Cloud Storage components?
Really good video and good explanation learned a lot. I just wanted to ask one thing ,the cloud model you showed is it conventional ETL flow or its more of ELT with subset of ETL , because here we are using both the flow or its some kind of new approach which we can use, if would be really good if you could share your thoughts on this
Dear Anshul, how are you ? I have been working as Data Engineer in on-prem solution of our company for more than 10 years and now wish to move to Cloud Based solution, like GCP Data Engineer. Can you please do help me with the below queries I have :-
1. I am having total 15+ years of IT Experience. Will it be a good decision to switch to Cloud Data Engineer Roles now ? It seems to me bit late to start journey in this domain now. Please do correct me , if I am wrong.
2. In order to start / work with the GCP Data Engineering Role, can you kindly suggest me what are the topics / tools / GCP Services I need to learn ? I have basic ETL Concept and also working with PLSQL , Python stuff.
Thanks in advance !!
Hi Nilava, 15+ years of exp is quite a lot, in todays age tech roles are defying age and exp boundaries but in indian IT your total exp and respective role does put an image on your career profile thus i would suggest you move towards cloud data architect sort of roles or solution architects. Also if you starting from a clean slate then you should also think of becoming a Data Lead or Manager and manage a team of Data engineers under you. Think big !
@@ITkFunde yes very true Anshul.. thats what I was thinking also. 🙂
Great video! I really appreciate the effort you put into this video and it really helped me out. Thanks a lot1
Nice intro! well done
Thanks a lot Roland
Thanks
Sir really amazing video ! I was wondering where can I learn basics of the software which you mentioned ( SAP , IBM ) ?
Thanks youtube has everything for free or else try udemy for reasonable courses
om shree ganpatye namo:
Good explanation Sir, could you please make video on Streamsets pipeline?
thank you !
Good one :) :D
AMAZING VIDEO!
The cloud storage in the middle is wrong. You can't store structured data in Cloud Storage.
@Pradeep Singh, can't we store the raw data as text files? Acts as a datalake and also as a backup of our original, untouched, unedited data.
just G.R.E.A.T.
what can be the most cost efficient way to ingest a few tables from snowflake to GCP bigQuery
also is it possible to do Export and then transform before saving to bigQuery instead to do ELT as explained in the video. if yes then will that be a good option which is cost efficient.
Is there any practical video creating a data pipeline?
We are facing problems with almost all services that we have been using with GCP, very limited plugins and features serve to basic use cases. even connectivity between services is also troublesome. long way to go