databricks-demos / dbdemos

Demos to implement your Databricks Lakehouse
Other
255 stars 80 forks source link

dbdemos_lakehouse_fsi_credit_init_xxxx fails PERMISSION_DENIED: User does not have USE CATALOG on Catalog '__databricks_internal'. #74

Closed snowch closed 8 months ago

snowch commented 9 months ago

The job dbdemos_lakehouse_fsi_credit_init_xxxx is failing for me running this SQL:

[/Users/xxxx@databricks.com/lakehouse-fsi-credit/01-Data-Ingestion/01-DLT-Internal-Banking-Data-SQL](https://adb-xxxx.xx.azuredatabricks.net/?o=xxxx#workspace/Users%2Fchris.snow%40databricks.com%2Flakehouse-fsi-credit%2F01-Data-Ingestion%2F01-DLT-Internal-Banking-Data-SQL)

The error is:

PERMISSION_DENIED: User does not have USE CATALOG on Catalog '__databricks_internal'.
QuentinAmbard commented 8 months ago

Hi Chris, I believe it's a DLT bug, users shouldn't know about this catalog. Can you check if you have the permissions ? Maybe someone altered it but I don't think it's possible as it's internal only.

QuentinAmbard commented 8 months ago

looks like it's been fixed in ES-866429 - fixed will be released next from what I understood ?