Upgrade to Pro — share decks privately, control downloads, hide ads and more …

BUILD.local - Building an Interactive Data App with Snowflake & Streamlit

BUILD.local - Building an Interactive Data App with Snowflake & Streamlit

During this meeting Dutch local Data Superhero, Daan Bakboord, will give an overview and demo of building a data app with Snowflake and Streamlit. Daan will begin by showing you how you can interact with Snowflake from Python, and then demonstrate how easy it is to make an interactive data application in Streamlit.

Daan Bakboord

November 18, 2022
Tweet

More Decks by Daan Bakboord

Other Decks in Programming

Transcript

  1. Building an Interactive Data App with
    Snowflake & Streamlit

    View full-size slide

  2. © 2022 Snowflake Inc. All Rights Reserved

    View full-size slide

  3. Agenda
    Introduction into Streamlit
    Demo
    Wrapping Up
    Questions

    View full-size slide

  4. © 2022 Snowflake Inc. All Rights Reserved
    “a Python library that allows
    the creation of
    interactive, data-driven web applications
    in Python”

    View full-size slide

  5. © 2022 Snowflake Inc. All Rights Reserved
    BUILD 2022 GLOBALLY
    TITLE HERE IN ALL CAPS
    Key Takeaways
    Streamlit brings your data to life
    “Build interactive apps with Python”
    Today Snowflake customers can get started with the
    Streamlit Open Source Library
    Coming soon Snowlake integration to build, deploy, and share
    Streamlit apps in Snowflake

    View full-size slide

  6. © 2022 Snowflake Inc. All Rights Reserved
    • Directly from Data and Python code.
    • Right from your favorite IDE.
    • Create a Data App in minutes
    • All Data Types because it’s Python 🐍
    Streamlit is a new way of creating apps
    “The best and latest from Data Science
    and Machine Learning”

    View full-size slide

  7. © 2022 Snowflake Inc. All Rights Reserved
    BUILD 2022 GLOBALLY
    TITLE HERE IN ALL CAPS
    Streamlit is built by and for
    data practitioners
    Data scientists, ML engineers, data
    engineers, and others w/ Python
    knowledge love Streamlit
    If they are in the Snowpark preview for
    Python that’s a good signal!
    Create an app in minutes. No front-
    end experience necessary.
    7
    Doing Data Science Coding in Python Looking for speed!

    View full-size slide

  8. © 2022 Snowflake Inc. All Rights Reserved
    Common use cases for Streamlit
    Data science teams quickly build
    data apps in Python to test
    hypotheses, gather feedback, and
    iterate quickly to deliver insights to
    their business stakeholders.
    Rapid prototyping
    Data scientists use Streamlit as a
    direct method of sharing data with
    clients, customers, partners, and
    even suppliers to reduce lag and
    drive positive business outcomes.
    Often this starts as just a demo of
    capabilities but then turns into
    deliverables for customers and
    partners.
    Demo-ing work Creating tools for
    business users
    Data teams struggle to share the
    outputs of their models in an easily
    consumable way for their
    stakeholders. Folks from sales,
    operations, marketing, and support
    can often benefit from interacting
    with models the data team has built.
    Streamlit creates a fast and easy
    way to create new tools from data
    that empower business users.

    View full-size slide

  9. © 2022 Snowflake Inc. All Rights Reserved
    BUILD 2022 GLOBALLY
    TITLE HERE IN ALL CAPS
    Today: Use Streamlit open source
    library to bring data to life
    How it works:
    ● Install open source Python library
    ● Connect to data in Snowflake via
    Python connector
    ● Build and edit locally
    ● Deploy and share on your own
    Why it matters
    🐍 Only need Python to build an app
    ⏩ Explore your data and accelerate
    model development
    📊 Share your insights in a way everyone
    will understand

    View full-size slide

  10. © 2022 Snowflake Inc. All Rights Reserved
    Demo Time!
    Doing the Streamlit-magic
    • Streamlit getting started
    • Building a first Streamlit App
    • Building a first Streamlit App on Snowflake
    • Deploying a Streamlit App on the Streamlit Cloud
    • Snowflake and Marketplace Data in Streamlit
    • Snowflake Snowpark and Marketplace Data in Streamlit
    https://bit.ly/DaAnalytics_BUILD_local

    View full-size slide

  11. © 2022 Snowflake Inc. All Rights Reserved
    Get Started in under a minute!

    View full-size slide

  12. © 2022 Snowflake Inc. All Rights Reserved
    Building a first Streamlit App

    View full-size slide

  13. © 2022 Snowflake Inc. All Rights Reserved
    Building a first Streamlit App on Snowflake
    • Setting up the connection to Snowflake
    o Install Snowflake for Python Connector
    o Validate Snowflake connection
    • Creating Snowflake-objects
    • Loading Data
    • Doing the Streamlit-magic

    View full-size slide

  14. © 2022 Snowflake Inc. All Rights Reserved
    Deploying a Streamlit App on the Streamlit Cloud
    GitHub Account
    Select Python-file from GitHub-
    Repository
    Advanced Settings
    Python version 3.8
    Credentials
    Deploy App
    Deploy, manage, and share your apps with the world,
    directly from Streamlit — all for free.

    View full-size slide

  15. © 2022 Snowflake Inc. All Rights Reserved
    Snowflake Marketplace Data in Streamlit
    • Importing Libraries
    • Connection to Snowflake
    • Creating Data Sets (SQL)
    • Formatting Streamlit App
    • Doing the Streamlit-magic

    View full-size slide

  16. © 2022 Snowflake Inc. All Rights Reserved
    Snowflake Snowpark & Marketplace Data in Streamlit
    • Importing Libraries
    • Connection to Snowflake
    • Creating Data Sets (Python)
    • Formatting Streamlit App
    • Doing the Streamlit-magic

    View full-size slide

  17. © 2022 Snowflake Inc. All Rights Reserved
    Personal use cases for Streamlit
    Data Visualization for an
    Independent Consultant. No need to
    buy licences
    Open Source Data
    Visualization
    What happens inside Snowflake?
    Visualizing Snowflake Demo-ing &
    Prototyping
    Quickly building and showing apps
    and iterating.
    Visualizing rankings of our own Pong
    game.

    View full-size slide

  18. © 2022 Snowflake Inc. All Rights Reserved
    BUILD 2022 GLOBALLY
    TITLE HERE IN ALL CAPS
    In Dev: Build, deploy, and share
    Streamlits in Snowflake
    With Snowflake’s Streamlit integration
    How it will work:
    ● Build in Snowflake Python worksheet
    ● Deploy from Snowflake
    ● Share with Snowflake users
    ● Monetize using Native App Framework
    Why it matters:
    ⏩ Streamline dev by building in Snowflake
    🧰 Deploy and run apps that leverage
    Snowflake infrastructure
    🔒 Securely collaborate, iterate, and monetize

    View full-size slide

  19. © 2022 Snowflake Inc. All Rights Reserved
    Streamlit Resources
    Documentation
    Gallery
    Third-Party Components
    https://streamlit.io
    https://discuss.streamlit.io
    https://discord.gg/bTz5EDYh9Z
    Forums Tutorials
    • https://streamlitpython.com
    • https://30days.streamlit.app

    View full-size slide

  20. © 2022 Snowflake Inc. All Rights Reserved
    DaAnalytics Build.local GitHub Code
    https://bit.ly/DaAnalytics_BUILD_local

    View full-size slide

  21. © 2022 Snowflake Inc. All Rights Reserved
    Snowflake Data Superheroes
    Rewards & Benefits
    • Product Access
    • Training
    • Swag
    • VIP Experience
    Obligations
    • Content Creation
    • Lead Discussions
    • Supporting Others
    • Snowflake Expertise
    DATA CLOUD ENTHUSIASTS, EXPERTS, & ADVOCATES
    https://community.snowflake.com/s/dataheroes

    View full-size slide

  22. © 2022 Snowflake Inc. All Rights Reserved
    QUESTIONS?

    View full-size slide

  23. © 2022 Snowflake Inc. All Rights Reserved
    THANK YOU

    View full-size slide