SQLdep

Data lineage solution for SQL

Computer screen displaying SQL code Computer screen displaying SQLdep vizualization
See demo
Our solutions
QueryScope
for single query
  • Great for individual developer or BI analyst
  • Diagrams with table joins
  • Interactive SQL code highlighting
  • Quick list of all used tables and columns
  • Read more
QueryFlow
for multiple queries
  • Enterprise solution for BI/DWH teams
  • End-to-end data lineage
  • Team management and secure sharing
  • Metadata and data lineage import/exports
  • Read more

Why data lineage

Risk prevention

”SQLdep reduced number of incidents caused by overlooked dependency during ETL development by 20%.”

Reduce vendor dependency

”SQLdep helped us to mitigate the risk of vendor lock-in. Any change in ETL made by vendor is now automatically documented and know-how is kept in house.”

Regulatory requirements

”SQLdep provides insight of all data flows in DWH and prepares output for auditing.”

”We tremendously accelerated the development cycle and incident management in our data warehouse.”

Compliance with GDPR, BCBS 239, HIPAA

AUDITOR

  • Mark columns with sensitive data & track them in the DWH
  • Audit trail for all data transformations
  • Have automated reports with end to end data lineage

DATA CONSUMER

Mission: Capture the context to avoid meaningless data

Show more
  • No conflicts between reports done by different departments
  • Data stewards & analysts share knowledge among the teams
  • An automated overview of any change impacting the data

DEVELOPER

Mission: Innovate our technology stack

Show more
  • Detect unused columns and optimise DWH
  • Decrease number of incidents due to overlooked dependencies
  • Faster on-boarding of a new team members
Save time, become a SQL superhero!