Hi @Greg_c ,
In Databricks Asset Bundles you have a possibility to pass parameter to SQL File Task.
Here is end to end example:
1. My SQL File (with :id parameter):

2. The job YAML:
resources:
jobs:
run_sql_file_job:
name: run_sql_file_job
tasks:
- task_key: run_sql_file_task
sql_task:
parameters:
id: "1"
file:
path: /Workspace/Shared/sql_file_with_parameter.sql
source: WORKSPACE
warehouse_id: b277bba4a65e4c55
queue:
enabled: true
3. The result:

4. The difference between your code and the example is you define parameters one level up compared to what is the working yaml:
tasks:
- task_key: process_data
parameters:
input_table: ${parameters.source_table}
vs.
tasks:
- task_key: run_sql_file_task
sql_task:
parameters:
id: "1"
Let me know if that helps.