+1
Completed

Is there a way to connect to a live database environment (Snowflake in my case) via Okta SSO?

jbejarano 1 month ago updated by hannah.gryska 1 month ago 1

Is there a way to connect to a live database environment (Snowflake in my case) via Okta SSO?  My company doesn't like to issue password strings and wants Okta to manage them.

Completed

Hi John, thank you for reaching out. 

Unfortunately, we do not support connecting to Snowflake via Okta - we only support Okta for SSO currently. It is on our roadmap and we hope to have that available next year. It does not affect the interaction with the tool though. There are two workarounds for organizations with such policies like he has:

  1. Surpass live db connection and just run the get DDL command in snowflake, copy the DDL from there and paste it into SqlDBM to reverse engineer
  2. Create a  generic "user" in Snowflake with limited rights to use for direct connection for the team

Hopefully this will help in the interim and we will keep you updated on changes to this functionality! Thank you.