dbt-sugar icon indicating copy to clipboard operation
dbt-sugar copied to clipboard

dbt-suggar installation failed

Open lucianmoldovanu opened this issue 2 years ago • 0 comments

Describe the bug After running pip install dbt-sugar, despite installation is successful I still get an error when running dbt-sugar --version.

Traceback (most recent call last):
  File "/home/lucian/lucian/.venv/bin/dbt-sugar", line 5, in <module>
    from dbt_sugar.core.main import main
  File "/home/lucian/lucian/.venv/lib/python3.8/site-packages/dbt_sugar/core/main.py", line 15, in <module>
    from dbt_sugar.core.task.audit import AuditTask
  File "/home/lucian/lucian/.venv/lib/python3.8/site-packages/dbt_sugar/core/task/audit.py", line 14, in <module>
    from dbt_sugar.core.task.base import COLUMN_NOT_DOCUMENTED, BaseTask
  File "/home/lucian/lucian/.venv/lib/python3.8/site-packages/dbt_sugar/core/task/base.py", line 13, in <module>
    from dbt_sugar.core.connectors.snowflake_connector import SnowflakeConnector
  File "/home/lucian/lucian/.venv/lib/python3.8/site-packages/dbt_sugar/core/connectors/snowflake_connector.py", line 9, in <module>
    from snowflake.sqlalchemy import URL
  File "/home/lucian/lucian/.venv/lib/python3.8/site-packages/snowflake/sqlalchemy/__init__.py", line 19, in <module>
    from .util import _url as URL
  File "/home/lucian/lucian/.venv/lib/python3.8/site-packages/snowflake/sqlalchemy/util.py", line 13, in <module>
    from sqlalchemy.engine.url import _rfc_1738_quote
ImportError: cannot import name '_rfc_1738_quote' from 'sqlalchemy.engine.url' (/home/lucian/lucian/.venv/lib/python3.8/site-packages/sqlalchemy/engine/url.py)

It seems this might be a knows issue which was addressed (in snowflake-sqlalchemy dependency):

  • https://stackoverflow.com/questions/74103366/importerror-cannot-import-name-rfc-1738-quote-from-sqlalchemy-engine-url
  • https://github.com/snowflakedb/snowflake-sqlalchemy/blob/main/DESCRIPTION.md

Windows 11, WSL2.0, Ubuntu 18

lucianmoldovanu avatar Nov 16 '22 15:11 lucianmoldovanu