I’m using ODBC.jl with snowflake. I ran into a problem though while using the
replace function in the query string.
SELECT replace(col_name, '.', ' ') as col_name FROM db.tb
is very very slow. But
SELECT col_name FROM db.tb
I don’t understand why that is. I tried the first string within python (
pyodbc, same driver and db) and it was fast/normal.
Can anybody reproduce this or give me any advice what to test next?