There are 2 instances I got this error -

1. Installing correct python package. Make sure you install "databricks.sql" module, not "databricks" module. Run below code in jupyter -

%pip install databricks.sql

2. The hostname, os.getenv("DATABRICKS_SERVER_HOSTNAME") returns, should NOT contain "https://".

Please upvote the answer if it solves your issue.