Dear colleagues, have anybody of you faced an issue when trying to init dbt in the FastAPI project?
Here is a briefe explanation of my problem:
I made an installation of dbt:
pip install dbt core, python -m pip install dbt-clickhouse,
so, currently, in my project, I have the following pockets:
dbt==1.0.0.35.1
dbt-clickhouse==1.7.1
dbt-core==1.7.4
dbt-extractor==0.5.1
dbt-semantic-interfaces==0.4.2
When I tried to init project by commands dbt init / dbt init my_dbt_project,
I receive the next message: “Error: unknown command “init” for “dbt””
By using the command dbt --version, I have this info:
dbt Cloud CLI - 0.35.1 (9fa6dfb20487fe164db8e0354f643d8cbd9c98fc 2023-12-08T18:33:01Z)
The case is - I use the command ‘pip install dbt’. As far as I use this command in an environment where only dbt is installed there is no problem. dbt --version command shows me that I have a core version. As far as I tried to install dbt in my FastAPI project, where I have some dependencies, I faced this problem dbt project started to be only dbt cloud CLI and I couldn’t init dbt, as the system sees dbt as CLI version.
Do you know how can I solve this problem?
Let me know if you need additional information.
Regards, Novikov.
The issue is the dbt dependency which is installing something called the dbt Cloud CLI which you almost certainly don’t want. A clean install without that dependency will probably fix the issue.
Note: @Josh Devlin (he) originally posted this reply in Slack. It might not have transferred perfectly.
Thanks for the quick answer)
Any thoughts on what exactly it can be?
here is my list of pockets:
agate==1.7.1
aioclickhouse==0.0.7
aiohttp==1.3.5
alembic==1.12.1
annotated-types==0.6.0
anyio==3.7.1
apache-airflow==2.7.3
apache-airflow-providers-common-sql==1.8.1
apache-airflow-providers-ftp==3.6.1
apache-airflow-providers-http==4.7.0
apache-airflow-providers-imap==3.4.0
apache-airflow-providers-sqlite==3.5.0
apispec==6.3.0
argcomplete==3.1.6
asgiref==3.7.2
asn1crypto==1.5.1
async-timeout==4.0.3
attrs==23.1.0
Babel==2.13.1
backoff==2.2.1
blinker==1.7.0
cachelib==0.9.0
cattrs==23.2.2
certifi==2023.11.17
cffi==1.16.0
chardet==5.2.0
charset-normalizer==3.3.2
click==8.1.7
clickclick==20.10.2
clickhouse-driver==0.2.6
colorama==0.4.6
colorlog==4.8.0
ConfigUpdater==3.2
connexion==2.14.2
cron-descriptor==1.4.0
croniter==2.0.1
cryptography==41.0.7
dbt==1.0.0.35.1
dbt-core==1.7.4
dbt-extractor==0.5.1
dbt-semantic-interfaces==0.4.2
Deprecated==1.2.14
dill==0.3.7
dnspython==2.4.2
docutils==0.20.1
ecdsa==0.18.0
email-validator==1.3.1
exceptiongroup==1.2.0
fastapi==0.104.1
filelock==3.13.1
Flask==2.2.5
Flask-AppBuilder==4.3.6
Flask-Babel==2.0.0
Flask-Caching==2.1.0
Flask-JWT-Extended==4.5.3
Flask-Limiter==3.5.0
Flask-Login==0.6.3
Flask-Session==0.5.0
Flask-SQLAlchemy==2.5.1
Flask-WTF==1.2.1
google-re2==1.1
googleapis-common-protos==1.61.0
graphviz==0.20.1
greenlet==3.0.1
grpcio==1.59.3
gunicorn==21.2.0
h11==0.14.0
httpcore==1.0.2
httpx==0.25.2
idna==3.6
importlib-metadata==6.8.0
importlib-resources==6.1.1
inflection==0.5.1
iniconfig==2.0.0
isodate==0.6.1
itsdangerous==2.1.2
jaraco.classes==3.3.0
Jinja2==3.1.2
jose==1.0.0
jsonschema==4.20.0
jsonschema-specifications==2023.11.1
keyring==24.3.0
lazy-object-proxy==1.9.0
leather==0.3.4
limits==3.7.0
linkify-it-py==2.0.2
lockfile==0.12.2
Logbook==1.5.3
lz4==4.3.2
Mako==1.3.0
Markdown==3.5.1
markdown-it-py==3.0.0
MarkupSafe==2.1.3
marshmallow==3.20.1
marshmallow-oneofschema==3.0.1
marshmallow-sqlalchemy==0.26.1
mashumaro==3.11
mdit-py-plugins==0.4.0
mdurl==0.1.2
minimal-snowplow-tracker==0.0.2
more-itertools==10.1.0
msgpack==1.0.7
multidict==6.0.4
networkx==3.2.1
opentelemetry-api==1.21.0
opentelemetry-exporter-otlp==1.21.0
opentelemetry-exporter-otlp-proto-common==1.21.0
opentelemetry-exporter-otlp-proto-grpc==1.21.0
opentelemetry-exporter-otlp-proto-http==1.21.0
opentelemetry-proto==1.21.0
opentelemetry-sdk==1.21.0
opentelemetry-semantic-conventions==0.42b0
ordered-set==4.1.0
packaging==23.2
parsedatetime==2.6
pathspec==0.11.2
pendulum==2.1.2
platformdirs==3.11.0
pluggy==1.3.0
prison==0.2.1
protobuf==4.25.1
psutil==5.9.6
pyasn1==0.5.1
pycparser==2.21
pydantic==1.10.13
pydantic_core==2.14.5
Pygments==2.17.2
PyJWT==2.8.0
pyOpenSSL==23.3.0
pytest==7.4.3
pytest-asyncio==0.23.2
pytest-mock==3.12.0
python-daemon==3.0.1
python-dateutil==2.8.2
python-dotenv==1.0.0
python-jose==3.3.0
python-nvd3==0.15.0
python-slugify==8.0.1
pytimeparse==1.1.8
pytz==2023.3.post1
pytzdata==2020.1
pywin32-ctypes==0.2.2
PyYAML==6.0.1
referencing==0.31.1
requests==2.31.0
requests-toolbelt==1.0.0
rfc3339-validator==0.1.4
rich==13.7.0
rich-argparse==1.4.0
rpds-py==0.13.2
rsa==4.9
setproctitle==1.3.3
six==1.16.0
sniffio==1.3.0
snowflake-connector-python==3.6.0
sortedcontainers==2.4.0
SQLAlchemy==1.4.50
SQLAlchemy-JSONField==1.0.2
SQLAlchemy-Utils==0.41.1
sqlparse==0.4.4
starlette==0.27.0
tabulate==0.9.0
tenacity==8.2.3
termcolor==2.3.0
text-unidecode==1.3
tomli==2.0.1
tomlkit==0.12.3
typing_extensions==4.8.0
tzdata==2023.3
tzlocal==5.2
uc-micro-py==1.0.2
unicodecsv==0.14.1
urllib3==1.26.18
uvicorn==0.24.0.post1
Werkzeug==2.2.3
wrapt==1.16.0
WTForms==3.0.1
yarl==0.9.8
zipp==3.17.0
zstandard==0.22.0