SQL query can contain direct and indirect dependencies. Our SQL parser uncovers both types.

Turn on/off indirect dependencies

Simply select or deselect the checkbox from the Settings in the left panel.

Example of indirect dependency in SQL query

CREATE TABLE DWH.TMP AS
SELECT
  A.ACC_ID
FROM
  DWH.ACCOUNTS A
WHERE
  A.ACC_TYPE = 'LOAN'

When column is used to join, sort or filter then a column called SQLDEP-INDIRECT is created and linked to such filtering column.

Did this answer your question?