CREATE TASK in Snowflake

[@कलयुग_कर्ण]

For example consider a student table and student_info table two table has same data if any changes happened in student table like insert delete update this same changes can be capture and load in student_info table

[@KnowledgeAmplifier1]

Please use snowflake stream to track change and reflect in some other table -- docs.snowflake.com/en/user-guide/streams.html

[@sa2144]

very informative. do you have any video to insert data from query every day automatically in increment order

[@atindrabhattacharya8828]

Very good video.. short but informative. I will suggest pls numbering the video so we can track our progress too. Thanks Jai hind

[@KnowledgeAmplifier1]

Hello Atindra Bhattacharya, you can refer this document to access all the videos topicwise and in-order -- doc.clickup.com/37466271/d/h/13qc4z-104/d4346819bd8d510 Happy Learning

[@pranavmallavarapu586]

Hello, Hello, I have a requirement where I need to show values of yesterday's (1 day before, i.e if I run the query today I need the values of yesterday). and I need to run it on daily basis. How can I achieve that in snowflake?

[@कलयुग_कर्ण]

Please send me code of this problem save my internship and snowflake ❄️ journey please help 🙏 Big fan please help