TEMPORARILY_UNAVAILABLE: The service at /api/2.1/unity-catalog/tables is taking too long to process

Bedoonraj
New Contributor II

I'm using DBT to run a model in databricks. I have view model, which holds 2 months of data (~2 million). There is no wide dependency transformation. All are case when statements. Total column no is 234. Till yesterday view was running fine. but today onward, i'm getting below error

TEMPORARILY_UNAVAILABLE: The service at /api/2.1/unity-catalog/tables is taking too long to process your request. Please try again later or try a faster operation.

Khaja_Zaffer
Esteemed Contributor

Hello @Bedoonraj 

From what I see https://status.azuredatabricks.net/ there are no such issues. 
Just want to check whether it has resolved by itself as it mentioned like please try again later?

Bedoonraj
New Contributor II

I tried for 1-2 days, still same error. I changed to table materialization, then only it worked. Any reason view is failing?

WiliamRosa
Databricks Partner

Hi @Bedoonraj,
I tested the API call and it worked fine. I also confirmed, just like Khaja_Zaffer mentioned, that there’s no instability with this service. I’d suggest checking your cluster settings and, if possible, trying the test on a different compute.

WiliamRosa_0-1758473262346.png

 

Wiliam Rosa
Data Engineer | Machine Learning Engineer
LinkedIn: linkedin.com/in/wiliamrosa