We practice “infrastructure as code” (aka “nothing is done manually”) in our AWS environment to create Looker’s resources: EFS, MYSQL RDS, ASG, ELB, etc. etc.
I noticed to enable “System Activity Pages” in Looker we have to manually run:
grant all on <DB_name>.* to <DB_username>@'%'; grant all on looker_tmp.* to '<DB_username>'@'%';
The looker.jar file’s looker-db.yml already has full admin access to the DB, so I would expect the looker.jar the ability to do all this.
Are there plans to not have this step be done manually? I guess I can create a script to run those commands when we are creating a new DB, but that is one more thing I’ll have to maintain.