Telecom network operations teams face the challenge of monitoring thousands of network elements across RAN, Transport, and Core infrastructure while meeting stringent SLA requirements. This guide demonstrates how to build a comprehensive network operations solution using Snowflake Intelligence and Streamlit in Snowflake.

In this Guide, you will build a complete network operations platform that:

The Network Operations solution provides end-to-end visibility across telecom infrastructure:

Data Layer:

Application Layer:

The solution includes approximately 600,000 performance records across:

In this step, you'll create all the Snowflake objects needed for the Network Operations solution.

1. In Snowsight, click Projects, then Workspaces in the left navigation, or click here to go there directly
2. Click + Add new to create a new Workspace
3. Click SQL File to create a new SQL file
4. Copy the setup script from setup.sql and paste it into your SQL file

Run the setup script to create:

The setup script automatically loads all data from GitHub using an External Access Integration. No manual file downloads required!

The script creates a LOAD_DATA_FROM_GITHUB() procedure that:

1. Connects to GitHub using the External Access Integration
2. Downloads all 13 CSV files directly from the repository
3. Loads data into the appropriate tables

After running the setup script, verify the record counts:

The setup script also automatically downloads and deploys the Streamlit application from GitHub!

The script creates a LOAD_STREAMLIT_FROM_GITHUB() procedure that:

1. Downloads streamlit_app.py and environment.yml from GitHub
2. Uploads them to the STREAMLIT_STAGE
3. Creates the NETWORK_OPS_DASHBOARD Streamlit application

In Snowsight, click Projects, then Streamlit in the left navigation and select NETWORK_OPS_DASHBOARD, or click here to go there directly.

The Network Engineer dashboard focuses on real-time troubleshooting:

Key Features:

The Network Performance dashboard focuses on capacity planning:

Key Features:

The Network Manager dashboard focuses on SLA management:

Key Features:

The Executive dashboard focuses on business impact:

Key Features:

In Snowsight, click AI & ML, then Snowflake Intelligence in the left navigation.

The setup script automatically creates the Semantic View and Snowflake Intelligence Agent:

Semantic View (NETWORK_SEMANTIC_VIEW):

Snowflake Intelligence Agent (NETWORK_OPERATIONS_AGENT):

Try these persona-specific queries:

1. RRC Success Rate Troubleshooting

Identify cells falling below the 95% RRC success rate target.

Which cells have RRC success below 95% right now?

2. Critical Capacity Alerts

Find sites with PRB utilization above 85% (critical threshold).

Show me the top 10 sites with critical PRB utilization above 85%

3. 5G Session Issues

Identify 5G cells with PDU session establishment problems.

Which 5G cells in Lisboa have PDU session issues?

1. Technology Comparison

Compare average throughput between 4G and 5G across regions.

Compare average throughput between 4G and 5G by region

2. Regional Trend Analysis

Analyze PRB utilization trends to predict capacity needs.

What is the PRB utilization trend for Porto this week?

3. Congestion Risk Assessment

Identify regions with the highest congestion risk based on utilization patterns.

Which regions have the highest congestion risk?

1. SLA Compliance Overview

Monitor how many sites are currently below SLA targets.

How many sites are currently below SLA targets?

2. Capacity Planning Data

Review availability metrics by city to inform capacity planning.

Show availability metrics by city for capacity planning

3. Regional Priority Assessment

Determine which region has the most sites needing attention.

Which region has the most sites needing attention?

1. Network Health Overview

Get a high-level view of overall network health across Portugal.

What is our overall network health across Portugal?

2. 5G Investment ROI

Compare 5G vs 4G performance to validate technology investment.

Show 5G vs 4G performance summary for board reporting

3. Investment Prioritization

Identify which regions should be prioritized for network investment.

Which regions should be prioritized for investment?

To remove all resources created by this guide:

1. Open your setup.sql Workspace (the same one you used during setup)
2. Scroll to the TEARDOWN SCRIPT section at the bottom
3. Uncomment the DROP statements
4. Run the teardown commands

The teardown script will remove the agent, Streamlit app, database, warehouses, and all other objects created by this guide.

Congratulations! You have successfully built a comprehensive telecom network operations solution with Snowflake Intelligence.

Snowflake Documentation: