meltano add transformer dbt-duckdb: invalid value -2

[ReneTC]

Hi! I have a brand new meltano project, in a new virutal env.

If I run:

meltano add transformer dbt-duckdb

I get

Need help fixing this problem? Visit http://melta.no/ for troubleshooting steps, or to
join our friendly Slack community.

<flag 'DefinitionSource'> invalid value -2
    given 0b1 10
  allowed 0b1 11

[ReneTC]

Pip Freeze dump:

aiodocker==0.21.0
aiohttp==3.8.4
aiosignal==1.3.1
alembic==1.11.1
aniso8601==9.0.1
anyio==3.7.1
asgiref==3.7.2
async-timeout==4.0.2
atomicwrites==1.4.1
attrs==23.1.0
Authlib==1.2.1
Babel==2.12.1
backoff==2.2.1
bcrypt==3.2.2
blinker==1.6.2
cached-property==1.5.2
certifi==2023.5.7
cffi==1.15.1
charset-normalizer==3.1.0
check-jsonschema==0.22.0
click==8.1.4
click-default-group==1.2.2
croniter==1.4.1
cryptography==41.0.1
distlib==0.3.6
dnspython==2.3.0
email-validator==1.3.1
fasteners==0.18
filelock==3.12.2
Flask==2.1.3
Flask-BabelEx==0.9.4
Flask-Cors==3.0.10
Flask-Executor==0.10.0
Flask-Login==0.6.1
Flask-Mail==0.9.1
Flask-Principal==0.4.0
Flask-RESTful==0.3.10
Flask-SQLAlchemy==2.5.1
Flask-WTF==1.1.1
flatten-dict==0.4.2
frozenlist==1.3.3
greenlet==2.0.2
gunicorn==20.1.0
h11==0.14.0
httptools==0.6.0
idna==3.4
itsdangerous==2.1.2
Jinja2==3.1.2
jsonschema==4.18.0
jsonschema-specifications==2023.6.1
Mako==1.2.4
markdown-it-py==3.0.0
MarkupSafe==2.1.3
mdurl==0.1.2
meltano==2.19.1
meltano-flask-security==0.1.0
multidict==6.0.4
packaging==23.1
passlib==1.7.4
platformdirs==3.8.1
psutil==5.9.5
psycopg2-binary==2.9.6
pycparser==2.21
Pygments==2.15.1
pyhumps==3.8.0
python-dateutil==2.8.2
python-dotenv==0.21.1
python-gitlab==3.15.0
pytz==2023.3
PyYAML==6.0
referencing==0.29.1
requests==2.31.0
requests-toolbelt==1.0.0
rich==13.4.2
rpds-py==0.8.8
ruamel.yaml==0.17.21
six==1.16.0
smart-open==6.3.0
smtpapi==0.4.12
sniffio==1.3.0
snowplow-tracker==0.10.0
speaklater==1.3
SQLAlchemy==1.4.49
structlog==23.1.0
typing_extensions==4.7.1
tzlocal==5.0.1
urllib3==2.0.3
uvicorn==0.17.6
uvloop==0.17.0
virtualenv==20.23.1
watchgod==0.8.2
websockets==11.0.3
Werkzeug==2.1.2
WTForms==3.0.1
yarl==1.9.2

[jwills]

Hey @ReneTC! I think the issue is this: https://github.com/meltano/meltano/issues/7813 and isn't dbt-duckdb specific, but lmk if you disagree and/or if there is something I can do to assist. 🙇

[ReneTC]

Hey @jwills thanks a lot. You are right. Switching to python 3.10.12 works.

[ReneTC]

I can't really make sense if this issue, now it doesn't work anymore with python 3.10.12?

anyone that can reproduce?

[ReneTC]

Okay I am now quite sure this error has to do with my company. It is very strict with weird certifications and python versions and packages. If anyone have any idea if the issue is fixable I would love to know

[ReneTC]

Fixed by using anaconda instead of pyenv and pipx. I also had to use meltano: 2.10.0 and python 3.8.10