cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Lineage graph now working.

ThomasVanBilsen
New Contributor III

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?
1 ACCEPTED SOLUTION

Accepted Solutions

youssefmrini
Honored Contributor III
Honored Contributor III

I recommend you open a ticket to the support.

View solution in original post

1 REPLY 1

youssefmrini
Honored Contributor III
Honored Contributor III

I recommend you open a ticket to the support.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!