Hello! I wanted to know if there is any way to specify writing "order" in catalog instances? After the execution of a pipeline I need to write on 2 tables, but I need to write first in table1 and then in table2 because there are foreign keys. how is the best way in kedro to make this constraint? Thanks in advance!

¡hola @Lucia Gonzalez! from a logical perspective sounds like then

table1

is a dependency of the node that writes on

table2

. to do this in Kedro I think you'd need to specify it as an input of the node that writes in

table2

, even if technically you're not using it (kind of like a dummy input)

sounds fine! gracias 🙂