Hi there, thanks for the reply.
I tried as you suggested, I installed unixODBC and unixODBC_dev in dremio and superset, running on separate VM but got the error as below:
ERROR: {“error”: “Connection failed!\n\nThe error message returned was:\n(pyodbc.Error) (‘01000’, “[01000] [unixODBC][Driver Manager]Can’t open lib ‘/opt/dremio-odbc/lib64/libdrillodbc_sb64.so’ : file not found (0) (SQLDriverConnect)”)\n(Background on this error at: http://sqlalche.me/e/dbapi)”, “stacktrace”: “Traceback (most recent call last):\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 2276, in _wrap_pool_connect\n return fn()\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 303, in unique_connection\n return _ConnectionFairy._checkout(self)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 760, in _checkout\n fairy = _ConnectionRecord.checkout(pool)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 492, in checkout\n rec = pool._do_get()\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/impl.py”, line 238, in _do_get\n return self._create_connection()\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 308, in _create_connection\n return _ConnectionRecord(self)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 437, in init\n self.__connect(first_connect_check=True)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 639, in __connect\n connection = pool._invoke_creator(self)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py”, line 114, in connect\n return dialect.connect(*cargs, **cparams)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy_dremio/base.py”, line 200, in connect\n return self.dbapi.connect(*cargs, **cparams)\npyodbc.Error: (‘01000’, “[01000] [unixODBC][Driver Manager]Can’t open lib ‘/opt/dremio-odbc/lib64/libdrillodbc_sb64.so’ : file not found (0) (SQLDriverConnect)”)\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n File “/home/jecrc/venv/lib/python3.6/site-packages/superset/views/core.py”, line 1705, in testconn\n with closing(engine.connect()) as conn:\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 2209, in connect\n return self._connection_cls(self, **kwargs)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 103, in init\n else engine.raw_connection()\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 2307, in raw_connection\n self.pool.unique_connection, _connection\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 2280, in _wrap_pool_connect\n e, dialect, self\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1547, in _handle_dbapi_exception_noconnection\n util.raise_from_cause(sqlalchemy_exception, exc_info)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py”, line 398, in raise_from_cause\n reraise(type(exception), exception, tb=exc_tb, cause=cause)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py”, line 152, in reraise\n raise value.with_traceback(tb)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 2276, in _wrap_pool_connect\n return fn()\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 303, in unique_connection\n return _ConnectionFairy._checkout(self)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 760, in _checkout\n fairy = _ConnectionRecord.checkout(pool)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 492, in checkout\n rec = pool._do_get()\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/impl.py”, line 238, in _do_get\n return self._create_connection()\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 308, in _create_connection\n return _ConnectionRecord(self)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 437, in init\n self.__connect(first_connect_check=True)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/pool/base.py”, line 639, in __connect\n connection = pool._invoke_creator(self)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py”, line 114, in connect\n return dialect.connect(*cargs, **cparams)\n File “/home/jecrc/venv/lib/python3.6/site-packages/sqlalchemy_dremio/base.py”, line 200, in connect\n return self.dbapi.connect(*cargs, **cparams)\nsqlalchemy.exc.DBAPIError: (pyodbc.Error) (‘01000’, “[01000] [unixODBC][Driver Manager]Can’t open lib ‘/opt/dremio-odbc/lib64/libdrillodbc_sb64.so’ : file not found (0) (SQLDriverConnect)”)\n(Background on this error at: http://sqlalche.me/e/dbapi)\n”}