Job component in app platform to run rails migrations and this error occurs - URI::InvalidURIError: bad URI(is not URI?): ${db.DATABASE_URL}

I have a rails app with a managed development database and I am trying to add a job to migrate my rails app before each deploy.

I set the environment variable DATABASE_URL with a value of ${db.DATABASE_URL}.

But it seems like the connection parameters are not being passed and instead is passing a string directly which causes this error.

URI::InvalidURIError: bad URI(is not URI?): ${db.DATABASE_URL}

How can I pass the database connection parameters correctly in a job?