Fork me on GitHub
#sql
<
2020-08-21
>
jsyrjala10:08:18

More Snoflake / next-jdbc funkiness:

jsyrjala10:08:26

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

jsyrjala10:08:21

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

jsyrjala10:08:15

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

seancorfield15:08:44

Definitely a Snowflake bug!

seancorfield15:08:19

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