I set MELTANO_DATABASE_URI pointing to CockroachDB, which is 100% compatible with PostgreSQL(supported DB in MELTANO_DATABASE_URI). When I run meltano, it fails:

Could not determine version from string 'CockroachDB CCL v22.1.12 (x86_64-pc-linux-gnu, built 2022/12/12 19:53:40, go1.17.11)'

Would it be feasible to change the process of determination of DB version in this case?

There is a sqlalchemy adapter for cockroachdb, I think Meltano would have to add support for that DB https://github.com/cockroachdb/sqlalchemy-cockroachdb https://github.com/cockroachdb/sqlalchemy-cockroachdb/issues/166 Seems like cockroachdb support might have to be added to make this work 🤷 not sure about any tricks that might be able to happen without much work

Thanks! I am trying Cockroach because they provide a nice free tier(forever, proper sizing) in their cloud. Meanwhile, I found a similar PostgreSQL free tier in bit.io, so I am no longer blocked. Anyway, from SQL syntax perspective, Cockroach is 100% compatible with PostgreSQL. We support it with PostgreSQL JDBC driver in our platform using the same Apache Calcite dialect.