Janardhan Reddy Bandi
Janardhan Reddy Bandi
  • 270
  • 1 457 363
Snowflake SP - 20 - Debugging Stored Procedures
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course.
www.udemy.com/course/snowflake-scripting-stored-procedures/
มุมมอง: 43

วีดีโอ

Snowflake SP - 19 - Automate Test Data Loads from One Env to Other Env
มุมมอง 14512 ชั่วโมงที่ผ่านมา
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures/
Snowflake SP - 18 - Delta/Incremental Load Automation
มุมมอง 201วันที่ผ่านมา
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures
Snowflake SP - 17 - Full Load Automation
มุมมอง 24614 วันที่ผ่านมา
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures
Snowflake SP - 16 - Migrate DDLs to Other Environments
มุมมอง 33521 วันที่ผ่านมา
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures
Snowflake SP - 15 - SCD Type - 2 Implementation
มุมมอง 42521 วันที่ผ่านมา
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures
Snowflake SP - 13 - Automate Tables and Views Dropping
มุมมอง 193หลายเดือนก่อน
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures/
Snowflake SP - 12 - Automate 1-1 View Creation
มุมมอง 298หลายเดือนก่อน
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures/?couponCode=SNOWSCRIPT_23202409 Coupon: SNOWSCRIPT_23202409
Snowflake SP - 11 - Procedure to Automate Data Loads
มุมมอง 340หลายเดือนก่อน
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures/?couponCode=SNOWSCRIPT_23202409 Coupon: SNOWSCRIPT_23202409
Snowflake SP - 10 - Real Time Stored Procedures
มุมมอง 224หลายเดือนก่อน
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures/?couponCode=SNOWSCRIPT_23202409 Coupon: SNOWSCRIPT_23202409
Snowflake Scripting - 9 - Information Schema
มุมมอง 285หลายเดือนก่อน
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures/?couponCode=SNOWSCRIPT_23202409 Coupon: SNOWSCRIPT_23202409
Snowflake Scripting - 8 - Transaction Control
มุมมอง 290หลายเดือนก่อน
Hi, You can get all the PPTs and Queries for Practicing along with the videos from below Udemy Course for 499 rupees only. You will have lifetime access for this course. www.udemy.com/course/snowflake-scripting-stored-procedures/?couponCode=SNOWSCRIPT_23202409 Coupon: SNOWSCRIPT_23202409
Snowflake Scripting - 7 - Exception Handling
มุมมอง 322หลายเดือนก่อน
Snowflake Scripting - 7 - Exception Handling
Snowflake Scripting - 6 - Cursors and ResultSets
มุมมอง 3372 หลายเดือนก่อน
Snowflake Scripting - 6 - Cursors and ResultSets
Snowflake Scripting - 5 - For and While Loops
มุมมอง 4232 หลายเดือนก่อน
Snowflake Scripting - 5 - For and While Loops
Snowflake Scripting - 4 - IF and Case Statements
มุมมอง 3842 หลายเดือนก่อน
Snowflake Scripting - 4 - IF and Case Statements
Snowflake Scripting - 3 - Table Literals and Identifiers
มุมมอง 5022 หลายเดือนก่อน
Snowflake Scripting - 3 - Table Literals and Identifiers
Snowflake Scripting - 2 - Variables
มุมมอง 6972 หลายเดือนก่อน
Snowflake Scripting - 2 - Variables
Snowflake Scripting - 1 - What is a Stored Procedure? How to write a Procedure?
มุมมอง 1.2K2 หลายเดือนก่อน
Snowflake Scripting - 1 - What is a Stored Procedure? How to write a Procedure?
Snowflake Scripting - Writing Stored Procedures Using SQL - Course Introduction
มุมมอง 1.5K2 หลายเดือนก่อน
Snowflake Scripting - Writing Stored Procedures Using SQL - Course Introduction
Snowflake Scripting - Writing Stored Procedures Using SQL
มุมมอง 1.5K4 หลายเดือนก่อน
Snowflake Scripting - Writing Stored Procedures Using SQL
Snowflake SP - 14 - SCD Type - 1 Implementation
มุมมอง 3.7K6 หลายเดือนก่อน
Snowflake SP - 14 - SCD Type - 1 Implementation
Please Vote - తప్పనిసరిగా వోట్ వెయ్యండి
มุมมอง 5128 หลายเดือนก่อน
Please Vote - తప్పనిసరిగా వోట్ వెయ్యండి
అన్న కోసం తమ్ముడు పడే తపనే ఈ పాట
มุมมอง 4668 หลายเดือนก่อน
అన్న కోసం తమ్ముడు పడే తపనే ఈ పాట
AP అంటే - అదృష్టవంతులైన ప్రజలు
มุมมอง 4088 หลายเดือนก่อน
AP అంటే - అదృష్టవంతులైన ప్రజలు
Snowflake - Code Deployment/Migration Using GitHub Schema Change
มุมมอง 6K9 หลายเดือนก่อน
Snowflake - Code Deployment/Migration Using GitHub Schema Change
Snowflake - Alerts and Email Notifications
มุมมอง 3.8K9 หลายเดือนก่อน
Snowflake - Alerts and Email Notifications
Snowflake - Creating a Trial Account and SnowSight UI Overview
มุมมอง 12K9 หลายเดือนก่อน
Snowflake - Creating a Trial Account and SnowSight UI Overview
Snowflake - Snowpro Core Certification Details
มุมมอง 4.3K10 หลายเดือนก่อน
Snowflake - Snowpro Core Certification Details
Nature is the best Teacher
มุมมอง 29111 หลายเดือนก่อน
Nature is the best Teacher

