Can DBT Cloud be setup to use MFA when connecting to Snowflake?

Viewed 40

I have a Snowflake account that uses MFA. Logging in to Snowflake promtps for the MFA and I receive a push notification on my phone. Approving that logs me in. When setting up DBT Cloud it asks for details of the Snowflake account and then tries to test this. The cursor changes to the red circle / line and stays like that for a while before going back to normal and allowing the test to be run again. The Continue option remains greyed out. I expect the connection is timing out because Snowflake is waiting on the MFA to be approved, but as there is no notification in Duo there is nothing to approve. DBT docs have details of how to setup MFA for CLI but I can't see anything for DBT Cloud. Is MFA supported in DBT Cloud connections to Snowflake or should I just have a special Snowflake user that doesn't require MFA?

0 Answers
Related