☝️ This works! Thanks @seancorfield
(def db
{:dbtype "snowflake"
:user "<YOUR USERNAME>"
:password "<YOUR PASSWORD>"
:host "https://<FULL ACCOUNT NAME>.<http://snowflakecomputing.com|snowflakecomputing.com>"
:port "443"
:db "<DEFAULT DB>"
:roles "<YOUR ROLE>"
:classname "net.snowflake.client.jdbc.SnowflakeDriver"})
@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.