Lineage graph now working.

ThomasVanBilsen — Tue, 15 Aug 2023 14:52:45 GMT

Hey everyone,

I've run the following code successfully:

CREATE CATALOG IF NOT EXISTS lineage_data;

CREATE SCHEMA IF NOT EXISTS lineage_data.lineagedemo;

CREATE TABLE IF NOT EXISTS

lineage_data.lineagedemo.menu (

recipe_id INT,

app string,

main string,

dessert string

);

INSERT INTO lineage_data.lineagedemo.menu

(recipe_id, app, main, dessert)

VALUES

(1,"Ceviche", "Tacos", "Flan"),

(2,"Tomato Soup", "Souffle", "Brulee"),

(3,"Chips","Grilled Cheese","Cheesecake");

CREATE TABLE

lineage_data.lineagedemo.dinner

AS SELECT

recipe_id, concat(app," + ", main," + ",dessert)

full_menu

FROM

lineage_data.lineagedemo.menu

When I then query the system.access.column_lineage table I can see lineage records being added. But somehow no lineage shows up when I inspect the object through the UI. What could be the issue?

Re: Lineage graph now working.

youssefmrini — Wed, 16 Aug 2023 16:01:39 GMT

I recommend you open a ticket to the support.

topic Lineage graph now working. in Data Engineering

Lineage graph now working.

Re: Lineage graph now working.