If you encounter an error message containing the following in your php-errors.log file
No database connection configured for source plugin...
... it might be that the place you are the $databases['migrate']['default'] snippet is not correct; it needs to be positioned after the Acquia Cloud required line.
Troubleshooting the "No database connection configured for source plugin" error during a website migration | Acquia Product Documentation
Cloud Platform
Troubleshooting the "No database connection configured for source plugin" error during a website migration