cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Does Databricks SQL support Azure SQL DB?

mehdi1
New Contributor III

Hi,

I could create spark tables based on SQL server (Azure SQL actually), and query the tables from a notebook.

On another hand, I can see the tables listed in the hive metastore in Databricks SQL. However when I try to query the tables there, it says only CSV, json, parquet, etc. (meaning file based) tables are supported.

Is there anyway to overcome that ? It looks pretty inconsistent to me that we can query the tables in Data Science and Engineering mode but not in SQL mode.

7 REPLIES 7

Prabakar
Esteemed Contributor III

@Mehdi Aziz Boumedine​ 

When you query Hive tables on Databricks SQL, you get an error "Reading Hive table <table-name> is not supported on Databricks SQL. Only csv, json, avro, delta, parquet, orc, text, unity_catalog data sources are supported". This is because Hive based tables are not supported on Databricks SQL

The solution is to add few records/overwrite records either in parquet/orc or any desired format. Adding rows in parquet for instance will change the relation from "HiveTableRelation" to Parquet relation, which makes the table queryable in Databricks SQL

Anonymous
Not applicable

Hey @Mehdi Aziz Boumedine​ 

Hope you are well. Just wanted to see if you were able to find an answer to your question and would you like to mark an answer as best? It would be really helpful for the other members too.

Cheers!

saltuk
Contributor

@Kaniz Fatma​ @Prabakar Ammeappin​ 

I do not know if you aware of what @bhumi shamra​  published above?

this comments are irrelevant ..

@Kaniz Fatma​ 

no problem at all, but user has done that in a multiple tickets.

please see:

https://community.databricks.com/s/question/0D58Y00008mqagOSAQ/how-do-i-install-a-non-pythonrmavenja...

No problem at all. 🙂

@Kaniz Fatma​ 

May I request, could you please guide me on my ticket? maybe you can help me out here , recently i have been working on it but i am stuck:

https://community.databricks.com/s/question/0D58Y00008qXvbNSAS/databricks-sql-cannot-communicate-wit...

Hi @saltuk bozok​,

Just a friendly follow-up. Do you still need help or you were able to find a solution? please let us know

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group