sql

All things SQL and JDBC...
jsyrjala 2020-08-21T10:18:18.011800Z

More Snoflake / next-jdbc funkiness:

jsyrjala 2020-08-21T10:19:26.011900Z

(let [sql "select * from my_table"]
  (sql/query db [sql])))
returns some fields names prefixed with :MY_TABLE/ namespace, and some without

jsyrjala 2020-08-21T10:20:21.012100Z

Return values contain keys like :IMPORT_STATUS and :MY_TABLE/IMPORT_START

jsyrjala 2020-08-21T10:32:15.012300Z

seems to be issue with jdbc driver: ResultSetMetaData.getTableName(columnIndex) returns “” for some fields, and table name for some others

seancorfield 2020-08-21T15:27:44.012600Z

Definitely a Snowflake bug!

seancorfield 2020-08-21T15:29:19.012800Z

You can probably workaround around it by either using an unqualified builder, or using a modified builder with :qualifier-fn.