Embedding Sigma Dashboards in a Streamlit Web App

Sigma Computing

Sigma Computing is a user-friendly analytics platform that simplifies data exploration and analysis. It enables users, both technical and non-technical, to visualize and derive insights from complex datasets without heavy coding. Sigma fosters collaboration, connects to various data sources seamlessly, and prioritizes data security and governance, making data analysis accessible and actionable for all.

Introduction

Integrating Sigma dashboards into Streamlit apps combines Sigma Computing's data analytics prowess with Streamlit's seamless web app creation. By embedding Sigma's interactive reports using iframes, users can effortlessly access and engage with dynamic data visualizations within the Streamlit environment.

Pre-requisites

1. IDE or Text Editor.
2. Python v3.8 – Python v3.10.
3. PIP (preferred installer program).
4. Streamlit library (install via pip install streamlit)
5. Hydralit components (install via pip install hydralit-components)

Process

1. Once the dashboard is made, we need to get a link. We'll use this link to add the dashboard into the Streamlit app. Select the name located in the top-right corner, then proceed to click on "Administration."
2. Following that, click on "API & Embed Secrets" located at the bottom left of the page, under the warehouse views section.
3. Click the "Create New" button to access a form. Please ensure to complete all input fields as specified below. Finally, click "Create" to proceed.
4. Click on the down arrow symbol located after the title, then select 'Embedding'.
5. Select "Public" and choose your dashboard. Once selected, the URLs will be generated. Copy the 'Public link'.
6. Now, create a new .py file and input the following code.
7. Insert the previously copied Public link into the "report_url" variable and adjust the height and width as needed.
8. In your terminal, run the command streamlit run <filename>.py. This will launch the app in your browser, allowing you to view the Sigma dashboard embedded in Streamlit.

Conclusion

Through the integration of a dashboard link created with Sigma Computing into a Streamlit web application, users gain seamless access to view and interact with the dashboard within the Streamlit environment.