Tap to unmute

Snowflake Snowpipe - Email Alert Mechanism

  Рет қаралды 5,485

Knowledge Amplifier

Knowledge Amplifier

Күн бұрын

Пікірлер: 15
@shaborn2rockable
@shaborn2rockable 2 жыл бұрын
Very much intuitive video, perfect explanation. Just continue your good work !
@KnowledgeAmplifier1
@KnowledgeAmplifier1 2 жыл бұрын
Thank you Shubham Singh! Happy Learning
@fahadmahmood7150
@fahadmahmood7150 2 жыл бұрын
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
@Buzzingfact
@Buzzingfact 2 жыл бұрын
thanks for making these videos
@snaidu70
@snaidu70 2 жыл бұрын
This is an amazing video. Thank you so much.
@KnowledgeAmplifier1
@KnowledgeAmplifier1 2 жыл бұрын
Thanks Soumya Naidu ! Happy Learning :-)
@vislavathpradhyumna4680
@vislavathpradhyumna4680 5 ай бұрын
This vedio is amazing, can you help us with Azure please.....🙏🙏🙏
@KnowledgeAmplifier1
@KnowledgeAmplifier1 5 ай бұрын
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!
@bhratkapoor5230
@bhratkapoor5230 2 жыл бұрын
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?
@KnowledgeAmplifier1
@KnowledgeAmplifier1 2 жыл бұрын
Hello Bhrat , you can check this video -- kzbin.info/www/bejne/bWGQZYWQg7mWd5Y Hope this will be helpful! Happy Learning
@karsir4541
@karsir4541 2 жыл бұрын
hi, Nice video. Have you added notification to TASK ? i am receiving the following error " invalid property 'ERROR_INTEGRATION' for 'TASK'
@KnowledgeAmplifier1
@KnowledgeAmplifier1 2 жыл бұрын
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 -- kzbin.info/www/bejne/qovMXoWqpsZpl5I Happy Learning
@Lapookie
@Lapookie 2 жыл бұрын
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 ?
@swathireddy832
@swathireddy832 2 жыл бұрын
Is there any way reprocess this file??Nice video..Can we get these scripts for practice..Any video with azure cloud ?
@KnowledgeAmplifier1
@KnowledgeAmplifier1 2 жыл бұрын
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-- kzbin.info/www/bejne/bHq5pXaXjJ6Dbtk 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 😊✌🏻
Troubleshooting Snowpipe in-depth explanation
19:29
Knowledge Amplifier
Рет қаралды 3,6 М.
Snowflake Row-level Security In-depth explanation
17:23
Knowledge Amplifier
Рет қаралды 4,2 М.
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 42 МЛН
路飞做的坏事被拆穿了 #路飞#海贼王
00:41
路飞与唐舞桐
Рет қаралды 26 МЛН
Try this prank with your friends 😂 @karina-kola
00:18
Andrey Grechka
Рет қаралды 7 МЛН
Configuring a Snowflake Storage Integration to Access Amazon S3
19:18
Knowledge Amplifier
Рет қаралды 10 М.
Load JSON file into Snowflake table using Snowpipe
20:49
Knowledge Amplifier
Рет қаралды 6 М.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 219 М.
Snowflake Lambda Data Loader - Example with AWS S3 Trigger
26:42
Knowledge Amplifier
Рет қаралды 9 М.
ETL Workflow In Snowflake | Chapter-19 | Snowflake Hands-on Tutorial
1:01:33
Data Engineering Simplified
Рет қаралды 123 М.
OAuth 2.0 and OpenID Connect (in plain English)
1:02:17
OktaDev
Рет қаралды 1,8 МЛН
Working with Roles and Users in Snowflake
13:30
Knowledge Amplifier
Рет қаралды 10 М.
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 42 МЛН