AstraZeneca Snowcamp

Join Snowflake on September 23 and September 24th for a 2-day virtual SnowCamp dedicated to the AstraZeneca team.

See details below. Register now to reserve your virtual seat!

Agenda details:

Day 1

Module 1: Orientation & Architecture

• Snowflake AI Data Cloud overview and structure
• Storage, Compute, and Cloud Services layers
• Navigating Snowsight and Workspaces
• Object hierarchy: databases, schemas, tables, views
• Lab: Navigate objects, explore the shared dataset, create personal workspace

Module 2: Querying with Cortex Code (CoCo)

• Introduction to CoCo as an AI coding assistant
• Natural language to SQL generation
• Iterative query refinement and debugging
• Lab: Query the course dataset using CoCo, build persona-relevant reports

Module 3: Access Control & RBAC

• Roles, privileges, and the grant hierarchy
• Ownership and discretionary access control
• Principle of least privilege
• Lab: Configure grants, demonstrate deny→grant flow, persona-specific access scenarios

Module 4: Getting Data In

• Stages (internal and external)
• File formats and COPY INTO
• Transformations during load
• Lab: Load CSV/JSON data, apply transformations, validate results

Module 5: Cortex AI Functions

• AI_SENTIMENT, AI_CLASSIFY, AI_EXTRACT, AI_SUMMARIZE
• AI_COMPLETE for custom prompts
• Applying AI functions to business data
• Lab: Apply AI functions to course dataset per persona use case

Day 2

Module 6: Unstructured Data & AI

• Working with files on stages
• AI_PARSE_DOCUMENT for text extraction/OCR
• Cortex Search for semantic retrieval
• Lab: Process documents from stage, extract structured fields, build a search index

Module 7: Structured Data & Semantic Views

• Building a semantic view via CoCo
• Reviewing different components
• Working with verified queries
• Sample Q/A

Module 8: Cortex Agent

• Building a Cortex Agent via CoCo
• Assigning tools
• Working with agent instructions
• Interacting with agent

Module 9: Data Landscape & Marketplace

• Snowflake Marketplace overview
• Discovering and mounting shared datasets
• Data sharing concepts
• Lab: Browse Marketplace, mount a dataset, query third-party data, include a Cortex Knowledge Extension to an Agent

Module 10: Capstone Project

• Implement most of the above concepts and build an agent to implement a “Talk to Data” use case.