Snowflake Connector for Microsoft Power Platform: [Optional] Validate Snowflake access¶

Validate Snowflake access using either SnowCLI or SnowSQL.

Open a terminal and execute the following commands:

  • For Delegated Auth

    snowsql -a <organization-locator> -u 'user@sandbox.onmicrosoft.com' --rolename <snowflake-role> --authenticator oauth --token "<token-value>"
    Copy

  • For Service Principal Auth

    snowsql -a <organization-locator> -u 'sub-value' -r <snowflake-role> --authenticator oauth --token "<token-value>"
    Copy

Where:

Language: English