Hi,
The architecture of my data platform is such that data moves from Kafka to S3 to Snowflake. On Snowflake, we have written Airflow tasks that convert one table to another. I have ingested metadata from the three and it looks good. Now, I want to be able to view the lineage around this (Kafka -> S3 -> Snowflake table1 -> Airflow -> Snowflake table2 -> Airflow -> Snowflake table3). In this, do I have to manually add upstream and downstream for each of these platforms and draw the lineage or can it be done automatically somehow?
PS. Our Snowflake is the Standard Edition and not the Enterprise Edition