Skip to main content
Solved

Table Inserts and Object Dependencies


p.ruijter
Contributor
Forum|alt.badge.img

I have a table with a table Insert from a view (actually multiple views) underneath it. The problem is that this table sometimes is empty because the Data Lineage is wrong. It seems that we need to have Object Dependencies for Table Inserts. 
2 Questions about that: 

  1. When creating a "Table Insert" get a message that "Object Dependencies" are required?

  2. Is it enough to check the next child view (in my case) in the "Object Dependencies" if you have one table insert? Or should it be the first child table? Or should all underlying views/tables be included?

Best answer by Thomas Lind

Hi Patrick

I would set the object dependencies on the tables that the views use.

For reference I have a custom table insert that uses a stored procedure and two tables.

If I were basing my table insert on a view, I would still set the object dependencies to the tables the view used.

Besides that I always map my views, so the linage works through them.

 

View original
Did this topic help you find an answer to your question?

2 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • Answer
  • March 8, 2023

Hi Patrick

I would set the object dependencies on the tables that the views use.

For reference I have a custom table insert that uses a stored procedure and two tables.

If I were basing my table insert on a view, I would still set the object dependencies to the tables the view used.

Besides that I always map my views, so the linage works through them.

 


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @p.ruijter is your issue resolved? If so can you please help us by marking the best answer?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings