Symptoms

One or more SQL Macro returns the following error:

Error rendering macro 'sql-query' : Unable to connect to database using jdbc:mysql://<HOSTNAME>:<PORT>/<DBNAME> with user <USER>

Cause

Your SQL Macro is referencing a Data Source Profile that has one or more incorrect connection configurations. 

Resolution

Double check the connection information associated with this Data Source Profile (Hostname, Port, Database, Username, and Password).