AMS <> SNOWFLAKE: DRIVING GROWTH AND INSIGHTS WITH ADVANCED ANALYTICS & AI

16 JUNE 2025
9:30 AM–4:30 PM BST
Snowflake London Office, One Crown Place, London, EC2A 4EF, United Kingdom
London
Monday 16 June 2025
The Lodge - Snowflake

REGISTER HERE!

 

 

 

 

Agenda:

Day 1: Introduction & Core Capabilities

START TIME DETAILS
9:30AM - 9:45AM
Welcome & Future State Vision
  • Introduction of the workshop objectives, playback of AMS’s Strategic Goals and operational challenges, expected outcomes
9:45AM - 10:15AM
Snowflake Architecture Deep-Dive
  • Technical deep-dive into the Snowflake architecture
  • Discussion of key concepts such as virtual warehouses, storage layers, and query processing
  • Current state and future state discussion
10:15AM - 10:30AM
Session 0: Platform Walkthrough

Clear Strategy

10:30AM - 10:45AM
BREAK
10:45AM - 12:30PM
Session 1: Ingestion & Engineering
  • Session Type: Hands-on Lab
  • Objective: Ingest and secure data using test data from sample data for structured, unstructured, and semi-structured data.
  • Data sources: sample CSV, JSON, and other unstructured data
  • Focus areas: Ingestion methods, data security features, and access controls
Topic Description
Ingestion and Engineering Dmytro will provide a high level overview of Snowflake Data Engineering Positioning and Capabilities

Iceberg open format and Data Lakehouse design pattern
Data Load Ingest provided data through file upload
Data Transformation Dynamic Table and Data Pipeline building through various methods

Data Lineage and Data pipeline tracking
Data Quality Metrics Build and create Data Quality Metrics and visualize this in a Streamlit App
Concurrency Tests for BI (Demo but can be hands-on) Demonstrate Snowflake’s capability to scale compute out for unpredictable BI requirements
12:30PM - 1:30PM
LUNCH
1:30PM - 2:30PM
Session 2: Openflow and Demo
6:00 - 8:00pm
Drinks and Nibbles
  • Session Type: Presentation and demo
  • Objective: demonstrate Snowflake Openflow capabilities to ingest Workday and REST API
  • [Pritul Kothari]Openflow overview (15mins), the underlying technology, Data type supported
  • [Pritul Kothari]Demo Workday (15mins)
    • Show the data that we are pulling from Workday (e.g. what does it look like on Workday)
    • The process as demonstrated in the video
    • The results in Snowflake
    • How does it capture changes and the latency
  • [Dan Chaffelson]Demo REST API Ingestion (20mins)
    • OAUTH2.0 authentication
    • Setup the connection and the UI
    • Demonstrate ingestion and what the endstate looks like in Snowflake

[Pritul Kothari or Dan Chaffelson]Roadmaps and Q&A (10mins)

2:30PM - 2:45PM
BREAK
2:45PM - 4:45PM
Session 3: Security and Governance
  • Session Type: Presentation and Hands-on
  • Objective: Snowflake Security and Governance positioning and what makes Snowflake fundamentally different; feature coverage on Horizon capabilities and Cost Centre
Topic Description
[Martin Whitby]Snowflake Horizon – Governance and Security Overview and Differentiators (30 – 45mins) Deep Dive into Snowflake’s Governance and Security capabilities
[Harley Chen]Tagging and Masking Capabilities Dynamic Mask, Row Level Masking, Tagging, Aggregation and Projection Constraints, Differential Privacy
[Harley Chen]Governance Walkthrough Data Lineage, Data Dictionary, Data Pipeline Tracking, Trust Centre
[Harley Chen]DevOps and Business Continuity Dev/Test/Prod Environment

Time Travel
[Harley Chen]Cost Centre Walkthrough Cost Governance Dashboard, Cost Centre distribution based on Tags, etc.

 

4:45PM - 5:15PM
Session 4: Day 1 Wrap
  • Session Type: Presentation and Q&A
  • Objective: Playback on everything covered in Day 1, Q&A.
6:15PM - 8:45PM
Dinner at Yauatcha City

Location: Broadgate, London EC2M 2QS

Day 2: Advanced Analytics & Integration

START TIME SESSION DETAILS
9:00AM - 9:05AM
Welcome & Day 2 Agenda
9:05AM - 10:15AM
Session 5: ML and Predictive Analytics
  • Session Type: Hands-on Lab
  • Objective: Explore Snowflake’s Classic ML and Predictive Analytics Capabilities
Topic Description
Snowflake’s end-to-end About 20-30mins delivered on Snowflake’s AI Strategic vision
What we will cover today Show Intelligence, show end products
Hands-on Build Cortex, Search, Analysts, Create an Agent and use Snowflake Intelligence; Utilize AI-SQL Capability to answer questions like, “show me all the CVs that have x yrs of y skills” (Parse_Doc to AI SQL, AI_Filter)
10:15PM - 10:30PM
BREAK
10:30AM - 12:30PM
Session 6: Snowflake Cortex AI

Session Type: Hands-on Lab

Objective: Explore Snowflake’s Cortex AI Capabilities

Topic Description
AI Vision About 20-30mins delivered on Snowflake’s AI Strategic vision
Demo of the end product and other features Show Intelligence, show end products
Hands-on Build Cortex, Search, Analysts, Create an Agent and use Snowflake Intelligence; Utilize AI-SQL Capability to answer questions like, “show me all the CVs that have x yrs of y skills” (Parse_Doc to AI SQL, AI_Filter)
12:30PM - 1:30PM
LUNCH
1:30PM - 3:00PM
Session 7: Azure + Snowflake Integration
  • Session Type: Hands-on Lab
  • Objective: Explore how Snowflake integrates with Azure Tech Stack
    • Robin provides an overview of Snowflake + Azure
    • Data Engineering Integrations (D365 ADF, Blob Storage)
    • PowerBI (Import Mode, DirectQuery), hand-ons
    • Purview (Slide and if they have Purview, walk through the process)
Topic Description
Azure + Snowflake Overview of integration points between Azure and Snowflake

SSO and Authentication integration
Purview Integration with Purview and Snowflake, where might Snowflake fit
PowerBI Integration with PowerBI, including Import Mode and DirectQuery, best practices around caching mechanism, referential integrity, and data modeling
3:00PM - 3:15PM
BREAK
3:15PM - 4:00PM
Session 8: Data Sharing and Collaboration
  • Session Type: Hands-on Lab
  • Objective: Explore Snowflake’s data sharing and collaboration features
Topic Description
Create Data Share Create Simple Shares, via UI to other accounts, show the UI for analytics
Cross-Region and Cross Cloud Share Test the ability to Share a dataset cross-region and cross-cloud
Incorporate Masking Capabilities Show how the masking in previous lab can be utilized here
Interacting with Share Updating data and seeing this reflected in the reader accounts
Marketplace Install some Marketplace data or Apps in the account

Internal Marketplace
4:00PM - 4:45PM
Wrap and Snowflake Roadmap
  • Session Type: Presentation
  • Objective: Recap Day 1 and 2 covered, key action plans going forward, and Provide a brief overview of key releases from Summit that are relevant to AMS

EVENT DETAILS

WHEN & WHERE

Snowflake London Office
One Crown Place, London, EC2A 4EF, United Kingdom
16 June 2025
9:30 AM BST