I am an ETL developer.
I used pyspark language in Databricks. The data comes in Azure blob storage, from there I fetch the data, transform them as per business requirement and write in a snapshot path or Synapse (As per requirement).
In the attached image, I tried to ingest data where the source and target put as invisible areas. I only write the function and did the ingestion.