SQLdep

Data lineage solution for SQL

Computer screen displaying SQL code Computer screen displaying SQLdep vizualization
See demo
Our products
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
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

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.”

Teradata logo
Microsoft SQL Server logo
Oracle logo
Redshift logo
Snowflake logo
PostgreSQL logo
Greenplum logo
Spark logo
Netezza logo
Hive logo
Impala logo

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 new team members

How it works

Submit SQL code
Use App Upload zip REST API
SQLdep calculates data lineage
Browse the result
In browser Download csv

Our features

Automated data lineage


Our reverse engineering algorithm transforms SQL code into an interactive map with end-to-end data lineage. Supported are all major database vendors and procedural code. A must have for legacy SQL code.

Metadata / Documentation Export


All metadata can be downloaded as a CSV file or directly through our API. Exports to PNG or PDF formats are available along with embedding our UI into your existing metadata platform.

Team management and Secure sharing


With team management you can easily invite your colleagues and share the documentation with them. Your documentation is protected by multiple layers of security with on option to flexibly manage the access.

REST API


SQLdep primarily runs as a cloud based service. No hardware needed, no installation needed. Everything runs in your browser out of the box. To interact with our service use REST API or our neat User Interface.

Tracking changes in the data lineage


Visually compare the changes within the data lineage across different environments, like staging versus production. Or compare how the data lineage differs in time based on your auditing requirements.

Highlighting relevant parts of SQL code


Quickly navigate through SQL code including subqueries. SQLdep provides simple user interface to browse the data lineage and show you relevant parts of SQL code. Highlighting is in place to save time of your engineering team.

Tech section

Where It Runs?

Cloud service
  • Everything runs in your browser out of the box
  • No hardware needed, no installation needed
  • Prefered option by 99% of our customers
On-site installation
  • Runs on server in your IT infrastructure
  • Software is distributed as VMware image
  • Enterprise edition only
What SQL syntax is supported?

Any valid SQL query regardless its complexity (with clauses, nested subselects, analytical functions, etc.).

Part of my lineage is in SQL and while the rest is buried elsewhere like Informatika, SAP, etc.

Get in touch with us. We will let you know whether we can help you with that.

How to automate uploads?

We recommend to use our REST API or our downloadable app and schedule the uploads.

Can I import lineage from SQLdep into a 3rd party metadata tools?

Of course, either use our existing integrations or a dedicated developer will help you with it. Your subscription fee covers this.

Security

SQLdep is trusted by large enterprise customers across Europe and United States. See high level platform Security overview [PDF]. SOC type 2 report will be available to your IT Sec team per request.

What happens if I upload an unsupported SQL syntax?

We guarantee to support any valid SQL syntax used by our paying customers. In case this happens we will work on it right away. About 95% of such occurrences are resolved within 2-3 days.

Can you help me with *something* during my trial/PoC?

Absolutely! Use the chat icon in bottom right corner in your dashboard.

Features roadmap

Tracking changes in the data lineage

You can visually compare the changes between the lineage across different environments like staging versus production. Or you can compare how the data lineage differs before and after the release on production. That also comes in handy if guys from the audit department stop by and start asking questions on how the data were calculated 2 months ago. You are a couple of clicks away to give a precise answer.

RELEASED 2016

Google login and team management

With team management you can easily invite your colleagues and share the documentation with them. Your documentation is safe with us and any new user needs to be authenticated first. For your convenience we have also added login through Google accounts.

RELEASED 2016

Tracking data lineage across multiple databases

Tracing data lineage manually between multiple databases is a complete nightmare. At SQLdep we automatically trace your data flows between any number of data marts or intertwined data warehouses. Support for database links is included as well.

RELEASED Q1 2017

Exports into CSV files

We compute the metadata and provide you with neatly done visualisations. Yet you might find helpful to download such metadata in textual form. You can perform your own ad hoc analysis or even further optimise your ETL processes. It is also very helpful when you have existing documentation and you need to verify it against actual code.

RELEASED Q1 2017

Complete impact analysis

Full impact analysis gives you instant and thorough view on any change you need to make in your data warehouse. Not only it saves your developers' time it also prevents the risk of them omitting any dependency. This includes all query clauses like WHERE, ORDER BY, GROUP BY.

RELEASED Q2 2017

Increasing data quality

Whenever you encounter problem with the corrupted data you need to immediately understand what reports have been affected. This feature allows for interactive search based on the actual data and values. Thus giving you the right tool for improving data quality.

RELEASED Q2 2017

Data Glossary: users can place and share comments about the data

Metadata management is about empowering you and your users with an option to describe your data lineage / flow. For example product profitability calculations are among the most complex within the company. Any user can now place a comment and explain any transformation which is then easily shared among the team.

RELEASED Q3 2017

Snowflake SQL dialect

Snowflake is a optimised database for Data Warehousing and it runs in cloud. SQLdep has complete support for SQL syntax used in Snowflake DB.

RELEASED Q4 2017

Integration into IBM InfoSphere Catalog

Automated integration with IBM metadata repository allows you to consolidate lineage from multiple sources.

RELEASED Q1 2018

Collibra integration

Tight integration with Collibra will ensure you have consolidated lineage. Using SQL in your infrastructure won't be a blind spot anymore.

Q2 2018

Integration with Informatica Metadata Manager

Tight integration with Informatica Metadata Manager will result into a consolidated lineage. Using SQL in your infrastructure won't be a blind spot anymore.

Q3 2018
Let us handle
your lineage.