ELTMaestro WPF Client — User Guide

End-user / operator guide to the ELTMaestro desktop (WPF) client: signing in, the main window, the Admin Interface, the menus, and building & running workflows.

Status: complete — all four phases written. (Living doc — update as the UI evolves.)

This is the task-oriented user guide. For related material: - Server install / day-to-day ops → INSTALL.md, OPERATIONS.md - Per-platform connection setup → REDSHIFT-SETUP.md, SPARKSQL-SETUP.md, CLICKHOUSE-AUTH.md - WPF internals (for developers) → WPF-CLIENT.md

Contents

1. Getting started — UG-GETTING-STARTED.md

• ✅ Signing in & first-time setup
• ✅ Main window overview (the Workflow(s) window)
• ✅ Menu bar at a glance

2. Administration & Setup (first-time initialization) — UG-ADMIN.md

The administrator's setup guide — start here after first sign-in. The connections you create here (databases, SSH hosts, cloud/S3) are the initialization step, and they're exactly what the Job editor draws from when you design workflows. - ✅ Opening the Admin Interface - ✅ Connections — Database (JDBC) · SSH · General/Cloud (S3) - ✅ Connection recipes — SparkSQL & Redshift jobs - ✅ Users · User-Permissions - ✅ System · Integrator Config · Maestro ML · vendor tabs

3. Menus in depth — UG-MENUS.md

• ✅ File ▸ Theme
• ✅ Administration ▸ Metrics Configuration · Workflow Configuration · Scheduler · Migration
• ✅ Runtime & Logs ▸ Logging · Reports · Runtime Operations
• ✅ Help ▸ About · License · Developer Options

4. Workflows — UG-WORKFLOWS.md

• ✅ Creating a workflow (job)
• ✅ Configuring job metadata
• ✅ The Job editor — adding & connecting steps · expression builder
• ✅ Executing a workflow · monitoring
• ✅ Tying it together: lineage, email alerts, scheduler

5. Step reference — UG-STEPS.md

The catalog of step types you add in the Job editor — what each does, its WPF dialog, and key options. Scoped to the documented platforms (Redshift, Snowflake, ClickHouse, SparkSQL). - ✅ Common steps — sources, transforms, DQ, control, transfer, scripting & jobs, export - ✅ MPP-common steps — Table, View, Sql Metrics, Write File, SCD1/SCD2 - ✅ Platform-specific steps — the JdbcTarget* loaders, Onstage Group (incl. the SparkSQL folder-target variant), and the full SparkSQL set - ✅ Tie-back to architecture — each step mapped to its medallion layer

6. Design patterns — Medallion architecture — MEDALLION.md

Designing Bronze → Silver → Gold pipelines with ELTMaestro steps — the layer-to-step mapping, the orchestration spine (JobStep chaining, scheduler, alerts), the Silver quality gate, and lineage/observability. - ✅ Layer → step mapping - ✅ The orchestration spine - ✅ The Silver quality gate - ✅ Design principles - Per-layer deep-dives: 🥉 Bronze · 🥈 Silver · 🥇 Gold