It seems that when I am connecting to Databricks Warehouse, it is using the default catalog which is hive_metastore. Is there a way to define unity catalog to be the default? I know I can run the q...

Databricks documentation shows how get the cluster's hostname, port, HTTP path, and JDBC URL parameters from the JDBC/ODBC tab in the UI. See image: (source: databricks.com) Is there a way to get ...

I have two dataframes(from a delta lake table) that do a left join via an id column. sd1, sd2 %sql select a.columnA, b.columnB, from sd1 a left outer join sd2 b on a.id = b.id The problem is ...

I am trying to drop multiple tables in databrick scala using the following command select 'DROP TABLE ' + tableName from ABC where tableName LIKE 'in%' Error results saying Error in SQL statement:...

The more I read about the Lake House architectural pattern and following the demos from Databricks I hardly see any discussion around Dimensional Modelling like in a traditional data warehouse (Kim...

As the Title says, is it able to query object definition of the view in Databricks using SQL, especially for Azure Databricks? like when using SQL Server, I'm able to query the view definition usin...

DELTA does not have CREATE TABLE LIKE. It does have CTAS. I want to copy the definition of a table only, but also specify the LOCATION. E.g. this does not work: CREATE TABLE IF NOT EXISTS NEW_CUSTO...