Limitations and unsupported features¶

Attention

This feature is available to accounts in AWS and Microsoft Azure commercial regions. AWS PrivateLink and Azure Private Link are not supported.

This topic describes the limitations on Streamlit in Snowflake. It also lists Streamlit features that are unsupported.

Account limitations when using Streamlit in Snowflake¶

Streamlit in Snowflake has the following account limitations:

Your Snowflake account must be located in an Amazon Web Services (AWS) or a Microsoft Azure region.
Accounts in the following regions are not currently supported:
- Google Cloud Platform (GCP)
- US government regions that support FedRAMP
Using AWS PrivateLink or Azure Private Link is not supported.

Additional limitations when using Streamlit in Snowflake¶

The following sections describe additional limitations when you are using Streamlit in Snowflake.

Data limits on Streamlit apps¶

Streamlit apps running in Streamlit in Snowflake and in a Snowflake Native App have a 32MB limit on the amount of data that can be retrieved from a single query. Queries that exceed 32MB throw the following error:

MessageSizeError: Data Size exceeds message limit

To avoid this limit, design your Streamlit apps to retrieve data in increments smaller than 32MB.

The Streamlit in Snowflake editor does not support stages with server-side encryption¶

The Streamlit in Snowflake editor does not support creating a STREAMLIT object from files on a named stage that uses server-side encryption. In this situation, Snowsight returns an error.

Limitation when using `st.map` and `st.pydeck_chart` in Streamlit in Snowflake¶

When you use the st.map or st.pydeck_chart Streamlit commands, Mapbox provides the map tiles when rendering map content. Mapbox is a third-party application and is subject to Snowflake’s External Offerings Terms.

Multi-page Streamlit apps¶

Multi-page Streamlit apps are supported with the following considerations:

Multi-page Streamlit apps can only be created by using SQL commands. See Creating a Streamlit app by using SQL.
Individual page URLs are not supported.
Files uploaded to the /pages directory are visible within the ROOT_LOCATION of the named stage.

Some Snowflake context functions return empty fields or NONE¶

Snowflake context functions that begin with CURRENT_ (CURRENT_*) return either empty fields or NONE when used in Streamlit in Snowflake.

If you need to use CURRENT_USER in your app for personalization, logging, or data filtering, use st.experimental_user instead.

Custom components are not supported¶

Custom components are not supported.

Integrated version control or CI/CD systems are not supported¶

Streamlit apps are not integrated with version control systems. App history or code changes are permanent and cannot be rolled back.

There is no integration with GitHub, GitLab, or other version control vendors.

App edits are viewable by app viewers¶

When a developer runs a Streamlit app while editing, the changes become live and are immediately available to app viewers.

Replication is not supported¶

Replication is not supported for Streamlit in Snowflake apps.

Unsupported Streamlit features¶

The following Streamlit features are not supported in Streamlit in Snowflake:

st.file_uploader
st.cache_data
st.cache_resource
st.camera_input
st.bokeh_chart
st.scatter_chart
st.set_page_config

The page_title and page_icon properties of the st.set_page_config command are not supported.
Custom Components, including:
- component.html()
- component.iframe()
Custom themes
Configuration files
The following experimental features:
- st.experimental_set_query_params
- st.experimental_get_query_params
Unsafe HTML using unsafe_allow_html=True is not supported in st.markdown.
Network access via the internet
Anchor links

Troubleshooting Streamlit in Snowflake¶

The following scenarios can help you troubleshoot issues that can occur when working with Streamlit in Snowflake.

You cannot load the Streamlit app¶

Each Streamlit app running in Streamlit in Snowflake uses a unique subdomain.

Ensure that *.snowflake.app is on the allowlist in your network and can connect to Snowflake. When this domain is on the allowlist, your apps can communicate with Snowflake servers without any restrictions.

Streamlit in Snowflake uses WebSockets. You must ensure that WebSockets are not blocked in your network configuration.

Error	Could not reload streamlit files. Error: 092806 (P0002): The specified Streamlit was not found.
Cause	The Snowflake WebSocket connection cannot reach the endpoint associated with the application.
Solution	Add *.snowflake.app to the allowlist on the organization’s firewall configuration.

You cannot access an external API¶

To access an external API, you must create a UDF specifying an external access integration, and call that UDF in a Streamlit app. For more information, see Using the external access integration in a function or procedure.

You cannot see your data or change your database¶

You might not be able to see your data or change database, warehouse, or role, because Streamlit apps run with owner’s rights, which means that they run with the privileges of the owner, not the privileges of the caller. Streamlit apps use the database and schema that the Streamlit in Snowflake app was created in, not the database and schema that the caller is currently using.

For more information, see Understanding owner’s rights and Streamlit in Snowflake apps.

Streamlit library feature does not work¶

Ensure you use Streamlit library version and a feature that are supported by Streamlit in Snowflake. For more information, see Supported versions of the Streamlit library and Unsupported Streamlit features.

For support on writing code for Streamlit apps, see Streamlit Community Forum.