Semi Structure Data Concepts Snowflake | Sample Questions | SnowPro Certification

[@ronakforyou1]

Thank you for great video. @13:41 question#11 should say "valid data type"

[@DataEngineering]

You can fetch additional detail from snowflake docs and it claims these data types valid date type. docs.snowflake.com/en/sql-reference/data-types-semistructured.html#data-types Thank you 🙏 for watching my video and sharing your query. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. 🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI 🌐 SnowPro Guide ➥ bit.ly/35S7Rcb 🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq 🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@harryvlr]

Great videos. Under the 'Unsupported Data Type', you have mentioned max size for Varchar as 16 MB compressed, i guess it is a typo it should be '16 MB uncompressed', kindly check.

[@DataEngineering]

You are right ...

[@adarshnamdev3495]

@5:01, the first point says "Objects are used...." does the term 'Object' refers to the part of data present under the Variant column ??

[@DataEngineering]

Thank you 🙏 for watching my video and sharing your query. Any semi-structure data type is wrapped under data type variant. How to access it depends on what is undere the hood. So you are right when we refer the object means the underlying data here. 📒 📚 📒 📚 📒 📚 📒 📚 📒 📚 I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. And please share your constructive feedback so I can improvise my content and help the snowflake and data engineering community. 🚀 Complete Guide + Question Dump + Revised Syllabus 🚀 ------------------------------------------------------- 🌐 SnowPro Guide -> bit.ly/35S7Rcb 🌐 Revised Jan 2021 Syllabus -> bit.ly/3tqOkJb 🌐 SnowPro Practice Test Playlist of 300 questions -> bit.ly/2ZLQm9E 🚀 You can also follow Data Engineering Channel 🚀 -------------------------------------------------- 🌐 Twitter -> twitter.com/de_simplified 🌐 Facebook -> fb.me/dataengineeringsimplified 🌐 GitHub -> github.com/TopperTips 🌐 Website -> toppertips.com

[@dailycryptosportsnews1545]

What does this mean " explicit typed object"? What are these , can someone please elaborate?

[@DataEngineering]

Thank you @Anmol Pandey 🙏 for watching my video and sharing your query. In the programming world, an object can wrap another object and we can specify what kind of objects they are or what kind of data structure they are. For example, if I have a map that stores employee name as key and employee address object as value and that is possible in a programming language like Java, however in snowflake, I can not explicitly indicate that it is an address data structure and everything is indicated as variant whether it is address or any other string object. Hope this clarifies. 📒 📚 📒 📚 📒 📚 📒 📚 📒 📚 I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. And please share your constructive feedback so I can improvise my content and help the snowflake and data engineering community. 🚀 Complete Guide + Question Dump + Revised Syllabus 🚀 ------------------------------------------------------- 🌐 SnowPro Guide -> bit.ly/35S7Rcb 🌐 Revised Jan 2021 Syllabus -> bit.ly/3tqOkJb 🌐 SnowPro Practice Test Playlist of 300 questions -> bit.ly/2ZLQm9E 🚀 You can also follow Data Engineering Channel 🚀 -------------------------------------------------- 🌐 Twitter -> twitter.com/de_simplified 🌐 Facebook -> fb.me/dataengineeringsimplified 🌐 GitHub -> github.com/TopperTips 🌐 Website -> toppertips.com

[@dailycryptosportsnews1545]

@@DataEngineering Thank you...btw finishing your vides 1 day at a time...

[@DataEngineering]

@@dailycryptosportsnews1545 Superb... feel free to submit your queries via google form, this helps to helps other with specific query. forms.gle/KT9BwZd9b3JJ8s3RA

[@cardionadine7483]

Question #14 to convert a value from Variant, but to_Variant is to convert another data type to Variant, not from Variant. Question #15, is a null value is stored as string 'null' ? can it be sql null instead of a string 'null'?

[@DataEngineering]

Thanks for asking question. You are right, the question #14 is not framed appropriately. Your understanding is right. About null, what snowflake document says "Note that a VARIANT value can be missing (contain SQL NULL), which is different from a VARIANT null value, which is a real value used to represent a null value in semi-structured data. VARIANT null is a true value that compares as equal to itself."

[@cardionadine7483]

@@DataEngineering Thank you for the clarification. Your videos are awesome. Thank you for the upload.