Good morning team — I have a brand new install of Meltano on my Mac M1 Mini. When I attempt to run

meltano init bcm

all of the folders are created, but the SQLLite database commands all fail. For example: The first is

error    ] (sqlite3.OperationalError) near "job_id": syntax error

[SQL: ALTER TABLE job RENAME job_id TO job_name]

which is followed by a bunch more sqlAlchemy errors. Google hasn’t been helpful, so I came here. Any help would be much appreciated.

I think you need a newer Python version which ships with newer sqlite. Or the binary. https://github.com/meltano/meltano/issues/6405

Thanks for the suggestion @alexander_butler — That appears to have changed the error (Which is suspect is a good thing).

ImportError: dlopen(/Users/aaroneden/PycharmProjects/breachConversionMeltano/venv/lib/python3.10/site-packages/psutil/_psutil_osx.cpython-310-darwin.so, 0x0002): tried: 
'/Users/aaroneden/PycharmProjects/breachConversionMeltano/venv/lib/python3.10/site-packages/psutil/_psutil_osx.cpython-310-darwin.so' (code signature in <1A87AA89-72B9-3546-88CE-BAB3F6C15D4A> 
'/Users/aaroneden/PycharmProjects/breachConversionMeltano/venv/lib/python3.10/site-packages/psutil/_psutil_osx.cpython-310-darwin.so' not valid for use in process: Trying to load an unsigned library)

This appears to be a mac security error of some type.

Nice so it’s working? That xcrun is useful to know.