I've been tinkering on and off today with trying to direct meltano to use snowflake as the system database. It looks like this might be supported by this code, but when I try to run a "meltano elt", it errors out complaining that snowflake isn't a defined dialect in an alembic library. Do we know if snowflake is actually supported for the system database, or are sqlite/postgres our only options right now?

File "/home/azureuser/.local/lib/python3.8/site-packages/alembic/ddl/impl.py", line 121, in get_by_dialect

return _impls[dialect.name]

KeyError: 'snowflake'

Pretty sure you need an OLTP DB for your system db

That was my thought too, but a colleague (@john_rhodes) found the fun code above. And it does execute queries against snowflake, but bombs out somewhere in the alembic code while trying to configure the new system db

@scott_goering The problem seems to be: How to add the requirement config into Alembic's

env.py

... I can't quickly figure out how to enable the

snowflake

dialect in Meltano's use of Alembic.