ibis version:
'8.0.0.dev70'
con = ibis.connect(f"mssql://{user}:{password}@{server}:1433/{db}?driver=ODBC+Driver+17+for+SQL+Server&TrustServerCertificate=yes")
c:\Python_ENV\venv\lib\site-packages\ibis\backends\base\sql\alchemy\__init__.py:575: SAWarning: Omitting index key for (Shape), key covers omitted columns. self.inspector.reflect_table(table, table.columns)
ProgrammingError Traceback (most recent call last) File c:\Python_ENV\venv\lib\site-packages\sqlalchemy\engine\base.py:1905, in Connection._execute_context(self, dialect, constructor, statement, parameters, execution_options, *args, **kw) 1904 if not evt_handled: -> 1905 self.dialect.do_execute( 1906 cursor, statement, parameters, context 1907 ) 1909 if self._has_events or self.engine._has_events:
File c:\Python_ENV\venv\lib\site-packages\sqlalchemy\engine\default.py:736, in DefaultDialect.do_execute(self, cursor, statement, parameters, context) 735 def do_execute(self, cursor, statement, parameters, context=None): --> 736 cursor.execute(statement, parameters)
ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The request for procedure 'GLB_SEISMIC_3DSURVEYS_API' failed because 'GLB_SEISMIC_3DSURVEYS_API' is a table object. (2809) (SQLExecDirectW); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The metadata could not be determined because every code path results in an error; see previous errors for some of these. (11529)")
The above exception was the direct cause of the following exception:
ProgrammingError Traceback (most recent call last) Input In [19], in <cell line: 2>() 1 # x = con.table('PIPELINEDEVICE') ----> 2 x = con.table('GLB_SEISMIC_3DSURVEYS_API', schema='sde')
File c:\Python_ENV\venv\lib\site-packages\ibis\backends\base\sql\alchemy\__init__.py:688, in BaseAlchemyBackend.table(self, name, database, schema) 663 """Create a table expression from a table in the database. 664
...
ProgrammingError: (pyodbc.ProgrammingError) ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The request for procedure 'GLB_SEISMIC_3DSURVEYS_API' failed because 'GLB_SEISMIC_3DSURVEYS_API' is a table object. (2809) (SQLExecDirectW); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The metadata could not be determined because every code path results in an error; see previous errors for some of these. (11529)") [SQL: EXEC sp_describe_first_result_set @tsql = ?] [parameters: ('sde.[GLB_SEISMIC_3DSURVEYS_API]',)] (Background on this error at: https://sqlalche.me/e/14/f405)