LogoLogo
  • Introduction
    • Overview
    • Why Alvin?
    • Connect your systems
      • Data Warehouse
        • BigQuery
          • Provision source system credentials
          • Provision with GCloud CLI
        • Snowflake
        • Databricks
      • Business Intelligence
        • Looker
      • Orchestration
        • dbt
      • SSO (Single Sign-On)
    • Security & compliance
    • Types of metadata
    • FAQ
  • Cost Monitoring
    • Introduction to Cost Monitoring
    • Compute
    • Storage
  • BI Query Optimizer
    • Introduction to Query Optimizer
    • How does it work?
    • Getting started
  • Workflow automation
    • Introduction to Workflow Automation
    • Events definitions
    • Configuring Workflows
  • Anomaly Detection
    • Anomaly Detection
  • Exploring Metadata
    • Lineage
      • Depth of lineage
    • Impact Analysis
    • Entities
    • Entity View
    • Metadata Warehouse
Powered by GitBook
On this page
  1. Exploring Metadata
  2. Lineage

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

✅

✅

✅

PreviousLineageNextImpact Analysis

Last updated 5 months ago