Last Tested: Oct 29, 2019
TL;DR: The model configuration controls SQL Runner connection access.
The user needs the following to be able to see a connection in SQL Runner:
use_sql_runner
permissionAn easy way to give the user access to ALL connections which have models configured for them is to give them the manage_models
permission.
Source:
https://docs.looker.com/admin-options/settings/roles
This content is subject to limited support.