Snowflake: A Comprehensive Review of a Modern Data Warehousing Platform

Authors

  • Praveen Borra Computer Science, Florida Atlantic University, Boca Raton USA Author

DOI:

https://doi.org/10.5281/zenodo.11617628

Keywords:

Snowflake, Data warehousing, Cloud computing, Scalability, Architecture, Performance, Security, Features, Semi-structured data, Automatic scaling

Abstract

Snowflake represents a state-of-the-art data warehousing platform, fundamentally altering the landscape of data management within cloud environments. This paper offers an exhaustive examination of Snowflake, delving into its structural intricacies, pivotal functionalities, competitive edges, and far-reaching implications for the sector. By meticulously scrutinizing its inventive methodologies for data retention, processing, and adaptability, this analysis elucidates Snowflake's rise to prominence as a leader in cloud-centric data management solutions. Moreover, it sheds light on Snowflake's transformative influence, precipitating a shift in how enterprises harness and exploit their data resources to steer strategic decisions and attain a competitive edge amidst the ever-evolving business milieu. Snowflake's agile architecture and user-centric design underscore its commitment to empowering businesses with the tools they need to thrive in today's data-driven landscape.

References

Bell, F., Chirumamilla, R., Joshi, B.B., Lindstrom, B., Soni, R., Videkar, S. (2022). Semi-structured Data in Snowflake. In: Snowflake Essentials. Apress, Berkeley, CA.

Themis Melissaris, Kunal Nabar, Rares Radut, Samir Rehmtulla, Arthur Shi, Samartha Chan-drashekar, and Ioannis Papapanagiotou. 2022. Elastic cloud services: scaling snowflake's control plane. In Proceedings of the 13th Symposium on Cloud Computing (SoCC '22). Association for Computing Machinery, New York, NY, USA, 142–157.

https://learn.microsoft.com/en-us/fabric/get-started/whats-new

Sururah A. Bello, Lukumon O. Oyedele, Olugbenga O. Akinade, Muhammad Bilal, Juan Manuel Davila Delgado, Lukman A. Akanbi, Anuoluwapo O. Ajayi, Hakeem A. Owolabi, Cloud computing in construction industry: Use cases, benefits and challenges, Automation in Construction, Volume 122,2021,103441, ISSN 0926-5805 https://learn.microsoft.com/en-us/fabric/get-started/icons

Mohammed Sadeeq, M., Abdulkareem, N. M. ., Zeebaree, S. R. M. ., Mikaeel Ahmed, D. ., Saifullah Sami, A. ., & Zebari, R. R. (2021). IoT and Cloud Computing Issues, Challenges and Opportunities: A Review. Qubahan Academic Journal, 1(2), 1–7. https://learn.microsoft.com/en-us/fabric/

A. K. Sandhu, "Big data with cloud computing: Discussions and challenges," in Big Data Mining and Analytics, vol. 5, no. 1, pp. 32-40, March 2022, doi: 10.26599/BDMA.2021.9020016.

B. Alouffi, M. Hasnain, A. Alharbi, W. Alosaimi, H. Alyami and M. Ayaz, "A Systematic Literature Review on Cloud Computing Security: Threats and Mitigation Strategies," in IEEE Access, vol. 9, pp. 57792-57807, 2021, doi: 10.1109/ACCESS.2021.3073203.

PanJun Sun, Security and privacy protection in cloud computing: Discussions and challenges, Journal of Network and Computer Applications,Volume 160, 2020, 102642, ISSN 1084-8045, https://doi.org/10.1016/j.jnca.2020.102642.

D. A. Shafiq, N. Z. Jhanjhi, A. Abdullah and M. A. Alzain, "A Load Balancing Algorithm for the Data Centres to Optimize Cloud Computing Applications," in IEEE Access, vol. 9, pp. 41731-41744, 2021, doi: 10.1109/ACCESS.2021.3065308.

Taleb, Nasser, and Elfadil A. Mohamed. "Cloud computing trends: A literature review." Academic Journal of Interdisciplinary Studies 9, no. 1 (2020).

Shukur, Hanan, Subhi Zeebaree, Rizgar Zebari, Diyar Zeebaree, Omar Ahmed, and Azar Salih. "Cloud computing virtualization of resources allocation for distributed systems." Journal of Applied Science and Technology Trends 1, no. 2 (2020): 98-105.

Gupta, Bulbul, Pooja Mittal, and Tabish Mufti. "A review on amazon web service (aws), microsoft azure & google cloud platform (gcp) services." In Proceedings of the 2nd International Conference on ICT for Digital, Smart, and Sustainable Development, ICIDSSD 2020, 27-28 February 2020, Jamia Hamdard, New Delhi, India. 2021.

Talha, Muhammad, Mishal Sohail, and Hajar Hajji. "Analysis of research on amazon AWS cloud computing seller data security." International Journal of Research in Engineering Innovation 4, no. 3 (2020): 131-136.

Kaushik, Prakarsh, Ashwin Murali Rao, Devang Pratap Singh, Swati Vashisht, and Shubhi Gupta. "Cloud computing and comparison based on service and performance between Amazon AWS, Microsoft Azure, and Google Cloud." In 2021 International Conference on Technological Ad-vancements and Innovations (ICTAI), pp. 268-273. IEEE, 2021.

Saraswat, Manish, and R. C. Tripathi. "Cloud computing: Comparison and analysis of cloud service providers-AWs, Microsoft and Google." In 2020 9th international conference system modeling and advancement in research trends (SMART), pp. 281-285. IEEE, 2020.

Saraswat, Manish, and R. C. Tripathi. "Cloud computing: Comparison and analysis of cloud service providers-AWs, Microsoft and Google." In 2020 9th international conference system modeling and advancement in research trends (SMART), pp. 281-285. IEEE, 2020.

https://docs.snowflake.com/

https://docs.snowflake.com/en/user-guide/intro-key-concepts

https://docs.snowflake.com/en/user-guide/intro-cloud-platforms

https://docs.snowflake.com/en/user-guide/intro-regions

https://docs.snowflake.com/en/user-guide-intro

https://docs.snowflake.com/en/guides

https://docs.snowflake.com/en/developer

https://docs.snowflake.com/en/user-guide/data-lifecycle

https://docs.snowflake.com/en/user-guide/data-cdp

Downloads

Published

12-08-2022

How to Cite

Praveen Borra. (2022). Snowflake: A Comprehensive Review of a Modern Data Warehousing Platform. International Journal of Computer Science and Information Technology Research , 3(1), 11-16. https://doi.org/10.5281/zenodo.11617628