Error - Langchain to interact with a SQL database

abd — Thu, 01 Aug 2024 09:04:55 GMT

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")

Error:

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)

Re: Error - Langchain to interact with a SQL database

KumaranT — Tue, 13 Aug 2024 22:35:30 GMT

Hi @abd,

Can you check upgrading the SQL driver?

topic Re: Error - Langchain to interact with a SQL database in Machine Learning

Error - Langchain to interact with a SQL database

Re: Error - Langchain to interact with a SQL database