PeriscopeLead pipeline analytics for Marketing Technology

Internal Avalara dashboard that aggregates Snowflake + Salesforce data, exposes a Spring Boot API, and renders a React SPA for filtering, exporting, and AI-powered lead summaries.

Architecture

Developer Guide

View on GitLab

Architecture

System overview, component diagrams, data flow, caching strategy, security model, and infrastructure.

Read the architecture

Developer Guide

Local setup, project structure, backend/frontend patterns, testing, environment variables, API reference, and Docker.

Get started

Snowflake Data Model

Source tables, joins, region-based caching, and the canonical lead pipeline view that powers every API endpoint.

Explore the data model

Snowflake Queries

Working query reference — KPIs, region filters, composition mix, and the SQL used by each backend endpoint.

View the queries

Okta Integration

OAuth2 / OIDC integration plan, JWT validation in Spring Security, and frontend session handling via the Okta React SDK.

Review the auth model

Test Cases Inventory

Backend (JUnit 5 + AssertJ) and frontend (Vitest + Testing Library) test coverage, organised by feature.

Browse the inventory

Stack

Java 21 · Spring Boot 3.4 · React 19 · Vite 8

Data

Snowflake · Salesforce · Caffeine + EFS

Infra

AWS ECS Fargate · ALB · Route53

Auth

Okta OIDC · JWT (RS256)

About this site

This is the canonical, live documentation for Periscope. It is generated from every Markdown file under docs/ in the repository and redeploys automatically on every push to develop or main. Edit a file, push, and the site is live within minutes.

devdocumentation.periscope.dev.avlr.net

proddocumentation.periscope.avlr.net