Hello kar Sir , sorry for late reply , but if you are still looking for solution , you can refer this -- community.snowflake.com/s/question/0D53r0000BZdpmXCQR/invalid-property-errorintegration-for-task-message-when-defining-task-object Here I have uploaded a detail video on this topic too , sharing the link if it helps -- th-cam.com/video/tZi-Rtqa6a0/w-d-xo.html Happy Learning
Perfect explanation thank you . Is there a way to send the same type of notification by using the STREAM object. ex : If stream data not getting inserted into target table then send the notification OR if successful also then do the same?
Hi @vislavathpradhyumna4680, I don't have much exposure with Azure at the moment. If I explore this cloud provider in the future, I'll definitely consider making a video about it. Thanks for your suggestion!
So you asked 3 questions & here are the answers -- Coming to your first question , Is there any way reprocess this file?? Yes , but manual interference will come in the picture ... Suppose you are using snowpipe , you set up everything , completed production deployment & post production monitoring , went to chill after finding no issue for first few days after production deployment and after few days production system Snowpipe suddenly broke down for some bad data or something 😅 then these steps should be there -- Step 1: alert should be sent to all developer or admin team , then only they will come to check health , else no-one will even know issue happened in Snowpipe in prod environment , so you must have to setup alarm functionality so that immediate actions can be taken to sort it out before the business stakeholders come and complain about the issue Now you got some idea from the alert mail/sms itself what issue happened , the next step Step 2: developer will come to check what happened Then they have to dig deeper in Snowpipe which I explained in this video-- th-cam.com/video/6IVtCaW9P8w/w-d-xo.html The files for which issue appeared those has to be loaded manually after applying certain transformation whatever required ... Coming to your second question , Can we get these scripts for practice-- For scripts , you can check the code posted in the description box... Coming to your third question , Any video with azure cloud ?-- No , I only work with AWS till now ... hope this will be helpful 😊✌🏻
Very much intuitive video, perfect explanation. Just continue your good work !
Thank you Shubham Singh! Happy Learning
thanks for making these videos
Amazing video i have to implement the same feature in snowpipe to get notification to user if my copy command fails in snowpipe.This really helps
hi, Nice video. Have you added notification to TASK ? i am receiving the following error " invalid property 'ERROR_INTEGRATION' for 'TASK'
Hello kar Sir , sorry for late reply , but if you are still looking for solution , you can refer this -- community.snowflake.com/s/question/0D53r0000BZdpmXCQR/invalid-property-errorintegration-for-task-message-when-defining-task-object
Here I have uploaded a detail video on this topic too , sharing the link if it helps -- th-cam.com/video/tZi-Rtqa6a0/w-d-xo.html
Happy Learning
Hello, how do measure the files time loading ingested by Snowpipe please, i want to know how long does it take to load a bunch of file ?
Perfect explanation thank you . Is there a way to send the same type of notification by using the STREAM object. ex : If stream data not getting inserted into target table then send the notification OR if successful also then do the same?
Hello Bhrat , you can check this video -- th-cam.com/video/70-4RZNTcA4/w-d-xo.html Hope this will be helpful! Happy Learning
This is an amazing video. Thank you so much.
Thanks Soumya Naidu ! Happy Learning :-)
This vedio is amazing, can you help us with Azure please.....🙏🙏🙏
Hi @vislavathpradhyumna4680, I don't have much exposure with Azure at the moment. If I explore this cloud provider in the future, I'll definitely consider making a video about it. Thanks for your suggestion!
Is there any way reprocess this file??Nice video..Can we get these scripts for practice..Any video with azure cloud ?
So you asked 3 questions & here are the answers --
Coming to your first question , Is there any way reprocess this file??
Yes , but manual interference will come in the picture ...
Suppose you are using snowpipe , you set up everything , completed production deployment & post production monitoring , went to chill after finding no issue for first few days after production deployment and after few days production system Snowpipe suddenly broke down for some bad data or something 😅
then these steps should be there --
Step 1: alert should be sent to all developer or admin team , then only they will come to check health , else no-one will even know issue happened in Snowpipe in prod environment , so you must have to setup alarm functionality so that immediate actions can be taken to sort it out before the business stakeholders come and complain about the issue
Now you got some idea from the alert mail/sms itself what issue happened , the next step
Step 2: developer will come to check what happened
Then they have to dig deeper in Snowpipe which I explained in this video--
th-cam.com/video/6IVtCaW9P8w/w-d-xo.html
The files for which issue appeared those has to be loaded manually after applying certain transformation whatever required ...
Coming to your second question , Can we get these scripts for practice--
For scripts , you can check the code posted in the description box...
Coming to your third question , Any video with azure cloud ?--
No , I only work with AWS till now ...
hope this will be helpful 😊✌🏻