Maximizing Data Efficiency: Mastering Snowflake's Databases, Tables, and Views

Please join us on 20th May, 2025 to listen to the topic: Maximizing Data Efficiency: Mastering Snowflake's Databases, Tables, and Views with Surbhi Pokharna

What ~ Toronto Data Professionals Community (Virtual)
When ~ Tuesday, 20th May, 2025

Agenda:

• 6:00 PM Networking and Introduction
• 6:15 PM Topic: Maximizing Data Efficiency: Mastering Snowflake's Databases, Tables, and Views with Surbhi Pokharna
• 7:30 PM End

Where: Online via Microsoft team

Session Details:
In this session, we will explore the foundational elements of Snowflake—databases, tables, and views—and how they work together to enable efficient data storage, organization, and querying. Snowflake’s cloud-native architecture introduces a highly scalable and flexible environment for managing structured data, making it a popular choice for modern data-driven organizations.

We’ll begin by discussing ‘databases’ in Snowflake, which serve as logical containers for schemas, tables, and views, enabling effective data governance and security. Next, we’ll dive into ‘tables’, examining the various types Snowflake offers; such as standard, temporary, and transient tables and how its micro-partitioning technology optimizes storage and query performance for large datasets.

Finally, we’ll cover ‘views’, which provide a virtual representation of data for simplifying complex queries. We’ll compare ‘standard views’ with ‘materialized views’, highlighting their benefits in performance and use cases.

Attendees will gain a clear understanding of how to leverage Snowflake’s databases, tables, and views to design scalable, efficient data solutions that suit a wide range of business needs. This session is ideal for data professionals from beginner to experienced level to build their knowledge of Snowflake’s architecture and enhance their data management practices.

Speaker Bio:
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 and Snowflake Data SuperHero 2025.