Databricks-Sql-Connector

[Upendra_Dwivedi]

Hi,

i am connecting with databricks sql_warehouse using vs_code and i am running following command:

import os

from databricks import sql

host = 'adb-xxxxxxxxxxx.xx.azuredatabricks.net'

http_path = '/sql/1.0/warehouses/xxxxxxxxxxxxxx'

access_token = 'dapibxxxxxxxxxxxxxxxxxxxxxxxxx'

connection = sql.connect(

  server_hostname=host,

  http_path=http_path,

  access_token=access_token)

cursor = connection.cursor()

When i am running this command i am getting 

from databricks.sql.auth.retry import CommandType, DatabricksRetryPolicy
File "C:\Users\Upendra.Dwivedi\OneDrive - xxxxxx\Desktop\Databricks Practice\Sql_Connection_Databricks\.venv\lib\site-packages\databricks\sql\auth\retry.py", line 19, in <module>
from packaging import version
ModuleNotFoundError: No module named 'packaging'

Not able to understand the reason behind this error.

[User16502773013]

Hello @Upendra_Dwivedi ,

This is potentially a missing package in your local Python setup, kindly can you check troubleshooting steps here and let me know 

In the alternative this didn't work please share the output of the following commands:

python -V

And

pip freeze > requirements.txt 

Regards