Code example: How to specify your own parent-child relationship in the import schema?

[dat-a-man]

Add an example to show how one could modify the import schema to specify which columns should be used to link child and parent tables (instead of the default _dlt_parent_id and _dlt_id

[dat-a-man]

After consulting with the team, it's confirmed that it's not possible to modify the import schema and directly push down columns from the parent table to the child table. To achieve this, you need to modify the resource itself. I am adding example in the code examples section to demonstrate how to do this.