Cloud config settings

[crosbb]

Trying to disable the collation.

Collation in SQL server sources

Since release 1.3.0 the collation in SQL server sources is binary. It is slow because the generated SQL select contains COLLATE for string comparison, all values in column are converted and then indexes cannot be utilized. Is it possible to configure in Dremio the SQL database default collation and remove the COLLATE keyword from push down select? Thanks

Honestly not sure that will fix my issue, I am trying to connect to a cockroachdb database. But when I investigated the issue, and if I removed the Collate “C” the generated query did work.

Thanks!