I am trying my first pipeline with ampy-jupyterlab. I connected a parquet file reader with a postgres database. The file is read, but the postgres output produces:
Error
Class directly inherits TypingOnly but has additional attributes {'__firstlineno__', '__static_attributes__'}.
Show Traceback
---------------------------------------------------------------------------
AssertionError Traceback (most recent call last)
Cell In[7], line 3
1 get_ipython().system('pip install --quiet psycopg2-binary --disable-pip-version-check')
2 import pandas as pd
----> 3 import sqlalchemy
4 import psycopg2
5 # No environment variable components found.
6 # No connection components found.
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/__init__.py:13
10 from typing import Any
12 from . import util as _util
---> 13 from .engine import AdaptedConnection as AdaptedConnection
14 from .engine import BaseRow as BaseRow
15 from .engine import BindTyping as BindTyping
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/engine/__init__.py:18
1 # engine/__init__.py
2 # Copyright (C) 2005-2023 the SQLAlchemy authors and contributors
3 # <see AUTHORS file>
4 #
5 # This module is part of SQLAlchemy and is released under
6 # the MIT License: https://www.opensource.org/licenses/mit-license.php
8 """SQL connections, SQL execution and high-level DB-API interface.
9
10 The engine package defines the basic components used to interface
(...)
15
16 """
---> 18 from . import events as events
19 from . import util as util
20 from .base import Connection as Connection
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/engine/events.py:19
16 from typing import Type
17 from typing import Union
---> 19 from .base import Connection
20 from .base import Engine
21 from .interfaces import ConnectionEventsTarget
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/engine/base.py:30
27 from typing import TypeVar
28 from typing import Union
---> 30 from .interfaces import BindTyping
31 from .interfaces import ConnectionEventsTarget
32 from .interfaces import DBAPICursor
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/engine/interfaces.py:38
36 from ..pool import Pool
37 from ..pool import PoolProxiedConnection
---> 38 from ..sql.compiler import Compiled as Compiled
39 from ..sql.compiler import Compiled # noqa
40 from ..sql.compiler import TypeCompiler as TypeCompiler
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/sql/__init__.py:11
8 from typing import TYPE_CHECKING
10 from .base import Executable as Executable
---> 11 from .compiler import COLLECT_CARTESIAN_PRODUCTS as COLLECT_CARTESIAN_PRODUCTS
12 from .compiler import FROM_LINTING as FROM_LINTING
13 from .compiler import NO_LINTING as NO_LINTING
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/sql/compiler.py:60
58 from . import base
59 from . import coercions
---> 60 from . import crud
61 from . import elements
62 from . import functions
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/sql/crud.py:34
31 from typing import Union
33 from . import coercions
---> 34 from . import dml
35 from . import elements
36 from . import roles
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/sql/dml.py:34
32 from . import coercions
33 from . import roles
---> 34 from . import util as sql_util
35 from ._typing import _no_kw
36 from ._typing import _TP
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/sql/util.py:46
44 from .base import _from_objects
45 from .cache_key import HasCacheKey as HasCacheKey # noqa: F401
---> 46 from .ddl import sort_tables as sort_tables # noqa: F401
47 from .elements import _find_columns as _find_columns
48 from .elements import _label_reference
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/sql/ddl.py:30
28 from .base import Executable
29 from .base import SchemaVisitor
---> 30 from .elements import ClauseElement
31 from .. import exc
32 from .. import util
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/sql/elements.py:755
749 _propagate_attrs = util.EMPTY_DICT
752 # SQLCoreOperations should be suiting the ExpressionElementRole
753 # and ColumnsClauseRole. however the MRO issues become too elaborate
754 # at the moment.
--> 755 class SQLCoreOperations(Generic[_T], ColumnOperators, TypingOnly):
756 __slots__ = ()
758 # annotations for comparison methods
759 # these are from operators->Operators / ColumnOperators,
760 # redefined with the specific types returned by ColumnElement hierarchies
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/typing.py:1257, in _generic_init_subclass(cls, *args, **kwargs)
1256 def _generic_init_subclass(cls, *args, **kwargs):
-> 1257 super(Generic, cls).__init_subclass__(*args, **kwargs)
1258 tvars = []
1259 if '__orig_bases__' in cls.__dict__:
File /data/home/sdrwacker/miniforge3/envs/jupyter/lib/python3.13/site-packages/sqlalchemy/util/langhelpers.py:1983, in TypingOnly.__init_subclass__(cls)
1973 remaining = set(cls.__dict__).difference(
1974 {
1975 "__module__",
(...)
1980 }
1981 )
1982 if remaining:
-> 1983 raise AssertionError(
1984 f"Class {cls} directly inherits TypingOnly but has "
1985 f"additional attributes {remaining}."
1986 )
1987 super().__init_subclass__()
AssertionError: Class <class 'sqlalchemy.sql.elements.SQLCoreOperations'> directly inherits TypingOnly but has additional attributes {'__firstlineno__', '__static_attributes__'}.