Snowflake - AWS Integration

[@shwetketu514]

Thank you so much sir, your video was a great help,no one had explained this thing with so clarity on youtube,you are the best once again thank you very much. 👍

[@sekharmamilla4348]

Thanks for your clear explanation.

[@raghavsanisetty5535]

Awesome job Jana!!! This is very helpful!!!

[@bhavyasuma9662]

Awesome no one will explains like you 👌👌

[@azada.k958]

Thanks sir .....u r great teacher

[@sureshrecinp]

Thank you for sharing the info.

[@pratikthole2414]

Great Explanation , Crystal Clear .

[@talladasaisatishkumar2271]

Please upload more videos on aws its very useful

[@varunjain2645]

please if you can demonstrate etl pipeline with automation..this was a great video with very clear explanation.. thanks

[@bangalorerose5684]

bro really appreciable effort by thank you for this

[@PremKumar-wy3mx]

Very useful video !

[@ThirumaleshNiraganti]

Thank you, fully satisfied. If possible, please share those sample files(csv,json)
I have done this without files so results me Query produced no results while execute the state object and final customer data table

[@mrjana520]

You can get all snowflake Videos, PPTs, Queries, Interview questions and Practice files in my Udemy course. I will be updating this content and will be uploading all new videos in this course. And you will have lifelong access to these videos and materials.
My Snowflake Udemy Course:
www.udemy.com/course/snowflake-complete-course-for-clearing-interviews/?couponCode=JANA-SF-20012024

[@mayanknema3007]

Awesome Video. Please also make one video on data load through Snowpipe.

[@mrjana520]

The next video will be on Snowpipe only

[@parthibans7596]

thank you so much.i did

[@prabhakarravi2671]

Thank you so much Sir

[@vinodangadi4732]

Hi Jana, Thank you for nice videos and clear explanations, just wanted to inform that IAM stands for Identity and Access Management may its a typo in the video.

[@mrjana520]

Yes it was a mistake

[@akhilbyreddy4739]

Hi Janardhan, I have one doubt. Why you are creating separate schema for all individual objects. For example, for pipes you are creating one schema and for stages you are creating another schema. Is that for your easily accessible while doing video or in real time, Is that the process?

[@mrjana520]

There is no rule for creating separate schemas, just for easy understanding I did like that

[@kalyankumar7336]

After creating integration object can we alter that one, My doubt is I need to change some specific object only like need to change the Comment like. Is it possible to do that?

[@mrjana520]

Yes you can, check alter Integration command given in snowpipe video

[@kalyankumar7336]

@@mrjana520 Got It, Thank you Janardhan.

[@ankitrahude6408]

Hi , I am geeting following error while load file from external stage.
Field delimiter ',' found while expecting record delimiter '
'
Can you please help me to resolve it ?

[@mrjana520]

reach me on [e-mail]

[@chandrasekhar987]

IAM ---> Identity and Access Management

[@mrjana520]

Thank you, corrected it

[@harinimmagadda14]

sir,i have a file in s3 bucket, in that file i have 20 records, i want only 5 records?what is the process?

[@mrjana520]

Currently there is no filter option in Copy command, you can load all 20 records to stage table and then filter required data to main target table

[@bhargavi9705]

Hi sir,Very good explanation ,Thank you .

[@saisrujan6467]

Hii sir where did i get csv and json data.. I actually download csv files from Google but it showing some error...

[@mrjana520]

You can get all snowflake Videos, PPTs, Queries, Interview questions and Practice files in my Udemy course for 499 rupees.. I will be updating this content and will be uploading all new videos in this course.
My Snowflake Udemy Course:
www.udemy.com/course/snowflake-complete-course-for-clearing-interviews/?couponCode=C2271E74086DBBD928D9
Use the coupon below to get it for 499 rupees.
Coupon: C2271E74086DBBD928D9

[@durgasasank2633]

Can I use same Amazon account for multiple snowflake accounts

[@abhishek_grd]

Sir can we do the same thing using lambda. I mean copy the CSV files from s3 snowflake table using lambda function. So that i can automate.
Please share the details/ code

[@mrjana520]

Don't have idea on lambda function

[@prakashgrandi5508]

How I can get the CSV files what you have uploaded in your aws account
Customer_data_2020csv

[@mrjana520]

I can be reachable on [e-mail]

[@prakashgrandi5508]

@@mrjana520 yes I have contacted you through the mail
and also please give me your contact number also will ping you on WhatsApp if have any doubts.

[@durgasasank2633]

Can i use the region canada central extra charges may apply?

[@mrjana520]

yes, but very little, don't worry with trial version

[@durgasasank2633]

@@mrjana520 ok sir in Canada central region S3 bucket below 500TB it charges 0.02$ per gb sir I got this in billing and terms in aws

[@ChandraTanikonda]

can you provide some csv,json,parquet files for the practice

[@mrjana520]

You can get all snowflake Videos, PPTs, Queries, Interview questions and Practice files in my Udemy course for 499 rupees.. I will be updating this content and will be uploading all new videos in this course. And you will have lifelong access to these videos and materials.
My Snowflake Udemy Course:
www.udemy.com/course/snowflake-complete-course-for-clearing-interviews/?couponCode=59AB19A09E3CFF6C5070
Use the coupon below to get it for 499 rupees.
Coupon: 59AB19A09E3CFF6C5070

[@prakashgrandi5508]

Integration is successful ,file also loaded but data not showing

[@mrjana520]

Please check the code, if any mistakes or you can reach me on my email

[@prakashgrandi5508]

its fine

[@venkateshkyathur9822]

How to contact you sir

[@mrjana520]

I can be reachable on [e-mail]

[@venkateshkyathur9822]

Can you provide snowflake real time projects

[@mrjana520]

There is nothing like real time and non-real time, what ever we learn we implement the same in projects

[@TDP_CBN_2024]

Hi sir can we connect

[@mrjana520]

[e-mail]

[@venkateshkyathur9822]

Hi sir...