Databricks Community

maybe you can set a lock before call SOAP APIpython - Using a Lock with redis-py - Stack Overflow

%sql SELECT array_sort(array_agg(col) ,(left, right) -> CASE WHEN left < right THEN -1 WHEN left > right THEN 1 ELSE 0 END) arr_col FROM VALUES (3), (2), (1) AS tab(col); https://docs.databricks.com/en/sql/language-manual/functions/array_sort.h...

 In the alternative way, you can use dbutils.notebook.run to pass the parameters, and use dbutils.widgets.get in another notebook to get the parameter values,and determine the parameter values to decide whether to execute codes in the specified cellh...

setting dbt-databricks==1.7.3 solved this issue but now we randomly get the below error . it gets fixed after restrating the cluster sometimes. but is there any permanent solution for this ? from dbt.events import types_pb2 File "/databricks/python3/...

@Andyt If the workspace is accidentally deleted, there is not way to retrieve content from SQL editor.

@WhistlePodu You can review the jobs API for getting the other fields like jobs status etc

@Sangram Can you please confirm if that DBFS exists in the specified location?  

@pshuk If you are still facing the issue, can you please share the commands you are using ?May be you need to use the latest CLI version to use Volumes which is a new feature?

Hi @Fnazar  When dealing with streaming data, you might end up with many small files, which can be inefficient. Use Delta Lake's OPTIMIZE command to compact files into larger ones and ZORDER to colocate related information in the same set of files. T...

Can you directly use Databricks connect and validate if it works from CLI?Also, confirm the databrics-connect version please 

Thank you for the update. Please select the best response as a solution, so other community members will be able to get unblock if they have this issue