Welcome to Discover Workload Edition where we will explore the full capabilities of the Data Cloud including practical demos and walkthroughs. We begin our journey with a high level architectural review examining key capabilities you can use to solve complex data challenges. We complete our introduction by showing you how to get your first Snowflake environment setup in minutes

Join us for this live walkthrough where we look at understanding and working with a Snowflake Data Warehouse. In this practical session you will learn how to navigate the Snowflake interface, basics of working with data in Snowflake, core capabilities and simple scaling of a data warehouse.

Learn the benefits of using Snowflake as your Data Lake to simplify cloud architectures. In this session we examine why Snowflake makes sense for all raw data in one place for all data types. We examine how to unlock benefits that range from inexpensive storage, easy collaboration for teams to work across all data, common tools, access controls, tracking data dependencies and more. This session is a technical primer for those new to working in Snowflake.

Now we have created our warehouse with some basic data we look at a practical lab where we introduce semi-structured and unstructured data. Connecting to and working with these data types traditionally is challenging for both administrators and data analysts. In this demo we walk through working with JSON (semi-structured data) and PDF (unstructured data) to extract and store data which can then be used by Snowsight observe trends and insights. This demo allows you to walk away with the key concepts of centralisation of Data Warehouses and Data Lakes into a single system.

Now you have created your Data Cloud it’s time to discover how easy it is to rapidly build and develop new functionality into your Snowflake environment. In this introduction we will look at the process to build, develop, test and deploy. Hard challenges typical associated with Data Lakes and Data Warehouses are made simple with Snowflake, we step through key concepts that you can leverage in your day to day operations. This really is where the magic happens as you begin to clone, copy, roll back and take advantage of a single data platform.

It’s time to take concepts and put them into action. In this practical demo we take the functionality introduced in the prior ‘continuous integration session’ and see these in action with a real world scenario. We take a guided tour where we clone production data sets to create instant dev environments, apply masking rules, look at securing dev roles, create clusters and finally work with the data for production usage.

Now that you have your first Snowflake platform set up with data ingested, the experienced Snowflake user can minimise the effort to undertake many tasks. We reveal the top 10 productivity ‘hacks’ every Snowflake administrator needs to know. Snowsight, time travel, zero copy cloning, query timeouts, resource monitors and more guaranteed to level up your efficiency.

The dynamic ability that Snowflake provides you is to, well…dynamically scale! For Snowflake administrators, it is important to do this in a way that best optimises cost and maximizes performance. We look at creating resource management visibility, understanding utilisation and planning scalability.

Snowflake is easy to configure and in this session we will make sure you prepared with the top 10 security related topics that are critical to implementing Snowflake at scale. We will discuss a broad range of strategies that will support your goals around data privacy, governance and the secure collaboration of data.

In this walkthrough we look at common examples for governance and security of data in a real world scenario. We cover working across your internal business units, external parties, sharing, marketplaces and more. You will walk away with key technical concepts in Snowflake to solve a number of common business needs.

Everyone wants to optimise their Snowflake queries, but how can you find what’s a problem, and what’s not? In this session, we walk through a methodology for finding the highest impact workloads in your Snowflake environment. This will lead into our next session, where we explore some of the newer functionality available to speed up these queries and reduce total cost.

Using new functionality in Snowflake’s performance arsenal, some specialised data modelling techniques and communication with your Snowflake account team, it’s now more possible than ever to drive high volumes of queries through Snowflake at reasonable cost. In this session, we’ll walk through a practical approach to running higher volumes of queries faster through capabilities available today – no Private Preview required.