I’m having issues connecting Domo to a MySQL database hosted with AWS RDS. Whenever I try to authenticate I get this error: “Failed to authenticate. Verify the credentials and try again. Domo is ready, but the credentials you entered are invalid. Verify your account credentials and try again. Error setting up SQL connection. Could not create connection to database server.
Tag: domo
calculate the percentage with sql and DOMO
I have a table where I want to calculate the percentage of revenue using the following formula: (Advertiser Revenue / Total Revenue) * 100. Data => Here is my code and what I have tried: Error: syntax error: execute command denied to user Answer In Domo, this calculation would best be done at the visualization layer using Beast Mode. Just