Symptoms

One or more SQL Macro returns the following error:

Data source '<NAME>' not found.

Cause

Your SQL Macro is referencing an incorrect data source name, or, the data source profile has been removed. 

Resolution

As data source names are case sensitive, make sure you use the same name with the correct case as configured.