How to Create Redshift Cluster, Load Data, Unload Data| Redshift spectrum

  Рет қаралды 10,584

Techno Devs with Saurabh

Techno Devs with Saurabh

Жыл бұрын

Learn complete redshift practical lab
This is a very important demo video for redshift where I explained all of the redshift concept practically from scratch in Hindi
I have covered the below topics.
Create Redshift cluster
Install SQL workbench
Integrate AWS Redshift with SQL workbench
Query editor
Create an IAM role for redshift
Create database, schema, user, and tables in the cluster
Load and unload data
CSV files from S3 into Redshift with AWS Glue
Redshift spectrum
how to Create External schema and table
create external table
How to create a procedure
For a complete tutorial for redshift, refer to the below video.
• Aws Redshift tutorial ...
Please Like the video, subscribe to my channel, and forward my channel link to your friend. thanks for watching my videos and for your support.
if you have any queries please write back to me at technodevs13@gmail.com or WhatsApp me at number-8800502668

Пікірлер: 47
@hitesh7719
@hitesh7719 3 күн бұрын
Excellent video . Can not thank you enough for giving me the confidence of mastering redshift foundation from both your redshift theory and this practical tutorial.
@abhishekmcajec
@abhishekmcajec 18 күн бұрын
Very good explanation
@world4376
@world4376 7 ай бұрын
You are Just amazing NO one explained Redshift Like you did...
@deepakgt3396
@deepakgt3396 Жыл бұрын
Saurabh you are best and simple, clear :-)
@abhijeetjain8228
@abhijeetjain8228 3 ай бұрын
Very Good Explanation.
@mohandoke8306
@mohandoke8306 11 ай бұрын
Thanks very nice , helful to us❤
@nikhilkumawat3317
@nikhilkumawat3317 Жыл бұрын
excellent job 🤟
@maheshjaat9349
@maheshjaat9349 Жыл бұрын
Full support 🔥
@zishankhan8054
@zishankhan8054 Жыл бұрын
Video are best but you are always best
@unifaid1532
@unifaid1532 Жыл бұрын
What a great video
@siddhanthjagtap7736
@siddhanthjagtap7736 9 ай бұрын
OMG you have made my life easier thanks for the support It means alot Mr Saurabh ji, Now i see many hopes to get a job soon by following ur videos thanks
@aakashkarsan5532
@aakashkarsan5532 Жыл бұрын
Become Always nice video
@user-ek8ro7my5v
@user-ek8ro7my5v 10 ай бұрын
good job, brother.
@piyushkumawat7804
@piyushkumawat7804 Жыл бұрын
Always be good video 😎
@rohankapoor2822
@rohankapoor2822 Жыл бұрын
Video is very nice!
@shubhamalsunde3230
@shubhamalsunde3230 9 ай бұрын
best demo Sir
@laxitamoond1598
@laxitamoond1598 Жыл бұрын
Fantastically video ended
@neerajkumar86
@neerajkumar86 2 ай бұрын
Awesome
@thetechies2259
@thetechies2259 10 ай бұрын
awesome video, very well explained., i think i need tuition from you
@ammyvirk8485
@ammyvirk8485 Жыл бұрын
liked a lot
@inderatwal6873
@inderatwal6873 Жыл бұрын
1 no video
@nitinraika1987
@nitinraika1987 Жыл бұрын
Crazy video 🤠🤠🤠
@pramodchoudhary7073
@pramodchoudhary7073 Жыл бұрын
Woow 🥳
@kishanvarma711
@kishanvarma711 Жыл бұрын
Good ♥️
@aadityasani7039
@aadityasani7039 Жыл бұрын
OMG 🔥🔥🔥🔥
@ChetanSharma-oy4ge
@ChetanSharma-oy4ge 10 ай бұрын
awsome content , it would be great if you share a github repo link where you add this ppt with commands.
@MumtazKhan-nv9uj
@MumtazKhan-nv9uj Жыл бұрын
Nice video...very nice & detail explanation....thx for all your efforts. Can we get a tutorial where we can do Python & SQL transformations in Glue job while sending data from S3 to Redshift.
@TechnoDevs
@TechnoDevs Жыл бұрын
Sure bro.. that is under process.
@avinash7003
@avinash7003 6 ай бұрын
please do project on Lambda,Glue,Redshift,athena,EMR ..............
@kalpeshrajpirohit2940
@kalpeshrajpirohit2940 Жыл бұрын
🔥🔥🔥🔥🔥🔥
@abhijeetjain8228
@abhijeetjain8228 3 ай бұрын
Sir Can you please share the PowerPoint file as well.
@mayankvarma3182
@mayankvarma3182 Жыл бұрын
Hello ... Long time
@rahulvarma1323
@rahulvarma1323 Жыл бұрын
💥💥💥💥💥💥
@ChetanSharma-oy4ge
@ChetanSharma-oy4ge 10 ай бұрын
you have mentioned many approaches to load the data in Redshift, please mention which approach best for which scenario. Apart from the thing when we don't want to store data in redshift directly.
@TechnoDevs
@TechnoDevs 10 ай бұрын
Uploading data from Amazon S3 to Amazon Redshift can be done by two method 1.Glue ETL script ->used in case of complex transformation and aggregation 2.simple python script using boto3 library and copy command ->used in case of upload bulk data.
@deepakpradhan9743
@deepakpradhan9743 10 ай бұрын
Can you provide the data sources link.
@user-by9lm9gv3z
@user-by9lm9gv3z Жыл бұрын
can we get this ppt link
@decententerprises1739
@decententerprises1739 Жыл бұрын
How to get this PPT?
@lilisarkar5059
@lilisarkar5059 Жыл бұрын
☺️☺️☺️☺️☺️
@aayushjayswal6125
@aayushjayswal6125 Жыл бұрын
✌️✌️✌️✌️
@deepakchoudhary9379
@deepakchoudhary9379 Жыл бұрын
🙊🙊🙊🙊🙊
@sagar2854
@sagar2854 Жыл бұрын
Hello sir why it give error Connection attempt failed I followed all your steps
@TechnoDevs
@TechnoDevs Жыл бұрын
Check your java path and also make sure cluster should public accessible.
@pavanyenigi6252
@pavanyenigi6252 11 ай бұрын
Same for me as well. Checked both still getting the error
@supermandc8150
@supermandc8150 4 ай бұрын
share ppt
@avinashmarothiya6438
@avinashmarothiya6438 Жыл бұрын
how much money do you earn 🙊
@mukeshnaga1117
@mukeshnaga1117 Жыл бұрын
Failed all the competitors 💯
AWS DynamoDB Complete Lab| Create table ,item and index and insert data Demo
38:41
Techno Devs with Saurabh
Рет қаралды 2,8 М.
Amazon Redshift for Beginners (Full Course)
32:33
ETL-SQL
Рет қаралды 22 М.
Now THIS is entertainment! 🤣
00:59
America's Got Talent
Рет қаралды 37 МЛН
Despicable Me Fart Blaster
00:51
_vector_
Рет қаралды 22 МЛН
AWS Tutorials - Access Glue Catalog using Amazon Redshift Spectrum
32:34
Amazon Redshift Optimization
1:26:57
LatentView Analytics Ltd.
Рет қаралды 4,4 М.
AWS Redshift Query Tuning and Performance Optimization
1:45:40
Aurobindo Saha
Рет қаралды 43 М.
Aws Redshift tutorial |Amazon Redshift Architecture | Data Warehouse Concept(Hindi)
1:28:06
Getting Started with Amazon Redshift - AWS Online Tech Talks
46:39
AWS Developers
Рет қаралды 56 М.
Это - iPhone 16 и вот что надо знать...
17:20
Overtake lab
Рет қаралды 98 М.
Зачем ЭТО электрику? #секрет #прибор #энерголикбез
0:56
Александр Мальков
Рет қаралды 625 М.
Что делать если в телефон попала вода?
0:17
Лена Тропоцел
Рет қаралды 851 М.
НЕ ПОКУПАЙ СМАРТФОН, ПОКА НЕ УЗНАЕШЬ ЭТО! Не ошибись с выбором…
15:23