Add a Streamlit app¶

About Streamlit and the Snowflake Native App Framework¶

Streamlit (https://streamlit.io/) is an open-source Python library that makes it easy to create and share custom web apps for machine learning and data science. By using Streamlit you can quickly build and deploy powerful data applications.

For information about the open-source library, see the Streamlit Library documentation (https://docs.streamlit.io/).

Within the Snowflake Native App Framework you can use Streamlit to perform the following:

• Create a front-end web app that enables consumers to visualize the data provided by your Snowflake Native App.

• Create a user interface that allows consumers to grant privileges and create references to objects within their account that are used by the Snowflake Native App.

  See Request access to objects in a consumer account for more information.

Supported versions of the Streamlit library¶

The Snowflake Native App Framework supports the following versions of the Streamlit library:

• 1.35.0

• 1.31.1

• 1.29.0

• 1.26.0

• 1.22.0

Support for newer versions of the Streamlit library will be included as they are released.

See Set the Streamlit version for an app for information on how to set the version for a Streamlit app.

Supported external packages¶

By default, a Streamlit app that is included within a Snowflake Native App includes the python, streamlit, and snowflake-snowpark-python packages pre-installed in the consumer environment. The consumer environment also has access to the dependencies required by these packages.

Unsupported Streamlit Features¶

The following Streamlit features are not currently supported when using Streamlit in a Snowflake Native App:

• Custom components are not supported.

• Using Azure Private Link and Google Cloud Private Service Connect to access a Streamlit app is not supported.

• st.bokeh_chart (https://docs.streamlit.io/library/api-reference/charts/st.bokeh_chart)

• st.cache_data (https://docs.streamlit.io/library/api-reference/performance/st.cache_data)

• st.cache_resource (https://docs.streamlit.io/library/api-reference/performance/st.cache_resource)

• st.camera_input (https://docs.streamlit.io/library/api-reference/widgets/st.camera_input)

• st.download_button (https://docs.streamlit.io/library/api-reference/widgets/st.download_button)

• st.file_uploader (https://docs.streamlit.io/library/api-reference/widgets/st.file_uploader)

• st.image (https://docs.streamlit.io/library/api-reference/media/st.image)

• st.pyplot (https://docs.streamlit.io/library/api-reference/charts/st.pyplot)

• st.scatter_chart (https://docs.streamlit.io/library/api-reference/charts/st.scatter_chart)

• st.set_page_config (https://docs.streamlit.io/library/api-reference/utilities/st.set_page_config)

  The page_title and page_icon properties of the st.set_page_config (https://docs.streamlit.io/library/api-reference/utilities/st.set_page_config) command are not supported.

• st.video (https://docs.streamlit.io/library/api-reference/media/st.video)

• Custom Components (https://docs.streamlit.io/library/components), including:

  • component.html() (https://docs.streamlit.io/library/components/components-api#stcomponentsv1html)

  • component.iframe() (https://docs.streamlit.io/library/components/components-api#stcomponentsv1iframe)

• Configuration files (https://docs.streamlit.io/library/advanced-features/configuration)

• The following experimental features:

  • st.experimental_set_query_params (https://docs.streamlit.io/library/api-reference/utilities/st.experimental_set_query_params)

  • st.experimental_get_query_params (https://docs.streamlit.io/library/api-reference/utilities/st.experimental_get_query_params)

• Network access via the internet

• Anchor links

Workflow to add a Streamlit app to a Snowflake Native App¶

The following workflow describes how to add a Streamlit app to a Snowflake Native App:

1. Develop your native app.

   This includes adding the data content that you want consumers to access using Streamlit. See Snowflake Native App Framework workflow for more information.

2. Review the following sections to understand the supported version of the Streamlit library and unsupported features:

   • Supported versions of the Streamlit library

   • Unsupported Streamlit Features

   • Supported external packages

3. Develop a Streamlit app.

   See the Streamlit Library documentation (https://docs.streamlit.io/) for information on using the Streamlit open-source library.

4. Create a local directory structure for the Streamlit app.

   See Example directory structure for a Streamlit app for recommendations on how to organize your Streamlit files within the structure of your app.

5. Add a CREATE STREAMLIT statement to the setup script.

   When running the CREATE APPLICATION command, the setup script runs the CREATE STREAMLIT statement to create a Streamlit object. This object contains the schema and Python files required by the Streamlit app.

6. Configure the environment.yml file to include additional libraries in your Streamlit app.

   See Add additional packages to a Streamlit app for more information.

7. Optional: Add the Streamlit object name as an entry in the manifest.yaml file to display the Streamlit app as the default app in Snowsight.

   See Add a Streamlit app to the manifest file for more information.

8. Upload the Streamlit files, environment.yml file, setup script and manifest.yml files to a named stage. To include Streamlit code files in an application package, the files must be uploaded to a named stage.

9. Test the application package.

   After creating the files required by the application package and Streamlit app, create an application object to test the setup script and manifest.yml file.

   See Test the application package containing the Streamlit app for more information.

10. View the Streamlit app in Snowsight.

    To test the Streamlit app, view the app in Snowsight. See Test the Streamlit app in Snowsight.

Example directory structure for a Streamlit app¶

Like other Python modules, to add a Streamlit app to an application package you must upload your Streamlit code files to a named stage. See PUT for information on how to upload files to a stage.

To account for multiple versions of a Snowflake Native App, consider using a directory structure similar to the following to maintain your Streamlit apps and related application files:

@test.schema1.stage1:
└── /
    ├── manifest.yml
    ├── readme.md
    ├── scripts/setup_script.sql
    └── code_artifacts/
        └── streamlit/
            └── environment.yml
            └── streamlit_app.py

Note that the directory structure you create depends on the requirements of your app and development environment.

See Reference external code files for more information on relative paths.

Create the Streamlit object in the setup script¶

The following example shows how to use CREATE STREAMLIT within the setup script of an app.

CREATE OR REPLACE STREAMLIT app_schema.my_test_app_na
     FROM '/code_artifacts/streamlit'
     MAIN_FILE = '/streamlit_app.py';

GRANT USAGE ON SCHEMA APP_SCHEMA TO APPLICATION ROLE app_public;
GRANT USAGE ON STREAMLIT APP_SCHEMA.MY_TEST_APP_NA TO APPLICATION ROLE app_public;

This example creates a Streamlit object within a schema named app_schema. The CREATE STREAMLIT command uses the Streamlit app specified by the MAIN_FILE clause. The directory location is specified by the value of the FROM clause.

See Example directory structure for a Streamlit app for information on creating the directory structure for a Streamlit app within an application package.

This example also grants the required privileges on the schema and Streamlit object to an application role.

Add additional packages to a Streamlit app¶

Use the environment.yml file to add additional Python packages to a Streamlit app. For example, to add the scikit-learn library to a Streamlit app, add the following to the environment.yml file:

name: sf_env
channels:
- snowflake
dependencies:
- scikit-learn

The name and channels properties are both required.

Also, the - snowflake key is required under the channels property. This indicates the Snowflake Anaconda Channel (https://repo.anaconda.com/pkgs/snowflake/).

Set the Streamlit version for an app¶

The Snowflake Native App Framework supports multiple versions of the Streamlit library. To set the Streamlit version within a Snowflake Native App add streamlit to the dependencies section of the environment.yml file as shown in the following example:

name: sf_env
channels:
- snowflake
dependencies:
- streamlit=1.22.0|1.26.0

Snowflake recommends explicitly setting the Streamlit version for your app. However, currently, if you do not explicitly set the version of the Streamlit library, Streamlit version 1.22.0 is set as the default.

Add a Streamlit app to the manifest file¶

To specify the default Streamlit app launched by your native app, add the following entries in the manifest.yml file.

artifacts:
  ...
  default_streamlit: app_schema.streamlit_app_na
  ...

The default_streamlit: app_schema.streamlit_app_na entry specifies the location of the schema containing your Streamlit app.

Test the application package containing the Streamlit app¶

To test the application package containing the Streamlit app, create an application object using the files on a named stage by running the CREATE APPLICATION as shown in the following example:

CREATE APPLICATION hello_snowflake_app
  FROM APPLICATION PACKAGE hello_snowflake_package
  USING '@hello_snowflake_code.core.hello_snowflake_stage';

Copy

Depending on what you need to test, you can create the application object using other forms of the CREATE APPLICATION. For example, you may want to test the Streamlit app as part of a version or upgrade. See Install and test an app locally.

Test the Streamlit app in Snowsight¶

To test the Streamlit app, view the app in Snowsight by doing the following:

1. Sign in to Snowsight.

2. In the navigation menu, select Data Products » Apps.

3. Select the Streamlit app you want to view.

   The main Streamlit app opens in the Snowsight.

4. Optional: If you are viewing a multi-page Streamlit app, select a tab to view additional pages.

Troubleshoot a Streamlit app in the Snowflake Native App Framework¶

If the app displays an unknown error, make sure you have tried the solutions described in the following sections.