IJBTT

Data Sharing, Disaster Management, and Security Capabilities of Snowflake a Cloud Datawarehouse
	© 2023 by IJCTT Journal
	Volume-71 Issue-2
	Year of Publication : 2023
	Authors : Ravi Kashyap
	DOI :  10.14445/22312803/IJCTT-V71I2P112

How to Cite?

Ravi Kashyap, "Data Sharing, Disaster Management, and Security Capabilities of Snowflake a Cloud Datawarehouse," International Journal of Computer Trends and Technology, vol. 71, no. 2, pp. 78-86, 2023. Crossref, https://doi.org/10.14445/22312803/IJCTT-V71I2P112

Abstract
Data is a valuable resource once provided in the proper context; data becomes information to make high-quality and quick business decisions. In today’s world, an important factor that drives a successful organization is gathering data that can be analyzed to gain greater insights into the business and enable new opportunities allowing the business to innovate products/services based on consumer preference. Organizations leverage data to increase customer satisfaction, maximize profitability, and deliver products and services to customers. While information has always been an important asset for an organization, it has never been as critical earlier as it is in business today. Any interruption in data accessibility, lack of adequate data security practices and data breaches can lead to serious financial and legal implications. It is not always possible for organizations to avoid disasters; however, having disaster recovery plans and effective data security strategies can help in minimizing the potential damage and can also completely avoid it. The data warehouse, or enterprise data warehouse (EDW), is an organization's core analytics system that aggregates data from different sources system into a single data warehouse to support data analysis, data mining, machine learning, and artificial intelligence (AI). Choosing a data platform that can handle massive volumes of big data, high speeds, and reliability, not to mention ease of use, is a top priority for any business as they struggle to pull the right information from their data. Snowflake is the most popular solution which supports multi-cloud infrastructure environments such as Amazon Web Services (AWS), Microsoft Azure (Azure) and Google Cloud Platform (GCP). It is a highly scalable cloud data warehouse “as-a-service”, enabling users to focus on analyzing data and providing a multilayered security architecture to protect customer data with replication and failover/failback functionality. This paper aims to evaluate Snowflake's capabilities for data sharing within and outside an organization, disaster management, data security, and handling of structured and semi-structured data loads and utilize them in cloud-based reporting solutions

Keywords
Business intelligence, Enterprise reporting, Analytics cloud, Snowflake data sharing, Data warehousing, Disaster management, Data security.

Reference

[1] Baljit Singh, "Enterprise Reporting on SAP S/4HANA Using Snowflake As Cloud Datawarehouse," International Journal of Computer Trends and Technology, vol. 71, no. 1, pp. 45-49, 2023. Crossref, https://doi.org/10.14445/22312803/IJCTT-V71I1P107
[2] Naga Mallika Gunturu, "Enterprise API Transformation: Driving Towards API Economy," International Journal of Computer Trends and Technology, vol. 70, no. 6, pp. 44-50, 2022. Crossref, https://doi.org/10.14445/22312803/IJCTT-V70I6P105
[3] The Snowflake Website, 2020. [Online]. Available: https://docs.snowflake.com/en/?_ga=2.131591436.2086032114.1673908722- 1347278072.1673734864.
[4] The SAP Website, 2022. [Online]. Available: https://help.sap.com/docs/sap_hana_platform/4505d0bdaf4948449b7f7379d24d0f0d/bc18c37df9154cb0bfacad4b045f7c49.html
[5] The SAP Website, 2022 [Online]. Available: https://community.sap.com/topics/bw4-hana/hana-2-0
[6] Sikender Mohsienuddin Mohammad, “Cloud Computing in IT and How It’s Going to Help United States Specifically,” International Journal of Computer Trends and Technology, vol. 67, no. 10, pp. 103-109, 2019. Crossref, https://doi.org/10.14445/22312803/IJCTTV67I10P118
[7] Haleem Khan, and Yu Jiong, “Cloud Computing Effect on Enterprises in Terms of Cost,” International Journal of Computer Trends and Technology, vol. 67, no. 5, pp. 14-19, 2019. Crossref, https://doi.org/10.14445/22312803/IJCTT-V67I5P103
[8] Yonah Etene, and Josphat M. Karani, “Performance in Layered Software Architectures: the Case of Customized Organizational Software,” International Journal of Computer Trends and Technology, vol. 67, no. 12, pp. 15-19, 2019.
[9] Marcel Chibuzor Amaechi, Matthias Daniel, and Bennett. E. O, “Data Storage Management in Cloud Computing Using Deduplication Technique,” SSRG International Journal of Computer Science and Engineering, vol. 7, no. 7, pp. 1-7, 2020. Crossref, https://doi.org/10.14445/23488387/IJCSE-V7I7P101
[10] G. Anitha et al., “A Survey of Security Issues in IIOT and Fault Identification Using Predictive Analysis in Industry 4.0,” International Journal of Engineering Trends and Technology, vol. 70, no. 12, pp. 99-108, 2022. Crossref, https://doi.org/10.14445/22315381/IJETTV70I12P211
[11] Twinkle Graf.F, and Mrs.Prema. P, “Secure Collaborative Privacy in Cloud Data with Advanced Symmetric Key Block Algorithm,” SSRG International Journal of Computer Science and Engineering, vol. 2, no. 2, pp. 40-44, 2015. Crossref, https://doi.org/10.14445/23488387/IJCSE-V2I2P109
[12] Sidath Weerasinghe, and Indika Perera, “Taxonomical Classification and Systematic Review on Microservices,” International Journal of Engineering Trends and Technology, vol. 70, no. 3, pp. 222-233, 2022. Crossref, https://doi.org/10.14445/22315381/IJETTV70I3P225
[13] Manjunatha. S, and Dr. Suresh. L, “A Study on Consolidation of Data Servers in Virtualized Cloud Atmosphere,” SSRG International Journal of Computer Science and Engineering, vol. 6, no. 11, pp. 47-50, 2019. Crossref, https://doi.org/10.14445/23488387/IJCSEV6I11P110
[14] Dr. P. K. Rai, and Rajesh Kumar Bunkar, “Architectural Data Security in Cloud Computing,” International Journal of Computer & Organization Trends, vol. 4, no. 4, pp. 23-27, 2014. Crossref, https://doi.org/10.14445/22492593/IJCOT-V10P306
[15] N. Madhavi Latha, and Y. Pavan Narasimha Rao, “A Novel Secured Data Transmission Model with Load Balancing for Cloud Computing,” International Journal of Computer & Organization Trends, vol. 6, no. 1, pp. 45-50, 2016. Crossref, https://doi.org/10.14445/22492593/IJCOT-V29P304
[16] Disaster Management. [Online]. Available: https://docs.snowflake.com/en/user-guide/replication-intro.html
[17] Snowflake Security. [Online]. Available: https://www.snowflake.com/trending/intro-to-data-security
[18] Statistics and Machine Learning at Scale.