Connecting elastic search ODBC files in Alteryx - esODBC parsing_exception line mismatched

[APIUserOpsGiri]

I'm able to establish a connection but when I test a simple select * query , I get this error as below 

I tried the most common solution to switch oleodbc and changing the byte count.. in my case nothing seems to be working.

[PanPP]

Hi @APIUserOpsGiri 

1) Are you using the generic ODBC connection method to connect to your data?

2) Are you able to select the tables directly from the Visual Query Builder, and then test the query in the SQL Editor tab?

[APIUserOpsGiri]

1) yes, I'm using generic ODBC connection

2) no I can't.. I can see the table names on "Tables" but only the database name on "Visual Query Builder".

When I run any basic query on sql editor..is when I receive the error above

[APIUserOpsGiri · Accepted solution]

The solution was simple, as I did not have access to some tables. Otherwise it works great.

[PanPP]

@APIUserOpsGiri 

Glad you were able to resolve the issue.