/snowflake-table-catalog

Streamlit application to explore Snowflake Tables

Primary LanguagePythonMIT LicenseMIT

Snowflake Table Catalog with Streamlit

This is a streamlit demo application that visualizes the table metadata from SNOWFLAKE database and helps exploring tables.

Snowflake provides a system-defined, read-only shared database named SNOWFLAKE that contains metadata, as well as historical usage data, about the objects in your organization and accounts. This database provides information about your tables as well.

Whenever you want to understand your tables, you can query these tables directly and get the required information. On the other hand, you can use streamlit to create applications to monitor usage or metadata from Snowflake.

Enjoy this online demo application hosted in Streamlit cloud with demo data. https://snow-table-catalog.streamlit.app/

This is an image

Prepare Your Application

Set up credentials. Create a file .streamlit/secrets.toml and fill in your Snowflake account credentials. The file should look like this:

[snowflake]
user = "..."
password = "..."
account = "..."
warehouse = "..."
role = "..."

Role should have access to Snowflake Account_Usage Database and Schema.

Run Your Application

streamlit run snowflake-table-catalog.py

or

python -m streamlit run snowflake-table-catalog.py

Edit: Application was tested with Streamlit 1.11.1 and Snowflake Python Connector 2.7.7.