Data lineage includes a database table if data is extracted from or loaded to the table. If the table is included in a join statement but no data is extracted from or loaded to it, the table does not appear in data lineage.
For example, an SQL view includes two tables, CUSTOMER and CITY as described in the following SQL:
CREATE VIEW SF_CUST_VIEW AS SELECT CUSTOMER.ID, CUSTOMER.NAME
FROM CUSTOMER, CITY
WHERE CUSTOMER.CITY_ID = CITY.ID AND CITY.NAME = ‘SFO’
Because the view only exposes data from the CUSTOMER table, the CITY table does not display in data lineage for the view. Instead, data lineage displays the CITY table as a Related Catalog Object of the view.