Data Lineage From SQL Query (WIP)

How-to create data lineage from sql queries

Poom Wettayakorn

Jul 1, 2024

draft

👋 Hi there, welcome to Datascale: SQL+Data modeling. We help create database diagrams and map out data models from existing schema and SQL queries 🌱. Find us on LinkedIn 🎉

create table if not exists table_1 (
    id int not null,
    name string
);

create table if not exists table_2 (
    id int not null,
    name string
);

/* create a view depending on the to tables */
create or replace view view_1 as
select
    a.id,
    b.name
from table_1 as a
inner join table_2 as b
on

Related blogs

Contents

Section

Get a clear view of your SQL dependencies

Datascale helps reverse engineer data models from existing schema and SQL queries

Learn more

datascale

Where data gets modeled

datascale

Where data gets modeled

datascale

Where data gets modeled