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)
AS
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?