Skip to main content
Skip table of contents

ENABLE_DATA_LINEAGE

You are looking at an older version of the documentation. The latest version is found here.

This default option controls whether a data lineage plan is generated and stored for each executed SQL query or not. It can take the following values:

ValueDescription
TRUE
  • Data lineage plan is automatically generated at runtime for each executed SQL query and stored to the configuration database;
  • XML representation of the data lineage plan for SQL query can be retrieved using the SYSADMIN.getDataLineage procedure or EXPLAIN command;
  • SYSLOG.getQueryLogDataLineage procedure returns a stored lineage plan for a specific entry in the SYSLOG.QueryLogs table

FALSE

  • Data lineage plan is not autogenerated at runtime and thus is not stored;
  • XML representation of the data lineage plan for a specific query can only be obtained via the SYSADMIN.getDataLineage procedure. The EXPLAIN command returns NULL as a value for the DATA_LINEAGE_XML column;
  • SYSLOG.getQueryLogDataLineage returns NULL for the queries executed after setting this value for the ENABLE_DATA_LINEAGE option as there are no stored plans for them;
  • Default value

Example

SQL
CALL SYSADMIN.setDefaultOptionValue('ENABLE_DATA_LINEAGE', TRUE);
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.