This is not currently possible in Databricks, but there is a feature in private preview that will allow exactly what you describe - table triggers (see here: https://www.linkedin.com/posts/laurentdhondt_databricks-azure-deltalake-activity-7200756908134154240-r89H/). Databricks announced it last year, but it's not yet been added to the main product.