Fork me on GitHub
#sql
<
2020-12-25
>
Santiago08:12:57

☝️ This works! Thanks @seancorfield

(def db
  {:dbtype "snowflake"
   :user "<YOUR USERNAME>"
   :password "<YOUR PASSWORD>"
   :host "https://<FULL ACCOUNT NAME>."
   :port "443"
   :db "<DEFAULT DB>"
   :roles "<YOUR ROLE>"
   :classname "net.snowflake.client.jdbc.SnowflakeDriver"})

seancorfield18:12:17

@slack.jcpsantiago That looks good. I'm a bit surprised that it accepts :host with the https:// prefix but mostly next.jdbc just builds a JDBC URL from parts of that hash map and hands it off to the driver -- so some drivers are pretty lenient about what they accept.