szymon_dybczak
Esteemed Contributor III

Hi @pritam_epam ,

Try something similar to the following code and see if to works for you.

 

databricks_url = f'''jdbc:databricks://adb-774941343460743.3.azuredatabricks.net:443/default;
transportMode=http;
ssl=1;
httpPath=sql/protocolv1/o/your_org_id/your_cluster_id;
AuthMech=3;
UID=token;
PWD=your_accesss_token;
UseNativeQuery=0;
'''

df = spark.read.format("jdbc").option("url", databricks_url) \
.option("query", 'SELECT * FROM main.default.department') \
.load()

display(df)

 

In my case it worked without any issue:

szymon_dybczak_0-1726056322174.png