Hey Justin, you’re correct that you’d need both Dataset X and Dataset Y to see column lineage from Dataset X to Dataset Y.
One thing to mention is we’re doing some updates on the column lineage parser this week based on feedback from users last week when we released column lineage which will improve the column lineage from where it is today.