Sync table A to table B, triggered by any change in table A.

Yarden
New Contributor

Hey,

I'm trying to find a way to sync table A to table B whenever table A is written to. just with a trigger on write.
I want to avoid using any continuous runs or schedules.
Trying to get this to work inside Databricks, without having to use any outside listeners/triggers.

I tried looking into using a workflow that's triggered by new files in a volume - but I couldn't create a volume that is on the same location of the table I want to monitor.

What is the way to achieve this?

Thanks,
Yarden.