I am using databricks community edition to use langchain on SQL database in databricks.
I am following this link: Interact with SQL database - Databricks
But I am facing issue on this line:
db = SQLDatabase.from_databricks(catalog="samples", schema="nyctaxi")
OperationalError: (databricks.sql.exc.RequestError) Error during request to server: : user not found (Background on this error at: https://sqlalche.me/e/14/e3q8)
File /local_disk0/.ephemeral_nfs/envs/pythonEnv-72a0ed73-c1dd-456a-a142-9b9ed9839d19/lib/python3.11/site-packages/sqlalchemy/engine/base.py:3371, in Engine._wrap_pool_connect(self, fn, connection) 3370 try: -> 3371 return fn() 3372 except dialect.dbapi.Error as e:
File /local_disk0/.ephemeral_nfs/envs/pythonEnv-72a0ed73-c1dd-456a-a142-9b9ed9839d19/lib/python3.11/site-packages/databricks/sql/thrift_backend.py:314, in ThriftBackend._handle_request_error(self, error_info, attempt, elapsed) 309 network_request_error = RequestError( 310 user_friendly_error_message, full_error_info_context, error_info.error 311 ) 312 logger.info(network_request_error.message_with_context()) --> 314 raise network_request_error 316 logger.info( 317 "Retrying request after error in {} seconds: {}".format( 318 error_info.retry_delay, full_error_info_context 319 ) 320 ) 321 time.sleep(error_info.retry_delay)
