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.