Databricks SQL equivalent to "Create Trigger" logic?

If you store your data in Delta Format, you have access to a Change Data Feed.

If the data changes are new files appearing in your data lake, you can also use Autoloader to create a Streaming job that is triggered for each new file.