19 сағат бұрын
21 күн бұрын
21 күн бұрын
21 күн бұрын
2 ай бұрын
8 ай бұрын
8 ай бұрын
8 ай бұрын
9 ай бұрын
10 ай бұрын
10 ай бұрын
10 ай бұрын
10 ай бұрын
Жыл бұрын
Пікірлер
@yogeshkarbhari5757 9 сағат бұрын
I am interested learn snowflake. But language is not in english. Can you provide please
@mrjana520 5 сағат бұрын
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 Күн бұрын
How to download ppts sir
@mrjana520 5 сағат бұрын
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 Күн бұрын
Nice weather capturing pics Janardhan garu
@nagarajunaik2561 2 күн бұрын
Sir please provide pdf 😢
@mrjana520 Күн бұрын
reach me on [email protected]
@prabhakarravi2671 3 күн бұрын
Thank you so much sir
@muralikrishna-gk4hx 6 күн бұрын
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 5 күн бұрын
may be you are doing something wrong, please retry and check..
@muralikrishna-gk4hx 5 күн бұрын
When i am using steam consuming it is working Just i am using simple update It takes only new update row.
@muralikrishna-gk4hx 5 күн бұрын
If possible please share steam consuming connect
@mrjana520 Күн бұрын
Queries are explained in that video, please watch entire video first and understanad the concept
@mrjana520 Күн бұрын
post your queries here
@sambasiva3920 6 күн бұрын
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 7 күн бұрын
Will you please share the sample data sir
@mrjana520 7 күн бұрын
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 7 күн бұрын
Very helpful information, thanks
@karthikg521 8 күн бұрын
helpfull information, Thanks buddy
@rallabandivijayvijay5456 8 күн бұрын
hi sir what ever u thought is that enough to appear for snow pro certification exam or we have to learn more.
@mrjana520 7 күн бұрын
Watch this video for full details on Certification certification: kzbin.info/www/bejne/jJ6XfmBnfcuorZo
@nagarajuapex 8 күн бұрын
Hi. Please let me know if you are dealing with full course on snowflake
@mrjana520 7 күн бұрын
Not now
@mahaadevA-ut8ru 8 күн бұрын
sir udemy lo unna content and youtube lo unna content same kada sir ? why to purchase again there ?
@mrjana520 7 күн бұрын
If you want PPTs, Queries and Sample data files then only go for Udemy otherwise KZbin is enough
@BBR999 8 күн бұрын
Sir, Can do a some videos snowflake with informatica (ETL)topics
@mrjana520 7 күн бұрын
It is difficult to get Informatica license
@yodotirupendranath5437 10 күн бұрын
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 KZbin is not informative 😍
@mrjana520 9 күн бұрын
sure, will do in near future
@shaikyusuf4932 12 күн бұрын
Hi Sir, Can you please attach the Raw data (json) file that would be very help!!.
@jakeershaik-s7c 12 күн бұрын
Meeru use chese sample data akkada undi sir,memu practies cheyali anty need same data what ever your using can please tell us
@mrjana520 12 күн бұрын
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 8 күн бұрын
@@mrjana520 sir udemy lo unna content and youtube lo unna content same kada sir ? why to purchase again there ?
@Ashu23200 12 күн бұрын
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 12 күн бұрын
It is available in Snowflake Scripting - Stored Procedures Udemy course
@mahaadevA-ut8ru 13 күн бұрын
sql sample files ichanu anaaru ! yekkada sir ?
@mrjana520 12 күн бұрын
They are available in the Udemy course
@walkwithsunni3901 13 күн бұрын
Hello Sir! I am unable to find your complete SQL course on Udemy. I am using my organization's credentials for Udemy.
@mrjana520 12 күн бұрын
It is not available in Udemy business accounts
@walkwithsunni3901 11 күн бұрын
Sir where can i get the data to practice for SQL?
@tarigopulaayyappa 10 күн бұрын
@@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 9 күн бұрын
yes, you can
@prasadmuthyala9625 13 күн бұрын
Finally got great snowflake content KZbin channel ❤
@NitinKumar_up_se 14 күн бұрын
great explain. how to get these files for a good practice.
@jhansibode2615 15 күн бұрын
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 12 күн бұрын
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 17 күн бұрын
Hi bro i want a sql queries data?
@mrjana520 16 күн бұрын
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 17 күн бұрын
BRO TIS REALY HELLPED ME BRO THANKS A LOT BRO
@middleclassporadu8274 18 күн бұрын
🙏🙏🙏🙏 thank you so much sir
@gadgetswonder664 18 күн бұрын
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 16 күн бұрын
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 18 күн бұрын
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 16 күн бұрын
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 16 күн бұрын
@mrjana520 thank you
@Achive-Sucess 19 күн бұрын
Thanks bro for this wonderfull video it is helps lot of us plz keep upload
@nagaa225 20 күн бұрын
How manually process in prod if few files not processed
@mrjana520 19 күн бұрын
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 20 күн бұрын
Who will takecare of archiving file once it is loaded into snowflake table
@mrjana520 19 күн бұрын
You can set up auto archive mechanism from cloud side or you can manually do it in regular intervals.
@sravanthirapolu6151 25 күн бұрын
Hi sir I try to do query but iam getting syntax error why iam not understanding please help me sir
@mrjana520 23 күн бұрын
1. In which database you are running queries? 2. What is the query you are running 3. What is the error you it is throwing?
@sravanthirapolu6151 22 күн бұрын
@mrjana520 hi sir the way you explain the practical session same I have followed I started my practice in snowflake directly I started doing query which is provided by snowflake only whatever I do iam getting error in it sir what wrong iam doing iam not all understanding
@sravanthirapolu6151 20 күн бұрын
@@mrjana520 hi sir. Can I get your contact so for any doubts I can contact you directly please sir
@mrjana520 19 күн бұрын
what is the error you are getting, if you follow the instructions as it is you won't get any error.
@mrjana520 19 күн бұрын
I can be reachable on [email protected]
@Jahnavi-m7c 27 күн бұрын
Excellent teaching sir
@dineshkumardarling 28 күн бұрын
Why u didnt explain about nvarchar datatype
@mrjana520 28 күн бұрын
because nvarchar is not a common datatype among all databases and is rarely used.
@vinodbarma1753 29 күн бұрын
Bro plsql medha full course cheyande if possible
@mrjana520 28 күн бұрын
Pl/SQL version of Snowflake is already available in Udemy with the name Snowflake Scripting(Stored Procedures). Snowflake Scripting Course: www.udemy.com/course/snowflake-scripting-stored-procedures/?couponCode=31D4DDA7412B91538526 Coupon: 31D4DDA7412B91538526
@ArunNeerudu 29 күн бұрын
We created a temp table same as perm table, then we fetch the data and its come from temp within the session clear but why its coming from temp table? interview question
@mrjana520 29 күн бұрын
Because the temporary table takes precedence in the session over any other table with the same name in the same schema
@SukanyaBodicherla Ай бұрын
Sir mi notepad lo code ma Ela vasthundi 😢
@mrjana520 29 күн бұрын
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 Use this coupon for Discount: JANA-SQL221020241035
@marjoleingelissen8658 Ай бұрын
Very nice! ❤
@badri379 Ай бұрын
Nice
@anjineyulunaik2468 Ай бұрын
I need your number anna
@mrjana520 Ай бұрын
@MadhuReddy-qg7cp Ай бұрын
Excellent info.
@meherkolisetty9297 Ай бұрын
Thanks for explanation.
@meherkolisetty9297 Ай бұрын
Thank you so much for this video.
@nayanayaswanth390 Ай бұрын
sir what about oracle
@mrjana520 Ай бұрын
Watch that video completely, you will get the answer
@vijay-v7f7i Ай бұрын
hello sir.. snowflake only 30 days vastunda? tarvata purchase cheyala?
@mrjana520 Ай бұрын
You can again create a new account for free no need to purchase
@mastanbashashaik8020 Ай бұрын
ఇక్కడ వున్న అన్ని తెలుగు వీడియోలు చూసి నేర్చుకుంటే SQL అంతా వచ్చినట్టేనా. ఉడెమీ (Udemy) లో కూడా same వీడియోలు ఉన్నాయ ? Only PPTs & Queries కోసం Udemy lo join avvaalana? Pls suggest me🙏🙏🙏 practice చెయ్యడం కోసం ఉడెమీ లో join avvaalana ?
@mrjana520 Ай бұрын
Same videos in Udemy also, if you want PPTs and queries then only go for udemy
@tharunkumar619 Ай бұрын
Hi, do you provide real time project for snowflake in Udemy ??
@mrjana520 Ай бұрын
No one provides real time projects
@SWATHIBELLANA-sy6wm Ай бұрын
Sir supre cheputhuannaru
@upendrasai4407 Ай бұрын
hello, I think in example Case 2 asking for top 3 students. Used DENSE_RANK() instead of using RANK(), correct me if I am wrong. Thank you for detail explanation.🙂