How to connect Streamlit to Snowflake

Рет қаралды 8,004

Күн бұрын

In this video, ‪@DataProfessor‬ shows how to securely access a Snowflake database from a Streamlit app.
❄️ Sign up for Snowflake (free trial): signup.snowflake.com/?trial=s...
🔗 Code for streamlit_app.py gist.github.com/dataprofessor...
🔗 Code for .streamlit/secrets.toml gist.github.com/dataprofessor...
Timeline
0:00 Overview
0:28 Introduction
0:58 App preview
1:21 Creating a Snowflake database
2:47 Setting up a coding environment
4:25 Setting up directories and files
6:21 Building the Streamlit app
7:38 Adding access credentials via secrets management
8:39 Launching the Streamlit app
9:25 Line-by-line code explanation
11:01 Summary
11:26 Streamlit Hackathon for Snowflake Summit
#snowflakedb #database #datascience #streamlit #python

Пікірлер: 12

@streamlitofficial Жыл бұрын

🗻 Enter the Summit Hackathon by May 5th, 2023: forms.streamlit.io/summit-hackathon 📖 For more information: discuss.streamlit.io/t/enter-the-summit-hackathon/40473

@jennytorres3568 Жыл бұрын

Super! I loved your explanation, so clear.

@rodi21 Жыл бұрын

Amazing! So detailed and wonderful explanation!

@iDoTechOK 8 ай бұрын

Thank you for creating and sharing this content. Much appreciated!

@serychristianrenaud Жыл бұрын

Thank

@praneethakuna693 4 күн бұрын

What if duo MFA is enabled for snowflake accounts how can we enable this.Thanks in advance

@jameswebb3254 Жыл бұрын

Vegas baby, what happens in Vegas stays in Vegas

@srushtipawar829 4 ай бұрын

Hello, where do I run this command on Windows?

@l.kennethwells2138 11 ай бұрын

I followed to the letter and keep getting errors as this code as presented will not run.

@elvien0 8 ай бұрын

if you are having an issue with the streamlit not being able to create a connection, change the lines from the # Establish Snowflake session to this: # Establish Snowflake session connection_parameters = { "account": "", "user": "", "password": "", "warehouse": "compute_wh", "role": "accountadmin", "database": "pets", "schema": "public" } session = Session.builder.configs(connection_parameters).create() st.success("Connected to Snowflake!")