CompilerWorks Lineage Live Demo
The demo environment you’re about to login to lets you explore lineage of a sample data warehouse with tables, columns, SQL statements, ETL pipelines, and users.
Check out the Quick Start Guide following the registration form below for an overview. And don’t forget to save your password. You can come back and log in any time to continue exploring.
Quick Start Guide
After signing in, you are presented with the instance panel showing the demo instance status.
Click Open to start the demo.
Launching the demo displays the Lineage entry screen with a search bar and three sample search options.
On your first visit to the demo, select from the pre-defined table searches to go to the Data Flow panel.
Diagraming Table Lineage
The Data Flow diagram shows all upstream and downstream tables, with the table you selected centered and highlighted in purple. In addition to tables, this display shows the names of pipelines that affect this and other tables.
Scroll to zoom in and out of any diagram. Click any element to refocus the diagram.
Clicking on the Columns icon reveals the columns in each table.
Tracing Column Lineage
Clicking a column name lets you trace its lineage.
Click on an edge (a line with an arrow) to get a semantic summary of the action connecting two elements
Displaying SQL Statements
Click on Code in the upper right corner of any diagram panel to display the SQL statements associated with elements in the diagram. Use the timeline scrub bar to trace previous executions of the SQL code.
Use the Back button or table name and pipeline name links to recenter the display on the Data Flow diagram.
Integration and the Lineage API
The Live Demo is a fully functioning copy of the Lineage user interface and the Lineage GraphQL API. The API lets you integrate Lineage with other data warehouse management tools and in-house apps. The demo includes the GraphiQL console: an IDE for writing and validating GraphQL queries run directly against the Lineage graph. The console support syntax highlighting and validation, typeahead suggestions, tab completion, and interactive documentation.
The Lineage graph is built automatically using SQL logs and ETL pipelines from your production environment and automatically updates as your production environment changes.
At no point does Lineage touch your data.
This Quick Start Guide gives you a taste of the capabilities of Lineage. Explore the demo at your own pace to discover more.
CompilerWorks Lineage gives you the visibility to make informed decisions about authenticity, governance, and data migration. No other data lineage tool offers the breadth, visualization, automation, and integration of CompilerWorks Lineage.
“Without CompilerWorks software, we would not have been able to migrate our critical risk models in the targeted timeframe. Lineage reduced our EDW TCO by $12 million per year.”
Marcel Kramer, Director of Data Engineering | ABN AMRO Bank N.V.
Systems Integrator Partners
Interested in a demonstration of Lineage in your environment?