We are experiencing a similar issue, except with the storage credential resource. We created some storage credentials using Terraform, but when trying to destroy them using Terraform they were ignored. So we decided to manually delete the storage credentials through the UI, which worked. Then we reprovisioned the storage credentials with the same name using Terraform, and now we experience the same inconsistent behaviour with the CLI when querying the grants of the storage credential. In about 75% of the calls it returns the expected groups having access to the storage location, and in the other 25% it returns an empty result.

Note that this is not a CLI-only issue. This also happens when executing a `SHOW GRANTS ON STORAGE CREDENTIAL my_storage_credential` command using SQL.