- 270
- 1 457 363
Janardhan Reddy Bandi
India
เข้าร่วมเมื่อ 30 ก.ย. 2011
My channel is about
1. Snowflake Tutorial
2. SQL Tutorial
3. My Kids Funny Videos
4. My Writings
1. Snowflake Tutorial
2. SQL Tutorial
3. My Kids Funny Videos
4. My Writings
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/
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 - 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 - తప్పనిసరిగా వోట్ వెయ్యండి
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
🎉
Good bro..this is very useful classes bro thank you
Hi Sir are you going to provide training for the DBT tool?
No
While opening cursor , you have used :deptid but local variables we should use : in SQL statements only right Please clarift
you can use at both places
Hi sir where can I get that practice queries pls provide those
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
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
I can suggest the upskill based on your current knowledge and experience, that will be easy
How to get the column list from an XML file if it is a complex one. Pls help!
There is a concept called INFER_SCHEMA, I will make a video on that in near future
@mrjana520 Sure pls. Thanks! Hope to see that video soon.
Explanation and giving detail information super sir
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)" }
This is the best video on NULL. You will not get this much information on at a place. Thank you Sir.
Thnk u sir
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
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
@ Good afternoon sir Actually I want to insert only year at the time of inserting values. What is the data type used for that
you can use integer or number
Impressive 😅
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
That means your setup is correct, but seems issue with query, please check the query
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.
Watch snowsight video, you can understand it..
sir i don't know my account locator. Now how can I get it? please help
Watch that video fully, you can get your locator from that video
Thank you so much sir for your videos.
hello, sir can you please share all the functions synatxes used in snowflake .like date ,time ...etc functions
All.the functiona are available in my SQL playlist, pls check
I am interested learn snowflake. But language is not in english. Can you provide please
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
How to download ppts sir
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
Nice weather capturing pics Janardhan garu
Sir please provide pdf 😢
reach me on jana.snowflake2@gmail.com
Thank you so much sir
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
may be you are doing something wrong, please retry and check..
When i am using steam consuming it is working Just i am using simple update It takes only new update row.
If possible please share steam consuming connect
Queries are explained in that video, please watch entire video first and understanad the concept
post your queries here
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"
Will you please share the sample data sir
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
Very helpful information, thanks
helpfull information, Thanks buddy
hi sir what ever u thought is that enough to appear for snow pro certification exam or we have to learn more.
Watch this video for full details on Certification certification: th-cam.com/video/Vm4M-1Hfuw8/w-d-xo.html
Hi. Please let me know if you are dealing with full course on snowflake
Not now
sir udemy lo unna content and youtube lo unna content same kada sir ? why to purchase again there ?
If you want PPTs, Queries and Sample data files then only go for Udemy otherwise TH-cam is enough
Sir, Can do a some videos snowflake with informatica (ETL)topics
It is difficult to get Informatica license
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 😍
sure, will do in near future
Hi Sir, Can you please attach the Raw data (json) file that would be very help!!.
Meeru use chese sample data akkada undi sir,memu practies cheyali anty need same data what ever your using can please tell us
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
@@mrjana520 sir udemy lo unna content and youtube lo unna content same kada sir ? why to purchase again there ?
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
It is available in Snowflake Scripting - Stored Procedures Udemy course
sql sample files ichanu anaaru ! yekkada sir ?
They are available in the Udemy course
Hello Sir! I am unable to find your complete SQL course on Udemy. I am using my organization's credentials for Udemy.
It is not available in Udemy business accounts
Sir where can i get the data to practice for SQL?
@@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)?
yes, you can
Finally got great snowflake content TH-cam channel ❤
great explain. how to get these files for a good practice.
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.
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.
Hi bro i want a sql queries data?
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
BRO TIS REALY HELLPED ME BRO THANKS A LOT BRO
🙏🙏🙏🙏 thank you so much sir
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
Snowflake trail ela vuntado, company account kuda same alage vuntadi. Just nee user ki assign chesina roles ni batti konchem UI change avutundi anthe.
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?
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.
@mrjana520 thank you
Thanks bro for this wonderfull video it is helps lot of us plz keep upload
How manually process in prod if few files not processed
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.
Who will takecare of archiving file once it is loaded into snowflake table
You can set up auto archive mechanism from cloud side or you can manually do it in regular intervals.