Hello Kedro team, I am trying to pass parameters to a SQL query at runtime. Following the documentation here, I added the following in my catalog:

batches : 
  type: kedro_datasets.pandas.SQLQueryDataset
  sql : SELECT * FROM batches WHERE id = ${runtime_params.batch_id}
  credentials: ...

I’m running the following command

kedro run --params=batch_id=123

and getting this error

omegaconf.errors.InterpolationKeyError: Interpolation key 'runtime_params.batch_id' not found

Could someone help understand how to implement this? Thank you in advance!

Hey, try ${runtime_params:batch_id} in your catalog, with a colon!

oh spot on, thank you!