I have manually copied my driver to /$AquaStudio.app/Content/Java/Drivers/specific_driver. I tried connecting to Generic JDBC URL using this driver class. In windows it all works fine. But in Mac it is throwing error 'Driver com.amazon.redshift.jdbc42.Driver does not accept url jdbc:redshift:*********'.
It appears that the driver is being loaded correctly but doesn't understand the sub-protocol in the URL. Without seeing the URL and knowing your server and ADS version, we really can't debug it. Also, looking at your datastudio logs might help track down the problem. Perhaps it would be better to open a support issue at https://www.aquafold.com/support_request