Chapter #9 - How to design data pipeline on gcp (Google Cloud Platform) ?
ฝัง
- เผยแพร่เมื่อ 30 มี.ค. 2021
- 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.com/pubsub/docs/...
#Cloud Data Fusion - cloud.google.com/data-fusion/...
#Google Cloud Storage - cloud.google.com/storage/docs...
#Google Big Query- cloud.google.com/bigquery/doc...
#Data Studio - cloud.google.com/bi-engine/do...
#Looker - docs.looker.com/
#AutoML - cloud.google.com/automl/docs
#Data Catalog - cloud.google.com/data-catalog...
images - pixabay.com
**Social Links**
TH-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!
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 😊
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.
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 🙏
I really learned a lot through your videos. Thank you very much, cheers from Brazil!
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
Great work.
We expect some realtime project design on GCP.
really enjoy watching your video, very clear and well-explained.
Thank you very much for all your hard work and the nice lecture.
Very informative to the beginners of cloud but helped with on-prem solutions, thanks tons!!!
Great explanation. Can you also do a video on how the traditional DW system is used in AWS and AZURE?
Very informative and detailed! Thank you!
This video is too good !! So many topics covered crisply in 1 video ... Thank you very much Sir :)
Thanks Pankaj ☺️🙏
great lecture, well explained - Thank you
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 ☺️🙏
Very nice ......thanks for enlightning with so many information
Nice explaination. 👍 Want to have some more videos like this for real time data processing with Google cloud (for example IOT data,sensor data)
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
Very nicely explained. All the best. thank you!
It’s perfect explanation….you are genius man
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!
Thank you, mate! I like your optimism as well as the explanation.
Thanks Leonid🙏
I am glad you have tutorials in English (since I don't speak or understand Hindi). Thanks for this video!
Thanks Prithvi
Awesome video - thank you! 👍
Would love to see an equivalent video for AWS and Azure also.
This has been very helpful. Thanks a lot for the video, and your detailing.
Thanks a lot🙏☺️
Phenomenal Content.
Very Informative !! Thank you for the great efforts !!
Thanks, Amazing video and very helpful
Loved it, Thank you soo much for this!
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..
Really Great video, been looking for such explaination
brilliant brilliant explaination!keep it up!
Really great video. So humble you are and you give good first impressions at 1:25
Thanks Rizal ☺️🙏
Too good learning material!
Thank you very much. Great video.
Thank you. Very useful video.
Awesome Explanation.....
Très intéressant merci
Very nice video, great overview that is very helpful in navigating the jungle of google tools. Thanks a lot!
Thanks Pesche
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
Reallly Helpful videos! An aadvanced video on Bigquery & one on Cloud data fusion too:). Thanks for sharing these videos
Thanks Swati sure will try ☺️
Thanks. it was good presentation. To the point.
Very well explained, loved it !!
Thanks Ambar🙏🙏☺️☺️
You are amazing!! Thanks for the clear video
Thanks Meera ☺️
Very informative boss, keep going
Thanks for the video..!
Amazing !
Thanks for this, I was waiting for one such video from long time.
Thanks Pritesh🙏
Okay
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.
Really good video and explained very well.
Thx a bunch! Excellent explanation.
Thanks Sreedhar☺️
AMAZING VIDEO!
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
Excellent.
great content..thank you so much...
Great video! I really appreciate the effort you put into this video and it really helped me out. Thanks a lot1
Thank you for sharing the information really helpful
Thanks Syed
absolutely amazing video!!!!!!!!!!!!!!!!!!
Thanks John
Great explanation, very well presented
Thanks Moises ☺️🙏
For data transformation and enrichment in GCP, Dataprep is the best tool
Yes Vardan Dataprep is good tool
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?
Sooooper Simple, you made sir, Thanks a lot
You are most welcome
this is indeed a helpful video
Thanks a lot
excellent
Thank you ❤
Great
You might make my next job a bigger paycheck,nice video
Thanks buddy
This is soo good
thank you !
Informative video. Why haven't you used cloud dataflow for ETL? Can cloud data fusion perform better ETL tasks than cloud dataflow?
Good one :) :D
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?
This is really helpful ..
Thanks Pradeep
Thanks
Question sir: on the Google solution, why do you have two separate Cloud Storage components?
Dataform is another amazing tool for ELT jobs
Gud explanation
Thanks Rahul
Nice intro! well done
Thanks a lot Roland
Very very informative and useful video.Thanks for sharing !
Thanks Ankita 😊
It's really excellent with kind of explanation .
Sir do you have gcp pde paid course as well,plz comment
Good explanation Sir, could you please make video on Streamsets pipeline?
Thanks a lot
Most welcome
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
good one. what is datamart, for datamart you have been using data studio,automl,looker? can u pls explain why??
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 ?
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 🙏
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
just G.R.E.A.T.
Please make a video real time projects in gcp
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
Is there any practical video creating a data pipeline?
om shree ganpatye namo:
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.
Hi I see that your videos are getting older and platforms like GCP changes their platforms very frequently, could you please update your videos to sync up or upload delta videos to complement older ones up to the latest ones...
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.
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. 🙂
Is Big Query DataLake or Cloud Storage?
@vaibhav Sharma, it could act as a datalake as well as storage, but primarily it is a data warehouse for analytic purposes.
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
Could you help me with dataProc, data flow and data prep please
Thanks Rincy will try to make for sure