David_Dabbs
Databricks Partner

Thank you @lingareddy_Alva. Your considered response lives up to your forum title: Esteemed Contributor. 

1. Notification. 
Appreciate the confirmation that the determinism and control is worth the small bit of explicit configuration given the limited set of consumers.

Regarding table triggers, did I misunderstand the capability described here:  https://docs.databricks.com/aws/en/jobs/trigger-table-update?

Re. Option B, apologies for not having mentioned that we had already foreclosed on any AWS eventbus complexity. Option A is where we suspected we might end up. Regarding means to execute the cross-ws job, we assumed that since the producer will be running a notebook job it can initiate the target consumer jobs via API, e.g

# Point the client at consumer workspace...
w_b = WorkspaceClient(host="https://consumer1-workspace-host", token="<token-from-secrets>")
# Trigger workspace job
w_b.jobs.run_now(job_id=<client1-processing-job-id>)


2. Facade

Agree - we use VIEWS like this in legacy PG to reduce coupling for schema evolution. 


3. Triggering Postbacks
As my UK colleagues are fond of saying, "in for a penny, in for a Pound." Since we're already using explicit calls, it makes sense to apply that pattern on the return trip. Thanks for the confirmation. 

4. Tips

The `CAN_TRIGGER` permission on Jobs is workspace-local — you'll need to grant it per consumer workspace, but it's a one-time configuration per consumer onboarding.

Appreciate the pointers. So this configures a calling workspace, irrespective of service principal, the ACL to TRIGGER, and then a specific principal is granted a calling ACL?

Thanks,
DD