Topic:

In this comprehensive session, we will dive into the world of Snowflake, a cutting-edge cloud data platform that revolutionizes how we manage and analyze data. The talk will begin by introducing fundamental concepts of cloud databases, with a particular focus on Snowflake’s innovative approach and its unique features.

We will then explore the architecture of Snowflake, detailing its multi-cluster shared data design, which offers unparalleled scalability, performance, and cost-efficiency. Key architectural components such as virtual warehouses, centralized storage, and cloud services will be examined to illustrate how Snowflake optimizes data processing and management in a cloud environment.

The latter part of the session will be hands-on, providing a step-by-step guide to setting up a Snowflake environment. Attendees will learn how to create and configure Snowflake accounts, set up virtual warehouses, load and manage data, and implement best practices for security and performance optimization.

By the end of this session, participants will have a solid grasp of Snowflake’s architecture and practical experience in setting up and managing Snowflake databases. They will leave equipped with the knowledge and skills to harness the full potential of Snowflake for their cloud data initiatives.

Speaker:

Surbhi Pokharna

Surbhi is a data professional with over two decades of architectural/administration experience in the financial domain. Architecting the operationalization aspect in a client-facing role, delivering relational and advanced analytics solutions for large scale Operational and Data Warehouse implementations with focus on learning and innovation remained a constant part of her data journey. Currently she is leading enterprise scale cloud data migrations in SQL Server/Snowflake/Azure SQL/Managed Instance and involved with designing next generation Data Analytics solutions using Snowflake. Surbhi is board member of the New England SQL Server User Group, member of PASS, speaker in PAAS Summit/Snowflake User Group/Azure Data User Groups/Data Saturdays/SQLBits.

Links:

https://www.meetup.com/dba-fundamentals-group/events/299317433