Hi guys, Quick question Is there a way to interpolate a SQLDataset query in

catalog.yml

passing some argument\parameter. Example:

yaml
person:
  type: pandas.SQLQueryDataSet
  sql: "SELECT * FROM public.people WHERE id = ${id};"
  credentials: db_credentials

Thanks in advance!

you can use TemplatedConfigLoader to do this

@Juan Luis do you have the example snippet you used recently (on the Kedro-Polars demo) handy?

@datajoely Thanks, it seemed to work.

would you mark as answered on StackOverflow? 🙂

Sure, just to 2 minutes to allow me to do that. Should have asked here directly.

No worries!

@datajoely Is there a way to pass the parameter from inside kedro node instead of using globals?

for future reference: https://github.com/astrojuanlu/talk-kedro-polars/blob/5e28a15bfd6dccded635906b4490e6fac90f0614/src/talk_kedro_polars/settings.py#L41-L51 https://github.com/astrojuanlu/talk-kedro-polars/blob/5e28a15bfd6dccded635906b4490e6fac90f0614/conf/base/catalog.yml#L10-L12

@Nikola Shahpazov sort of - if you override a specific

parameters

those can passed to nodes