Why is ODBC.jl extremely slow using snowflake driver

Specific Domains Data
1

Hi all :slight_smile:

I’m using ODBC.jl with snowflake. I ran into a problem though while using the replace function in the query string.

For example:
1.)

SELECT
    replace(col_name, '.', ' ') as col_name
FROM
    db.tb

is very very slow. But
2.)

SELECT
    col_name
FROM
    db.tb

runs normal.

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?

Cheers Lars