Value that you’re looking for is exposed in resource output as Endpoint.Address
(https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html section Return Values).
Then, you can pass it to your Lambda function using Fn:GetAtt
like this:
functions:
helloFunction:
environment:
DATABASE_URL:
Fn::GetAtt:
- MarketDB
- Endpoint.Address