Use the function JSON_EXTRACT

Support
1

Hello, I made one query in redash, before i running this query, i running in mysql 5.7 using de Sequel.Pro and the query running correcty. But in redash is shown this error = Error running query: execute command denied to user ‘redash’@‘%’ for routine ‘core.json_extract’.
The query is :

SELECT json_extract(`businessExternalData`,'$.properties') `mail`,
       revokedAt `Revoked Date`,
       provider
FROM connect_oauth
WHERE businessId IS NULL
  AND revokedId IS NULL
  AND status = 'revoked'
  AND revokedAt IS NOT NULL
  AND businessExternalData IS NOT NULL
ORDER BY updatedAt DESC ;