Kedro is an open-sourced Python framework for creating maintainable and modular data science code.

Kedro

Hi,

How can I parameterised a SQL data query based on the parameters.yml file?

for example in catalog.yml I have

```my_sql:
 type: pandas.SQLQueryDataset
 sql: "SELECT * FROM [ABC].[date_20180401]"
 credentials: mycred```
I want to use the following parameter from parameters.yml

```ABC:
 latest_date: "20180401"```
So the expectation in  catalog.yml would be something like
```my_sql:
 type: pandas.SQLQueryDataset
 sql: "SELECT * FROM [ABC].[date_{params[ABC.latest_date]}]"
 credentials: mycred```


I think <https://docs.kedro.org/en/stable/configuration/advanced_configuration.html#how-to-use-global-variables-with-the-omegaconfigloader|using globals> might be more suited to this particular case instead of parameters

<@U03RYKESV0S> thanks for the tips! I read about global.yml and I thought that it's also possible to reference the parameters from the parameters.yml file.

I'll explore using global.yml