topic Re: Error with live connection SQL Datawarehouse in Data Engineering

Error with live connection SQL Datawarehouse

JohnMartensDB — Tue, 13 Sep 2022 10:15:30 GMT

Error type: System call error. Cannot make named pipe /tmp/EvtnUM74TA574813952 due to error: No space left on device..))

I can't find anything recent online related to Databricks or the SQL warehouses specifically. I don't seem to have enough monitoring options to figure out why this error is occuring. Anyone have an idea what is going on here?

Thanks in advance.

Re: Error with live connection SQL Datawarehouse

-werners- — Tue, 13 Sep 2022 12:01:42 GMT

can you elaborate a bit on how you connect to Databricks SQL, and what cluster you use (or even serverless) and what tool?

Re: Error with live connection SQL Datawarehouse

JohnMartensDB — Tue, 13 Sep 2022 12:49:17 GMT

Microstrategy connects to a small SQL Datawarehouse (SQL endpoint), which I guess is serverless by default. I don't believe the Databricks UI gives many options other than size and cost efficient or reliable setting. May be a temporary issue since it seems to have solved itself for now at least.

Re: Error with live connection SQL Datawarehouse

-werners- — Tue, 13 Sep 2022 13:11:13 GMT

Ok great to hear the issue solved itself 🙂

FYI: the small SQL dwh is not serverless. To be able to select serverless endpoints, you have to activate it first.

Re: Error with live connection SQL Datawarehouse

JohnMartensDB — Tue, 13 Sep 2022 15:11:47 GMT

Thx for the help and info!