Customer 360 Enterprise Data Platform — Denodo on Azure  ·  View 30 of 39  ·  Operations

Environments and Delivery

How a view change reaches production, and the three gates that stop a bad one.

Editable source SVG draw.io All views
Author Design Studio development server VQL export text, diffable Version Git repository Azure Repos Pull request one view set Validate VQL lint naming, layering Regression suite 180 queries Policy scan no unmasked PII Approve Peer review Steward sign-off certified views only Promote Solution Manager revision, one artefact Environment properties no hard-coded hosts Environments Test masked subset UAT production shape Production change window row counts differ rollback to prior revision How a View Change Reaches Production, and What Stops a Bad One Application we own Data store Decision point failure / alternate The regression suite asserts row counts and column sets against a frozen dataset, so a widened join is caught before UAT rather than by a report that quietly doubles. v 1.0 · owner Data & AI Global Practice · date 2026-09

Decisions

  • Views are exported as VQL text and versioned in Git. A view change is a diff, a pull request and a review, exactly like application code.
  • The regression suite asserts row counts and column sets against a frozen dataset, so a widened join is caught before UAT rather than by a report that quietly doubles.
  • The policy scan fails the build if a personal-data column appears unmasked in a published view — a security regression is a build failure, not a finding.

Promotion

  • Solution Manager promotes one revision as a single artefact. Environment-specific values are properties, so the same artefact runs in Test, UAT and Production without editing.
  • Rollback is redeploying the prior revision, and it is exercised, not assumed.

Numbers

  • 180 regression queries; suite runs in about 11 minutes. Test uses a masked subset, UAT a production-shaped copy.
  • Certified views additionally require steward sign-off, which is the slowest gate and deliberately so.
◀  Workload Isolation All views Observability  ▶
Solution Architecture v1.0 · Data & AI Global Practice · 2026-09 · 39 views · Denodo Platform, Microsoft Azure and open source30-cicd-and-environments