Hi, I'm trying to migrate from kedro 0.17.* to kedro 0.18.* and having difficulty in credentials.yml. How to put the connection string from the environment variable into the con variable in the yml files? DataSetError: Could not parse SQLAlchemy URL from string '${dummy_con}'.

hello @Muhammad Ghazalli ! have a look at this: https://docs.kedro.org/en/stable/configuration/advanced_configuration.html#how-to-load-credentials-through-environment-variables

Try

# settings.py
class MyTemplatedConfigLoader(TemplatedConfigLoader):
    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)
        if self.runtime_params:
            self._config_mapping.update(self.runtime_params)

CONFIG_LOADER_CLASS = MyTemplatedConfigLoader # TemplatedConfigLoader
# Keyword arguments to pass to the `CONFIG_LOADER_CLASS` constructor.
CONFIG_LOADER_ARGS = {
    "globals_pattern": "*globals.yml",
}