ERRO[0000]log.go:120 gosnowflake.(*defaultLogger).Errorf failed to open.

[andres-lowrie]

Hello

Came across this when installing via go and using the all tag. It's throwing a warning for the snowflake driver

Reproduce

• Build via go

  GO111MODULE=on go get -tags all github.com/xo/usql

• List the drivers

  usql -c '\drivers'

• Produces outupt

  2021/11/05 09:13:41 [DEBUG] gocosmos - Local IP: 192.168.1.68 / MAC: 00:00:38:f9:d3:99:1a:09
  ERRO[0000]log.go:120 gosnowflake.(*defaultLogger).Errorf failed to open. Ignored. open 
  /Users/andreslowrie/Library/Caches/Snowflake/ocsp_response_cache.json: no such file or directory
  Available Drivers:
    adodb [ad, ado]
    athena [s3, aws]
    avatica [av, phoenix]
    bigquery [bq]
    clickhouse [ch]
    cockroachdb (postgres) [cr, cdb, crdb, cockroach]
    cosmos [cm]
    cql [ca, scy, scylla, datastax, cassandra]
    csvq [cs, csv, tsv, json]
    exasol [ex, exa]
    firebirdsql [fb, firebird]
    genji [gj]
    godror [gr]
    h2
    hdb [sa, sap, hana, saphana]
    hive [hi]
    ignite [ig, gridgain]
    impala [im]
    maxcompute [mc]
    memsql (mysql) [me]
    moderncsqlite [mq, modernsqlite]
    mymysql [zm, mymy]
    mysql [my, maria, aurora, mariadb, percona]
    n1ql [n1, couchbase]
    nzgo [nz, netezza]
    odbc [od]
    oleodbc (adodb) [oo, ole]
    oracle [or, ora, oci, oci8, odpi, odpi-c]
    pgx [px]
    postgres [pg, pgsql, postgresql]
    presto [pr, prs, prestos, prestodb, prestodbs]
    ql [cznic, cznicql]
    redshift (postgres) [rs]
    snowflake [sf]
    spanner [sp]
    sqlite3 [sq, file, sqlite]
    sqlserver [ms, mssql]
    tds [ax, ase, sapase]
    tidb (mysql) [ti]
    trino [tr, trs, trinos]
    vertica [ve]
    vitess (mysql) [vt]
    voltdb [vo, vdb, volt]

[andres-lowrie]

I checked the upstream snowflake repo and it appears to be a known issue and they're saying it will be patched in the next release:

https://github.com/snowflakedb/gosnowflake/issues/390

[kenshaw]

@andres-lowrie there are a few drivers (cosmos, hive, impala, snowflake) that are only in the all driver group (and not most) because of (in my opinion) poor practices, such as unstable APIs or taking over default logging mechanisms/outputting to stdout/stderr via a init() call. If snowflake ever fixes this, let me know, and I'd be glad to move it to the most group.

[andres-lowrie]

will do. Thanks again have a good one