Is anyone able to configure a datasource to connect to snowflake? Specifically when using a private key to do so? When I try in my

application.groovy

it seems to be looking for a

username

when I want it to only read the properties in the props I provide. (@jdaugherty chatting with @gsandrew on this issue and he said you might have an idea)

DataSourceConnectionSourceFactory / DataSourceSettings indicates username can be set to null. What makes you think it's looking for a username?

I have connected Grails to Snowflake, but with username and password, if I remember correctly. The nice thing was the connection pool does not result in billing from Snowflake until you query. The hibernate snowflake dialect was also missing, so hopefully that is now solved.

We got it working with username/password, but it wasn’t working with a public/private key pair