If you try to specify a database that is not default in the connection setup, then have issue #9. For example:
Behind the scenes, this query gets executed:
select name as TABLE_SCHEM, 'default' as TABLE_CATALOG from system.databases where TABLE_CATALOG = 'TPCD'
FORMAT TabSeparatedWithNamesAndTypes
I am not sure what the query is intended to do, but you are setting TABLE_CATALOG to default and then asking for records where TABLE_CATALOG equals TPCD - so you are guaranteed to get no response.
Either the query needs to be fixed; or maybe you can just remove Database from the popup window and have it default to default? (Setting the Database to default is the only way to get this connector to work.)
yurifal
commented
2 years ago
If you try to specify a database that is not
defaultin the connection setup, then have issue #9. For example:Behind the scenes, this query gets executed:
I am not sure what the query is intended to do, but you are setting
TABLE_CATALOGtodefaultand then asking for records whereTABLE_CATALOGequalsTPCD- so you are guaranteed to get no response.Either the query needs to be fixed; or maybe you can just remove Database from the popup window and have it default to
default? (Setting the Database todefaultis the only way to get this connector to work.)