I tried using tap-mssql extractor for my test. I noticed noticed that I got the following error _Invalid object name 'INFORMATION_SCHEMA.tables'_ When I issue meltano select tap-mssql --list --all However, this error is because I've got Case Sensitive collation on my SQL Server. For normal collation this should work alright but for Case Sensitive Collation this will never work. Is there a work around here? Or where should I be focusing on if I want to fix this issue without changing my Server Collation of course 🙂.

@daniel_antwi what variant of tap-mssql do you have installed?

I just issued this command to add it from https://hub.meltano.com/extractors/tap-mssql/#filter_dbs-setting meltano add extractor tap-mssql

Hey @daniel_antwi! Do you know what’s the offending object name in the query? Is it _`INFORMATION_SCHEMA` or `tables`_ ? Either way, the solution is probably to send a PR to wintersrd to update these lines: https://github.com/wintersrd/pipelinewise-tap-mssql/blob/e61e8687a552c8a6c67946b1c90f44745da90cb9/tap_mssql/__init__.py#L193-L196

The offending object is tables. It should be TABLES as in INFORMATION_SCHEMA.TABLES.