I’m facing “Too many connections” issues in my MySQL data source (Amazon RDS) when using Looker Studio. Each Looker component is fed by a database table and the tool opens a new connection for all components with each filter or page update. As a result, many simultaneous connections are quickly opened in the database and it is possible to see that when reaching more than 50 connections, the error “Too many connections” is returned.
Is there any way to optimize these database accesses by Looker Studio? The correct thing would be for the connections to be closed after the query, but this does not seem to happen.