I encountered an error indicating that "SQLAlchemy support is not installed" when trying to execute the command: pyiceberg --catalog sandbox list.
Cause:
This issue occurs because SQLAlchemy, which is essential for PyIceberg to interact with SQL databases (such as SQLite or PostgreSQL), is not included by default in the PyIceberg installation.
Solution:
To resolve this, I needed to install the necessary dependencies by running the following command based on the catalog type:
For SQLite:
pip install 'pyiceberg[sql-sqlite]'
This installs the required SQLAlchemy package, enabling PyIceberg to work with SQL-based catalogs.
Error: "SQLAlchemy support is not installed"
I encountered an error indicating that "SQLAlchemy support is not installed" when trying to execute the command: pyiceberg --catalog sandbox list.
Cause:
This issue occurs because SQLAlchemy, which is essential for PyIceberg to interact with SQL databases (such as SQLite or PostgreSQL), is not included by default in the PyIceberg installation.
Solution:
To resolve this, I needed to install the necessary dependencies by running the following command based on the catalog type:
For SQLite:
pip install 'pyiceberg[sql-sqlite]'
This installs the required SQLAlchemy package, enabling PyIceberg to work with SQL-based catalogs.