Hello all,
I try to use Alteryx and MonetDB, a very cool column store database in Open Source.
When I use the Visual Query Builder, I get this :
![simonaubert_bd_2-1657224776143.png simonaubert_bd_2-1657224776143.png](https://community.alteryx.com/t5/image/serverpage/image-id/244545i5A4B1A88FE53A4FB/image-dimensions/620x614?v=v2)
The fields names are totally absent.
The reason is Alteryx does not use the standard ODBC SQLColums() function at all but send some query (here "select * from demo.exemplecomparetable.fruit1 a where 0=1" ) to get a sample of data. In the same time, Monetdb sends the error "SELECT: only a schema and table name expected" (not shown to user, totally silent)
I think this should be implemented like that :
1/use of SQLColums() function which is a standard for ODBC and should work most of the time
2/if SQLColums() does not work, send the current queries.
It's widely discussed here with the MonetDB team.
https://github.com/MonetDB/MonetDB/issues/7313
Best regards,
Simon