ความคิดเห็น

  • @kalalshireesha7181
    @kalalshireesha7181 6 ชั่วโมงที่ผ่านมา

    🎉

  • @kalalshireesha7181
    @kalalshireesha7181 12 ชั่วโมงที่ผ่านมา

    Good bro..this is very useful classes bro thank you

  • @rameshvantipalli2363
    @rameshvantipalli2363 วันที่ผ่านมา

    Hi Sir are you going to provide training for the DBT tool?

    • @mrjana520
      @mrjana520 วันที่ผ่านมา

      No

  • @rajareddy7649
    @rajareddy7649 2 วันที่ผ่านมา

    While opening cursor , you have used :deptid but local variables we should use : in SQL statements only right Please clarift

    • @mrjana520
      @mrjana520 วันที่ผ่านมา

      you can use at both places

  • @ArunaMakkena-o6s
    @ArunaMakkena-o6s 2 วันที่ผ่านมา

    Hi sir where can I get that practice queries pls provide those

    • @mrjana520
      @mrjana520 วันที่ผ่านมา

      Hi, You can get all the PPTs and Queries for Practicing along with the videos in Telugu from below Udemy Course for 499 rupees only. You will have lifetime access for this course. My Udemy Course on SQL in Telugu: www.udemy.com/course/sql-dpif/?couponCode=154661378F16163483B7 Use this coupon for Discount: 154661378F16163483B7

  • @srivarshachandan1592
    @srivarshachandan1592 2 วันที่ผ่านมา

    I am working as Salesforce developer currently with apex but I thought it is tough to me .. SQL + data engineer is easy can any one help me with this

    • @mrjana520
      @mrjana520 วันที่ผ่านมา

      I can suggest the upskill based on your current knowledge and experience, that will be easy

  • @adwaydandwate
    @adwaydandwate 2 วันที่ผ่านมา

    How to get the column list from an XML file if it is a complex one. Pls help!

    • @mrjana520
      @mrjana520 วันที่ผ่านมา

      There is a concept called INFER_SCHEMA, I will make a video on that in near future

    • @adwaydandwate
      @adwaydandwate วันที่ผ่านมา

      @mrjana520 Sure pls. Thanks! Hope to see that video soon.

  • @mohanraju-i5q
    @mohanraju-i5q 2 วันที่ผ่านมา

    Explanation and giving detail information super sir

  • @avuthusivavardhanareddy5178
    @avuthusivavardhanareddy5178 3 วันที่ผ่านมา

    Hi janardhan i am facing below error please suggest me over the same { "SQLCODE": 90236, "SQLERRM": "Stored procedure execution error: Unsupported statement type 'temporary STAGE'.", "SQLSTATE": "42601", "create_stage_stmt": "CREATE OR REPLACE TEMPORARY STAGE mydb.external_stage.s3_stage URL = 's3://sivasnowflakebucket/mydata/data/csv/' storage_integration = aws_s3_int file_format = (type=csv skip_header = 1 field_delimiter = ',' empty_field_as_null =TRUE)" }

  • @KRISHNABAKKA-d5g
    @KRISHNABAKKA-d5g 4 วันที่ผ่านมา

    This is the best video on NULL. You will not get this much information on at a place. Thank you Sir.

  • @mohammedvahid5099
    @mohammedvahid5099 5 วันที่ผ่านมา

    Thnk u sir

  • @sravanithudi5639
    @sravanithudi5639 6 วันที่ผ่านมา

    Good evening sir I have a question regarding year. I want to create a table field which has to store only year. Is it possible in snowflake. Can you please guide me

    • @mrjana520
      @mrjana520 5 วันที่ผ่านมา

      if you watch the video fully, there is a function called YEAR(date_field), using this you can extract only year part from a date and can store in a Integer type column

    • @sravanithudi5639
      @sravanithudi5639 5 วันที่ผ่านมา

      @ Good afternoon sir Actually I want to insert only year at the time of inserting values. What is the data type used for that

    • @mrjana520
      @mrjana520 วันที่ผ่านมา

      you can use integer or number

  • @vinodkumark2259
    @vinodkumark2259 7 วันที่ผ่านมา

    Impressive 😅

  • @SaiKrishna-fs5gs
    @SaiKrishna-fs5gs 7 วันที่ผ่านมา

    data was not loaded in the tables through snowpipe and im try to troubleshoot using same approach that you have mentioned in the video ..."Query processed no results" this is im getting ...anyone have any idea about this

    • @mrjana520
      @mrjana520 6 วันที่ผ่านมา

      That means your setup is correct, but seems issue with query, please check the query

  • @mohammedimdaad270
    @mohammedimdaad270 7 วันที่ผ่านมา

    Great explanation, very usefull :) One small query, please someone try to help me -- My snowflake home page is not like it is showing in the video, its totally different. I can't able to follow the class as the options are different in my current snowflake account.

    • @mrjana520
      @mrjana520 6 วันที่ผ่านมา

      Watch snowsight video, you can understand it..

  • @ravi_boddapati
    @ravi_boddapati 7 วันที่ผ่านมา

    sir i don't know my account locator. Now how can I get it? please help

    • @mrjana520
      @mrjana520 6 วันที่ผ่านมา

      Watch that video fully, you can get your locator from that video

  • @anushagorijavolu2341
    @anushagorijavolu2341 7 วันที่ผ่านมา

    Thank you so much sir for your videos.

  • @sambasiva3920
    @sambasiva3920 9 วันที่ผ่านมา

    hello, sir can you please share all the functions synatxes used in snowflake .like date ,time ...etc functions

    • @mrjana520
      @mrjana520 8 วันที่ผ่านมา

      All.the functiona are available in my SQL playlist, pls check

  • @yogeshkarbhari5757
    @yogeshkarbhari5757 14 วันที่ผ่านมา

    I am interested learn snowflake. But language is not in english. Can you provide please

    • @mrjana520
      @mrjana520 14 วันที่ผ่านมา

      This video is in Telugu but the course is completely in English My Snowflake Udemy Course: www.udemy.com/course/snowflake-complete-course-for-clearing-interviews/?couponCode=79FF8DAB2E28FD4D602A Use the coupon below to get a discount. Coupon: 79FF8DAB2E28FD4D602A

  • @madhavikasthuri7850
    @madhavikasthuri7850 15 วันที่ผ่านมา

    How to download ppts sir

    • @mrjana520
      @mrjana520 14 วันที่ผ่านมา

      Hi, You can get all the PPTs and Queries for Practicing along with the videos in Telugu from below Udemy Course for 499 rupees only. You will have lifetime access for this course. My Udemy Course on SQL in Telugu: www.udemy.com/course/sql-dpif/?couponCode=154661378F16163483B7 Use this coupon for Discount: 154661378F16163483B7

  • @VM-du4gt
    @VM-du4gt 15 วันที่ผ่านมา

    Nice weather capturing pics Janardhan garu

  • @nagarajunaik2561
    @nagarajunaik2561 16 วันที่ผ่านมา

    Sir please provide pdf 😢

    • @mrjana520
      @mrjana520 16 วันที่ผ่านมา

      reach me on jana.snowflake2@gmail.com

  • @prabhakarravi2671
    @prabhakarravi2671 17 วันที่ผ่านมา

    Thank you so much sir

  • @muralikrishna-gk4hx
    @muralikrishna-gk4hx 20 วันที่ผ่านมา

    Hi sir when i tried to update data it was not tracking the old record .only maintaining new data I am using my steam append_only=false And show _initial_rows=True

    • @mrjana520
      @mrjana520 19 วันที่ผ่านมา

      may be you are doing something wrong, please retry and check..

    • @muralikrishna-gk4hx
      @muralikrishna-gk4hx 19 วันที่ผ่านมา

      When i am using steam consuming it is working Just i am using simple update It takes only new update row.

    • @muralikrishna-gk4hx
      @muralikrishna-gk4hx 19 วันที่ผ่านมา

      If possible please share steam consuming connect

    • @mrjana520
      @mrjana520 16 วันที่ผ่านมา

      Queries are explained in that video, please watch entire video first and understanad the concept

    • @mrjana520
      @mrjana520 16 วันที่ผ่านมา

      post your queries here

  • @sambasiva3920
    @sambasiva3920 20 วันที่ผ่านมา

    Hi sir commonly total credits we caluculated for 100% correct ? in that case if we set suspend immidiate at 110% is possible ? if the time period reaches i t reset to "zero"

  • @ShilpaVupputholla
    @ShilpaVupputholla 21 วันที่ผ่านมา

    Will you please share the sample data sir

    • @mrjana520
      @mrjana520 21 วันที่ผ่านมา

      Hi, You can get all the PPTs and Queries for Practicing along with the videos in Telugu from below Udemy Course for 499 rupees only. You will have lifetime access for this course. My Udemy Course on SQL in Telugu: www.udemy.com/course/sql-dpif/?couponCode=154661378F16163483B7 Use this coupon for Discount: 154661378F16163483B7

  • @sudhakarreddys8172
    @sudhakarreddys8172 22 วันที่ผ่านมา

    Very helpful information, thanks

  • @karthikg521
    @karthikg521 22 วันที่ผ่านมา

    helpfull information, Thanks buddy

  • @rallabandivijayvijay5456
    @rallabandivijayvijay5456 22 วันที่ผ่านมา

    hi sir what ever u thought is that enough to appear for snow pro certification exam or we have to learn more.

    • @mrjana520
      @mrjana520 21 วันที่ผ่านมา

      Watch this video for full details on Certification certification: th-cam.com/video/Vm4M-1Hfuw8/w-d-xo.html

  • @nagarajuapex
    @nagarajuapex 22 วันที่ผ่านมา

    Hi. Please let me know if you are dealing with full course on snowflake

    • @mrjana520
      @mrjana520 21 วันที่ผ่านมา

      Not now

  • @mahaadevA-ut8ru
    @mahaadevA-ut8ru 22 วันที่ผ่านมา

    sir udemy lo unna content and youtube lo unna content same kada sir ? why to purchase again there ?

    • @mrjana520
      @mrjana520 21 วันที่ผ่านมา

      If you want PPTs, Queries and Sample data files then only go for Udemy otherwise TH-cam is enough

  • @BBR999
    @BBR999 22 วันที่ผ่านมา

    Sir, Can do a some videos snowflake with informatica (ETL)topics

    • @mrjana520
      @mrjana520 21 วันที่ผ่านมา

      It is difficult to get Informatica license

  • @yodotirupendranath5437
    @yodotirupendranath5437 24 วันที่ผ่านมา

    Hi Janardhan Your explnation is awsome, I have Brought udemu snowflake courseee too Can you make a videoo on Dynamic tables , new feature on Snowflake , Other videos on TH-cam is not informative 😍

    • @mrjana520
      @mrjana520 23 วันที่ผ่านมา

      sure, will do in near future

  • @shaikyusuf4932
    @shaikyusuf4932 26 วันที่ผ่านมา

    Hi Sir, Can you please attach the Raw data (json) file that would be very help!!.

  • @jakeershaik-s7c
    @jakeershaik-s7c 26 วันที่ผ่านมา

    Meeru use chese sample data akkada undi sir,memu practies cheyali anty need same data what ever your using can please tell us

    • @mrjana520
      @mrjana520 26 วันที่ผ่านมา

      Hi, You can get all the PPTs and Queries for Practicing along with the videos in Telugu from below Udemy Course for 499 rupees only. You will have lifetime access for this course. My Udemy Course on SQL in Telugu: www.udemy.com/course/sql-dpif/?couponCode=154661378F16163483B7 Use this coupon for Discount: 154661378F16163483B7

    • @mahaadevA-ut8ru
      @mahaadevA-ut8ru 22 วันที่ผ่านมา

      @@mrjana520 sir udemy lo unna content and youtube lo unna content same kada sir ? why to purchase again there ?

  • @Ashu23200
    @Ashu23200 27 วันที่ผ่านมา

    Hello Sir! Is this video added in udemy course as well. I have purchased it. I didn't found there and it was last updated Oct 2024

    • @mrjana520
      @mrjana520 26 วันที่ผ่านมา

      It is available in Snowflake Scripting - Stored Procedures Udemy course

  • @mahaadevA-ut8ru
    @mahaadevA-ut8ru 27 วันที่ผ่านมา

    sql sample files ichanu anaaru ! yekkada sir ?

    • @mrjana520
      @mrjana520 27 วันที่ผ่านมา

      They are available in the Udemy course

  • @walkwithsunni3901
    @walkwithsunni3901 27 วันที่ผ่านมา

    Hello Sir! I am unable to find your complete SQL course on Udemy. I am using my organization's credentials for Udemy.

    • @mrjana520
      @mrjana520 27 วันที่ผ่านมา

      It is not available in Udemy business accounts

    • @walkwithsunni3901
      @walkwithsunni3901 25 วันที่ผ่านมา

      Sir where can i get the data to practice for SQL?

    • @tarigopulaayyappa
      @tarigopulaayyappa 24 วันที่ผ่านมา

      ​​@@mrjana520 May i know how is calls/market on snow flake now? Can we get 20 lacs package for 7 years exp(5 years exp on ETL datastsge and 2 years exp on snowflake)?

    • @mrjana520
      @mrjana520 23 วันที่ผ่านมา

      yes, you can

  • @prasadmuthyala9625
    @prasadmuthyala9625 27 วันที่ผ่านมา

    Finally got great snowflake content TH-cam channel ❤

  • @NitinKumar_up_se
    @NitinKumar_up_se 29 วันที่ผ่านมา

    great explain. how to get these files for a good practice.

  • @jhansibode2615
    @jhansibode2615 29 วันที่ผ่านมา

    sir ,when i am using case 2 example copy statement ,when i remove "skip header " field copy command was not executed ,when i checked chatgpt it is saying select with "file" we should not use .Snowflake may indeed accept the syntax of specifying files=('OrderDetails.csv') alongside the SELECT statement in some cases. However, this is not typical or fully documented behavior in Snowflake, as it generally expects either a direct file reference or a SELECT statement but not both simultaneously. query which i used:COPY INTO MYDB.PUBLIC.ORDERS_EX FROM (select s.$1, s.$2 from @MYDB.external_stages.aws_ext_stage s) file_format= (type = csv field_delimiter=',' skip_header=1) files=('OrderDetails.csv') please help me with the answer.

    • @mrjana520
      @mrjana520 26 วันที่ผ่านมา

      if the file contains column names in the first row then you should use SKIP_HEADER=1 to skip that first row, other wise the copy command will try to process the process the first and may fail with datatype issues.

  • @charancheery6530
    @charancheery6530 หลายเดือนก่อน

    Hi bro i want a sql queries data?

    • @mrjana520
      @mrjana520 หลายเดือนก่อน

      Hi, You can get all the PPTs and Queries for Practicing along with the videos in Telugu from below Udemy Course for 499 rupees only. You will have lifetime access for this course. My Udemy Course on SQL in Telugu: www.udemy.com/course/sql-dpif/?couponCode=SQL221020241035

  • @vijaypradeep8315
    @vijaypradeep8315 หลายเดือนก่อน

    BRO TIS REALY HELLPED ME BRO THANKS A LOT BRO

  • @middleclassporadu8274
    @middleclassporadu8274 หลายเดือนก่อน

    🙏🙏🙏🙏 thank you so much sir

  • @gadgetswonder664
    @gadgetswonder664 หลายเดือนก่อน

    Hello Sir, na doubt enti ante Snowflake trail version lo practice chesanu, oka vella company lo oke account meeda work cheyala or veetiki vere separate access control undha. what if i work in project how to use paid version

    • @mrjana520
      @mrjana520 หลายเดือนก่อน

      Snowflake trail ela vuntado, company account kuda same alage vuntadi. Just nee user ki assign chesina roles ni batti konchem UI change avutundi anthe.

  • @vshannkarind
    @vshannkarind หลายเดือนก่อน

    Hi Bro, I have around 12 CTE's with same logic , only difference is start and end date coulmns are different ,how to use object construct with Array concept in Snowflake or most optimized method in Snowflake?

    • @mrjana520
      @mrjana520 หลายเดือนก่อน

      1. Then write a UDF with start and end date as params and use that function in logic. 2. Will do a video on Object construct in near future.

    • @vshannkarind
      @vshannkarind หลายเดือนก่อน

      @mrjana520 thank you

  • @Achive-Sucess
    @Achive-Sucess หลายเดือนก่อน

    Thanks bro for this wonderfull video it is helps lot of us plz keep upload

  • @nagaa225
    @nagaa225 หลายเดือนก่อน

    How manually process in prod if few files not processed

    • @mrjana520
      @mrjana520 หลายเดือนก่อน

      Before the identify why the files were not processed and fix the issue, the files will be processed immediately. Or you can simply execute the copy command inside the pipe definition.

  • @nagaa225
    @nagaa225 หลายเดือนก่อน

    Who will takecare of archiving file once it is loaded into snowflake table

    • @mrjana520
      @mrjana520 หลายเดือนก่อน

      You can set up auto archive mechanism from cloud side or you can manually do it in regular intervals.