Forrest logo
back to the snowsql tool

snowsql:tldr:f4600

snowsql: Connect to the default instance using a token for multi-factor authentication.
$ snowsql --mfa-passcode ${token}
try on your machine

The command snowsql --mfa-passcode ${token} is used to run the snowsql command-line client for Snowflake with multi-factor authentication (MFA) enabled, passing the MFA passcode as a parameter.

The command is composed of the following parts:

  1. snowsql: This is the actual command-line client for Snowflake, used to interact with the Snowflake data warehouse.
  2. --mfa-passcode: This flag indicates that MFA passcode needs to be passed as a parameter.
  3. ${token}: In this context, ${token} represents a variable that should be replaced with the actual MFA passcode value. The MFA passcode is typically generated by an authentication app, hardware token, or received via SMS.

By running this command and specifying the MFA passcode, you authenticate yourself to Snowflake with an additional layer of security required by multi-factor authentication.

This explanation was created by an AI. In most cases those are correct. But please always be careful and never run a command you are not sure if it is safe.
back to the snowsql tool