BS_THE_ANALYST
Databricks Partner

@databricksero seems like you've identified the issue. It's certainly leaning towards the order of execution. 

Firstly, here's some great documentation on how DLT works conceptually: https://docs.databricks.com/aws/en/ldp/concepts 

Here's a 6 video Youtube playlist on Lakeflow Declarative Pipelines: https://youtube.com/playlist?list=PL7S7dD8r4QdU5FZzMNS7qlUkTEby6I9VK&si=kTN4bHCfbjHAAHyK it even has a project in there 😀.

@databricksero once you've created the LDP, I'm sure there's a way to export it as YAML etc. You can see how to string it together through code that way 🙂.

All the best,
BS