Hi Sir, Your videos are really helpful. Great Explanation with real time examples. I'm really happy to share with you that I got job with 100% hike. Just because of your classes I was able to crack the interview. I suggest all of you who ever wants to learn snowflake from basic and also in interview point view you will get all the questions here. This is the best channel I can say.... Thanks again!!!
Hi @ Janardhan reddy all because of your snowflake videos I got a 2 job offers really thanks a lot from bottom of my heart it's was 150% Hike from existing salary..❤❤❤
Very well crafted Scenario based snowflake questions. Thank you! However I do have a doubt on Quest No. 07. You mentioned after 1000rows inserted in table B storage cost will be only for those thousand records which are not available in the original table and wherever Thousandrecords we have inserted there will be a storage cost for only those thousand rowsfrom the table B for the rest onemillion records there will be no storagecost. I would like to know what if the original table A is dropped and we insert 1000 more rows to table B. How the storage cost will be for the table B?
Thanks for making this Video. Very helpful. Is the roboquery only the option for converting DDL queries or converting stored procs functions etc. I mean to ask sometimes we do migrations that time source script won't work in Snowflake, we can't change each and every line in the code, is there any option for this situation?
Robo query, Snowflake stored proc, Python script there are many ways to convert the DDL. But it is impossible to convert a complex query or complex procedure as it is to snowflake, those tools can help you to some extent but after that you have to make changes again. I suggest convert the queries manually and carefully, it won't take much time because 80% of the sql is similar to other databases.
Hi I've a query. I have a requirement where a new file comes to my local system every day at a specific location. I have to create an internal stage on Snowflake and have to exceute put command on snowsql to upload this file data into snowflake table . I want to orchestrate this daily. How to achieve this
I have a few questions 1) what is the size of datawarehouse in your company ans) 10TB 2) what schema is your company using and how many facts and dimensions tables are there if it is star schema and snowflake ans) we used snowflake schema And we have 30dimensions and 5 fact tables in your company Is it ok to answer like this?
What happens when DELETES or updates to table A are applied in 0 copy cloning scenario? My guess is if we delete 1000 rows from table A the pointers are removed but will remain on Table B hence 0 cost? In the update scenario where we update 1000 rows in table A the pointers are directed to the updated partitions but the original un-updates partitions remain on table b therefore cost will be incurred?
If you clone a table, suppose B is cloned from A and if you delete or update records in table A then only for those records there will be cost associated in Table B.
Could you please tell me what are the major challenges while migrating from teradata to snowflake and project explanation regarding the same .which wooukd be helpful in interviews.
@@mrjana520hi bro really ur videos r very helpfull fr freshers, iam a bcom student bt iam learning this data analytics, so plz guide fr freshers what is r the question they may ask in interview abt snowflake, SQL queries plz
Never seen such way of explaination. Many Thanks to you.
Hi Sir, Your videos are really helpful. Great Explanation with real time examples. I'm really happy to share with you that I got job with 100% hike. Just because of your classes I was able to crack the interview. I suggest all of you who ever wants to learn snowflake from basic and also in interview point view you will get all the questions here. This is the best channel I can say.... Thanks again!!!
Congratulations and thank you
Hi @ Janardhan reddy all because of your snowflake videos I got a 2 job offers really thanks a lot from bottom of my heart it's was 150% Hike from existing salary..❤❤❤
That's great to know, congratulations Sairam
I just watched your snowflake class I got the job now I was planning to do snowflake certification ...
Hi Sairam, I am also preparing for snow flake, can you please share more details your contact number?
Great explanation never seen such a realtime based explanation..can I get more questions and answers.impressed the way your explaining
Your videos are very helpful. Thanks for uploading. Straight to the point and crystal clear. Liked your explanation. Keep uploading.
Thank you
Really Great explanation, Thanks for the time and appreciate your hard work..
You are welcome!
Well explained. Thank you.
excellent!!!
Great content
Very well crafted Scenario based snowflake questions. Thank you!
However I do have a doubt on Quest No. 07.
You mentioned after 1000rows inserted in table B storage cost will be only for those thousand records which are not available in the original table and wherever Thousandrecords we have inserted there will be a storage cost for only those thousand rowsfrom the table B for the rest onemillion records there will be no storagecost.
I would like to know what if the original table A is dropped and we insert 1000 more rows to table B. How the storage cost will be for the table B?
If you delete data from base table A, there will be a storage cost for all records in table B
very useful questions. Thank you.
really very nice explanation bro thank you
Can you share the snowflake project description for interview prepartion.Interviwers expecting more things from me.
Reach me on jana.snowflake2@gmail.com
Thanks for making this Video. Very helpful. Is the roboquery only the option for converting DDL queries or converting stored procs functions etc. I mean to ask sometimes we do migrations that time source script won't work in Snowflake, we can't change each and every line in the code, is there any option for this situation?
Robo query, Snowflake stored proc, Python script there are many ways to convert the DDL. But it is impossible to convert a complex query or complex procedure as it is to snowflake, those tools can help you to some extent but after that you have to make changes again. I suggest convert the queries manually and carefully, it won't take much time because 80% of the sql is similar to other databases.
Thank you for your prompt reply.
Hi
I've a query. I have a requirement where a new file comes to my local system every day at a specific location. I have to create an internal stage on Snowflake and have to exceute put command on snowsql to upload this file data into snowflake table . I want to orchestrate this daily. How to achieve this
You can write a cron job to automate that put command to run daily at particular time
Q2 - What if the actual date is 2022-01-01, then what will be the output of masking.?
it will come as 2022-01-01 only, but the user can't think it as original date right, so no issues..
select 'XX-XX-' ||to_char(current_date(),'yyyy') from dual;
I have a few questions
1) what is the size of datawarehouse in your company
ans) 10TB
2) what schema is your company using and how many facts and dimensions tables are there if it is star schema and snowflake
ans) we used snowflake schema
And we have 30dimensions and 5 fact tables in your company
Is it ok to answer like this?
yes
What happens when DELETES or updates to table A are applied in 0 copy cloning scenario? My guess is if we delete 1000 rows from table A the pointers are removed but will remain on Table B hence 0 cost? In the update scenario where we update 1000 rows in table A the pointers are directed to the updated partitions but the original un-updates partitions remain on table b therefore cost will be incurred?
If you clone a table, suppose B is cloned from A and if you delete or update records in table A then only for those records there will be cost associated in Table B.
@@mrjana520 Thank you! Great video!
Could you please tell me what are the major challenges while migrating from teradata to snowflake and project explanation regarding the same .which wooukd be helpful in interviews.
Reach me on jana.snowflake2@gmail.com
@@mrjana520 I sent a mail
@@nanim8416 Did you get it?
Permanent table name emp we careted tem table emp?
Yes we created but we dropped the table which table is dropped temp table or permanent table??
Always temp table gets priority, so temp table will get dropped
for the first query can row_number be used?
No, we can't use
@@mrjana520hi bro really ur videos r very helpfull fr freshers, iam a bcom student bt iam learning this data analytics, so plz guide fr freshers what is r the question they may ask in interview abt snowflake, SQL queries plz
Find the 2'nd highest sal from the emp table?? With out using dense_rank(),top can u pls explain
I can be reachable on jana.snowflake2@gmail.com
Like this scenario based any thing is there.. please provide link
Hi Can you update Coupon code ? It is not working now.
Updated
Sir how many database support snowflake?? How many data bases used in ur project can u pls explain sir??
I don't understand, snowflake itself is a cloud database, how it can support other databases?
I don't know sir I faced same question in interview sir.. interviewer asking how many database support in your project how many database created
Ok may be it is about databases created in your snowflake project account
@@mrjana520 may be OR it may be how many(what DB's) databases we can migrate to snowflake
Sir please provide pdf 😢
reach me on jana.snowflake2@gmail.com
Hi janardhn contact number plz
can be reachable on jana.snowflake2@gmail.com
SQL is called snowflake so funny 😅😅😅
Have you attended any snowflake interview? So pity 😭😭😭
@@mrjana520 not yet, after your video I came to know it’s a SQL