Snowflake Column-Level Lineage 2021.4

Refer to the table below for details about query grammar supported by the Snowflake column-level lineage parser add-on.

Grammar

Can Be Parsed

by QLI

Parent Level Lineage

(Tables and Files)

Column-Level

Lineage Parsing

CREATE TABLE AS SELECT (Basic)

CREATE VIEW AS SELECT (Basic)

CREATE MATERIALIZED VIEW (Basic)

INSERT

MERGE

UPDATE

CTAS with JOIN and USING keywords

CTAS with SET operations

CTAS with CTE

CTAS with recursive CTE

CTAS with CASE and WHEN

CTAS with subquery in result column

CREATE AS CLONE

CREATE AS LIKE

COPY INTO

*

CREATE TABLE

not applicable

CREATE EXTERNAL TABLE

*

**

not applicable

CREATE FUNCTION

*

not applicable

CREATE SCHEMA

not applicable

CREATE STAGE

*

not applicable

CREATE WAREHOUSE

not applicable

not applicable

CREATE PROCEDURE

*

not applicable

DELETE

not applicable

DROP

not applicable

DROP EXTERNAL TABLE

not applicable

DROP DATABASE

not applicable

not applicable

DROP PIPE

*

not applicable

DROP SCHEMA

not applicable

DROP STAGE

*

not applicable

DROP STREAM

*

not applicable

DROP TABLE

not applicable

DROP VIEW

not applicable

TRUNCATE TABLE

not applicable

ALTER TABLE

not applicable

not applicable

ALTER VIEW

not applicable

not applicable

ALTER WAREHOUSE

not applicable

not applicable

SELECT

not applicable

not applicable

* - Under consideration as a future improvement

** - Alation supports extracting external tables. Lineage will be added in the future.