Skip to content
DWHFactory

The operating system

The operating system for your data warehouse

SQL is the engine. Your procedures are the programs. The Solution is the operating system.

Your SQL stays. But now your warehouse can explain itself.

The Solution puts a template around every existing job. The procedure does what it always did. What is new: it records what it read, what it wrote, whether the tests passed and who approved the last change.

FIG. 04 Before and after. Left, 1.0: three unconnected procedures; the figure is there, its source is not. Right, 1.5: the same procedures, connected, with a path back and an audit trail: requested, built, approved.

What every job gains

  • Job templates

    Your existing procedures get a template around them. Telemetry, lineage and control are added without changing the SQL.

  • Lineage graph

    Trace any figure back to its source. Or look the other way: what does it touch downstream if this table changes?

  • Delta reporting

    What changed since the last accepted version, and why. With the explanation, not only the difference.

  • Test coverage

    One view of which procedures are tested and which are not yet.

  • Audit trail

    Requested, built, approved. For every change, with no gaps.

One figure. One path back to the source.

When the regulator asks where € 12.4m comes from, the answer is a path, not a search.

FIG. 03 Lineage. The sources orders, customer and product run through load_revenue to the figure € 12.4m and on to board_pack. One figure, one path back to the source.

Want to see it run on your own backlog?

In a thirty-minute demo we walk one change through, from request to approved pull request. After that you know whether this fits your warehouse.

Book a demo