Skip to main content

WDP Palantiri

Wasteology Data Platform - Monitoring & Operations UI

Palantiri is a Streamlit-based web application for managing and monitoring the Wasteology data platform. It provides a unified interface across 11 specialized pages spanning monitoring, AI agent management, data management, and financial operations.

Live Application

Architecture

Highlight:allauthmigrationprefectdbt
User BrowserAzure ADStreamlit UIMigration EngineParquet ModeSling ModePostgreSQLAzure SQLPrefect Clouddbt Cloud

Key Features

🔄

Migration Tool

Migrate data between PostgreSQL and Azure SQL with Parquet or Sling modes

📊

Data Browser

Browse schemas, tables, and preview data across all connected databases

Prefect Monitoring

Monitor flow runs, view task breakdowns, and trigger migrations manually

🔗

dbt Lineage

Visualize dbt model DAG with interactive upstream/downstream highlighting

🚦

CI/CD Dashboard

Live operations view for Prefect ingestion health and dbt production pipeline status

🗂️

Project Overseer

Unified portfolio monitoring with pipeline alerts, 30-day health trends, and digest tasks

🤖

Tirion AI Agent

Real-time monitoring dashboard for the Tirion autonomous AI agent and its OODA loop

🔐

DB Access Manager

Visual RBAC management for all Wasteology PostgreSQL databases with dry-run diffing

💰

QuickBooks / ACH

ACH validation, contact management, and QBO financial views across all 11 entities

📡

Enevo Sensors

IoT sensor data browser and ETL health monitor for active Enevo customer containers

🧭

Portfolio Intelligence

Strategic portfolio knowledge graph and natural language query interface

Supported Databases

Palantiri connects to four Wasteology database environments:

DatabaseTypeEnvironment
PostgreSQL ProductionPostgreSQLProduction
PostgreSQL DevelopmentPostgreSQLDevelopment
Azure SQL ProductionAzure SQLProduction
Azure SQL DevelopmentAzure SQLDevelopment

Quick Start

Running Locally

# Clone the repository
git clone https://dev.azure.com/wasteology/Wasteology/_git/wdp-palantiri
cd wdp-palantiri

# Install dependencies
uv sync

# Configure environment
cp .env.example .env
# Edit .env with your database credentials

# Run the application
uv run streamlit run app.py

The application will be available at http://localhost:8501.

Azure Deployment

Palantiri is deployed via Azure Container Apps and automatically deployed via ADO CI pipeline on push to main. For manual deployment:

cd ~/projects/orchestration/wdp-palantiri && ./scripts/build-and-push.sh --deploy

Authentication

Palantiri supports two authentication modes:

  1. Password Protection - Simple password via STREAMLIT_PASSWORD environment variable
  2. Azure AD - Enterprise authentication via MSAL (configured via AZURE_AD_* environment variables)
tip

For local development, leave STREAMLIT_PASSWORD unset to bypass authentication.

Next Steps