DB Query Node Reading Partially From Data Warehouse

[Steve_Bunde]

Hi All,

I am trying to read tables from a data warehouse. The warehouse is SAP BI using Sybase. The node is able to see some columns within the tables but for a number of tables, I get the error “error fetching columns”. What may the problem be?

Thanks.

[Steve_Bunde]

Still stuck here. Any guidance to resolve this is welcome.

[takbb]

Hi @Steve_Bunde , what form do the table and column names take? Is it every table, or just specific tables that have the problem? Anything special about their names? Do they contain any characters other than alphanumeric and underscore?

I haven’t got much to go on (I don’t use SAP BI/Sybase), but I’m wondering if your problem may be similar to this:

Error fetching columns (in DB Table Selector)

Hi @bekop_veo , I asked about this issue internally and one of our developers said that there is a setting inside the Advanced setting tab in the big query connector node which might be the spaces with underscores which you need to disable. Big query connector node ->Advanced->Dialect Syntax->replace non-word characters in identifiers [image] Could you please try this and let us know? Thanks, Sanket

[Steve_Bunde]

Hi @takbb

Thanks for the response. I am using the DB Connector node in this case. I have noted that it has the parameters mentioned in the topic you shared that references the Google BigQuery Connector. I
a) In the DB Connector, I went to the Advanced tab.
b) There, in the “Dialect syntax” section, I found the point “Replace non-word characters in identifiers”, which has a tick in the default setting.

However, I’m still getting the same “error fetching columns” message.

I’ve tried checking the naming of the tables but there seems to be no difference in what is read successfully and the ones that fail.

What may I still be missing?

[mlauber71]

@Steve_Bunde

SAP BI using Sybase

We have not much to go on here. Do you use an official driver? Do you have all the access rights?

SELECT column_name FROM information_schema.columns WHERE table_name = 'YOUR_TABLE';

I notice that the table in question seems to have upper and lower cases and special characters in the table name.

[Steve_Bunde]

Thanks @mlauber71 for your response.

Just to clarify, I have full access rights and use the official driver from Sybase (that’s why some tables are visible). I did check your suggestion on characters and cases which gave a different point of consideration. I have however no pattern as to why some can be read while some return an error. Let me pursue the angle on naming as suggested by both yourself and @takbb