cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Error when triggering a single job run with a Table update trigger

ssommer-ai
Visitor

When I trigger a single job run while having a Table update trigger, I get this error message.

ssommerai_0-1764617238499.png

It has issues with this parameter: 

- name: updated_tables
   default: "{{job.trigger.table_update.updated_tables}}"
I want to have the option of having the table update trigger and to be able to click "Run Now" without issue. 
Is this option available, or no?
1 REPLY 1

szymon_dybczak
Esteemed Contributor III

Hi @ssommer-ai ,

When you use a table update trigger with a parameter like {{job.trigger.table_update.updated_tables}}, this dynamic parameter only gets populated when the job is triggered by an actual table update event. When you manually click "Run Now", there's no table update context, so the parameter resolution fails.

What you can try to do - instead using Run now directly you can click 3 vertical dots next to it and then choose Run now with different settings

szymon_dybczak_0-1764623245054.png

Here just provide some text for this required parameter (or empty string). The job should start now properly.

szymon_dybczak_1-1764623453314.png