Skip to main content
Skip table of contents

Column Lineage limitations

K processes lineage across numerous sources however there are some scenarios where lineage and the grain of lineage is limited.

This page will cover known limitations and any remediation available or planned.

Issue

Example

Fix

Workaround

1

Nested SELECT * from a CTE not supported

CODE 
CREATE TABLE MAIN.FOOBAR AS (
    WITH FOO AS (
        SELECT COL1, COL2 FROM FROM MAIN.BAR
    )
    SELECT * FROM FOO
)

Under investigation

Use Bulk Lineage Mapper to map columns between source and target tables.

2

SELECT * with Unions not supported

CODE 
CREATE TABLE MAIN.FOOBAR AS (
    SELECT * FROM MAIN.BAR
    UNION
    SELECT * FROM MAIN.BAR2
    UNION
    SELECT * FROM MAIN.BAR3
)

Under investigation

3

Insert into statements currently skipped in processing

CODE 
INSERT INTO FOOBAR (
    COL1, COL2 )
    SELECT COL1, COL2 FROM FOO
)

Investigation completed.

Fix pending.

Target release in Q1 25

4

Copy grants in statements currently causes statement to be skipped in processing

CODE 
CREATE OR REPLACE VIEW MAIN.FOOBAR COPY GRANTS AS (
    SELECT * FROM FOO
)

Investigation completed

Fix pending

Target release in Q1 25

5

Code that is not currently wrapped in a CREATE statement

e.g. DBT code from manifest (represented as a select statement)

Investigation completed

Fix pending

Target release in Q1 25

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close