FYI I found the answer to my problem and posted about it here on SO to share: https://stackoverflow.com/questions/56537214/creating-a-secret-scope-in-databricks-backed-by-azure-key-vault-fails/56537215#56537215
It was because I was using a user in D...
This did not work for me. I have the same error - including misspelling -
"Internal error happened while granting read/list permission to Databricks ervice principal to KeyVault: XYZ"
I'm assuming Databricks is using a default service principal in A...
To get the count of the distinct values:
df.select(F.countDistinct("colx")).show()
Or to count the number of records for each distinct value:
df.groupBy("colx").count().orderBy().show()