Build2021

In the world of application development Snowflake imagines giving builders the data access and tools to deliver powerful applications in ways that were previously impossible. Natalie Mead provides a unique APJ perspective on Snowflakes strategy and the opportunity for our rich community of builders. She will also signpost the key technologies and sessions from the global build events.

This session will guide you through how to design your application for the best performance. Topics will include right-sizing warehouses, concurrency with multi-cluster warehouses, query pruning, compilation, and optimizing connection and transport for your clients.

We will also discuss recent changes that have increased performance and upcoming functionality that can be leveraged to cover higher concurrencies and lower-latency workloads.

Join this session to learn how, with Unistore and Hybrid Tables, you can build transactional applications directly on Snowflake, simplifying your application stack so real-time analytical queries can run on transactional data.

Join our guest innovator from the community! In this session we showcase an APJ customer diving into how they have created a solution on snowflake. We get into the detail so don’t miss this chance to meet out guest presenter!

Designing applications that scale as your customer base grows can be challenging. It’s important to have an efficient deployment approach that meets the data access, privacy, cost, and performance needs for both you and your customers.

Join this session with a Snowflake product expert and the CTO of MessageGears to learn about the different deployment and tenancy models for applications powered by Snowflake.

Snowpark let’s builders create and extend Snowflake using Python, Java, and JavaScript.

But how can you bring in DevOps best practices for development, collaboration, and automated releases?

In this session we’ll walk through using ‘git-flow’ with Snowpark for production-grade Snowpark apps.

Want to know how to build machine learning models in Snowflake and present them to your stakeholders?

In this session we will show you

• how to use Snowpark to clean your data and perform feature engineering,
• build and train sales forecast models using Python in Snowflake, use Python UDFs to expose your predictive models,
• present and analyze your models in ThoughtSpot.

Iceberg Tables, a new type of Snowflake table available in preview, pairs Snowflake’s powerful performance engine and platform capabilities with open formats in external storage.

In this session, learn about the Apache Iceberg project along with a technical deep dive on how Iceberg Tables work in Snowflake.

In this hands-on lab, you will build a data application that leverages the Economy Data Atlas, published by Knoema on Snowflake Marketplace. You will process data with Snowpark, develop a simple ML model, and create a Python UDF in Snowflake, then visualize the data with Streamlit.

Key Features and Technology: Snowflake Marketplace, Snowpark for Python, Python libraries, Python UDFs, Streamlit

Prerequisites:

• Account Admin role access in Snowflake or a Snowflake trial account: https://signup.snowflake.com/
• Basic knowledge of SQL, database concepts, and objects
• Familiarity with Python. All code for the lab is provided.
• Ability to install and run software on your computer

Please reference this Quickstart with step by step instructions.

In this hands-on lab, you will see how data teams can go from data and feature engineering to model development and productionalizing in a collaborative and scalable way using Snowpark, Apache Airflow, Anaconda, and Streamlit.

Prior experience using Python and data science tools such as notebooks and open-source packages is a plus.

Lab Prerequisites:

• Your laptop.
• Snowflake trial account (https://signup.snowflake.com/) in **AWS – US West (Oregon)** with an initial admin account created
• Free Amazon SageMaker Studio Lab account (https://studiolab.sagemaker.aws/)

Optional: Docker Desktop or other Docker runtime installed on your laptop for the Apache Airflow portion of the lab Review the QuickStart”