Snowflake single connection/session

[aspexdaniel]

What

For Snowflake user/pwd login, MFA is required so it will generate a double confirm in auth app every time running a query, which is really slowing down the whole process.

Why (problem/use case)

Need to use a 'single session/connection' mode for Snowflake user/pwd login given the MFA is enforced for all pwd login accounts in Snowflake.

[mikeburgh]

I just released 1.28.16, the Snowflake driver has an option to cache those between connections in a session, which I just enabled for password based auth (was already enabled for SSO auth). Let me know if that sorts it out for you, or we can look into it more. You might still need to auth when you first open an editor connection as it uses a dedicated connection for session persistence.

[aspexdaniel]

I just released 1.28.16, the Snowflake driver has an option to cache those between connections in a session, which I just enabled for password based auth (was already enabled for SSO auth). Let me know if that sorts it out for you, or we can look into it more. You might still need to auth when you first open an editor connection as it uses a dedicated connection for session persistence.

I just tried 1.28.16, there're some issues fetching the role, database & warehouses.

Connection Error: Cannot read properties of null (reading 'write')

I have multiple roles, databases & warehouses.

[mikeburgh]

Does it work if role back to .15 ?

[aspexdaniel]

yes it works, just tried

[mikeburgh]

Okay let me change my snowflake over to login and sso and figure out why that broke it.. was jsut two properties on the driver

[mikeburgh]

Okay re worked how Snowflake driver works, give 1.29.0 a try and see how you go ?

[aspexdaniel]

Can confirm it works as expected now. Thanks!