Create and deploy Streamlit apps using SQL¶

Optional: Create the Streamlit files on your local file system¶

This section describes how to create a local set of app source files and stage them in Snowflake. In the next section, if you don’t have staged source files when you create your STREAMLIT object, a default set of source files is copied into your STREAMLIT object instead.

1. On your local file system, create your main Streamlit app.

2. Optional: To configure your deployment environment and specify dependencies, create an environment.yml file.

   If you don’t include this file, your app will run on the latest supported versions of Python and Streamlit in Streamlit in Snowflake. For information about app dependencies, see Manage packages by using the environment.yml file.

After you create the Streamlit app, your directory structure should look similar to this:

project_directory/
├── .streamlit/
│   └── config.toml
├── environment.yml
└── streamlit_app.py

Upload your Streamlit files to a named stage¶

To create a Streamlit app in Streamlit in Snowflake, you must upload your application files to a named stage.

• To upload application files, do one of the following:

  • Upload the application files by using Snowsight, as described in Staging files using Snowsight.

  • Upload the application files by using SnowSQL, as shown in the following example:

    PUT file:///<path_to_your_project_directory>/streamlit/streamlit_app.py @streamlit_db.streamlit_schema.streamlit_stage overwrite=true auto_compress=false;
    PUT file:///<path_to_your_project_directory>/streamlit/environment.yml @streamlit_db.streamlit_schema.streamlit_stage overwrite=true auto_compress=false;
    PUT file:///<path_to_your_project_directory>/streamlit/.streamlit/config.toml @streamlit_db.streamlit_schema.streamlit_stage/.streamlit/ overwrite=true auto_compress=false;
    

    Copy

Create a STREAMLIT object¶

A STREAMLIT object is a database object in Snowflake that encapsulates the files required by your Streamlit app.

1. To create a STREAMLIT object, run the CREATE STREAMLIT command, as shown in the following example:

   CREATE STREAMLIT hello_streamlit
   FROM '@streamlit_db.streamlit_schema.streamlit_stage'
   MAIN_FILE = 'streamlit_app.py'
   QUERY_WAREHOUSE = my_warehouse;
   

   Copy

   This command creates a STREAMLIT object named hello_streamlit based on the path and file specified in FROM and MAIN_FILE.

   Note

   Although the QUERY_WAREHOUSE clause is optional, you must specify a query warehouse to be able to run the Streamlit app in Snowflake.

2. Optional: To verify that the Streamlit object was created, run the SHOW STREAMLITS command:

   SHOW STREAMLITS;
   

   Copy

3. To complete initializing the app, the owner role must either view the app in Snowsight, or run the following command:

   ALTER STREAMLIT hello_streamlit ADD LIVE VERSION FROM LAST;
   

   Copy

Pin the Streamlit version in the environment.yml file¶

• To pin the Streamlit version in the environment.yml file, include a streamlit dependency as shown in the following example:

  name: sf_env
  channels:
  - snowflake
  dependencies:
  - scikit-learn
  - streamlit=1.31.1
  

  Copy

Rename a STREAMLIT object¶

• To rename a STREAMLIT object, use the RENAME TO clause of the ALTER STREAMLIT command, as shown in the following example:

  ALTER STREAMLIT hello_streamlit RENAME TO hello_snowflake;
  

  Copy

Change the stage or main file in a STREAMLIT object¶

• To change the path to the stage for a STREAMLIT object, use the ALTER STREAMLIT command to set the ROOT_LOCATION property of the object, as shown in the following example:

  ALTER STREAMLIT hello_streamlit SET ROOT_LOCATION = '@snowflake_db.snowflake_schema.snowflake_stage'
  

  Copy

• To change the main Streamlit file in a STREAMLIT object, use the ALTER STREAMLIT command to set the MAIN_FILE property of the object, as shown in the following example:

  ALTER STREAMLIT hello_streamlit SET MAIN_FILE = 'snowflake_main.py'
  

  Copy

Change the query warehouse assigned to a STREAMLIT object¶

• To add a query warehouse or change the current query warehouse for a STREAMLIT object, use the ALTER STREAMLIT command to set the QUERY_WAREHOUSE property of the object, as shown in the following example:

  ALTER STREAMLIT hello_streamlit SET QUERY_WAREHOUSE = my_new_warehouse;
  

  Copy

List available STREAMLIT objects¶

• To list the Streamlit apps that are available to your current role, run the SHOW STREAMLITS command, as shown in the following example:

  SHOW STREAMLITS;
  

  Copy

Delete a STREAMLIT object¶

• To delete a STREAMLIT object, run the DROP STREAMLIT command, as shown in the following example:

  DROP STREAMLIT hello_streamlit;
  

  Copy