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.