A complex query works in Looker SQL Runner but I prefer executing a stored procedure. When I entered exec storedprocedurename I got “The EXECUTE permission was denied on the object storedprocedurename, databasename, schema”. Please advise how to exec a stored procedure from Looker.
Thanks.