Depth of lineage

What lineage is supported

Statement \ Database	BigQuery	Snowflake	Redshift
SELECT	✅	✅	✅
CREATE TABLE	✅	✅	✅
CREATE VIEW	✅	✅	✅
UPDATE	✅	✅	✅
INSERT	✅	✅	✅
TRUNCATE	✅	✅	✅
MERGE	✅	✅	N/A
DROP TABLE	✅	✅	✅
DROP COLUMN	✅	✅	✅
ALTER COLUMN TYPE	✅	✅	✅
RENAME COLUMN	✅	✅	✅
RENAME TABLE	✅	✅	✅
SWAP TABLE	N/A	✅	N/A

SQL semantics supported

Feature \ Database	BigQuery	Snowflake	Redshift
UNNEST LINEAGE	✅	N/A	N/A
FLATTEN LINEAGE	N/A	✅	N/A
STRUCT FIELD LINEAGE	✅	N/A	N/A
PIVOTS LINEAGE	✅	✅	N/A
STRUCT CONSTRUCTOR FIELD LINEAGE	✅	N/A	N/A
USER DEFINED FUNCTIONS	✅	✅	✅
JSON objects	✅	✅	✅