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

  Copy codeExpand code block

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

  Show lessSee more

  Scroll to top

• For Service Principal Auth

  Copy codeExpand code block

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

  Show lessSee more

  Scroll to top

Where:

• snowflake-accountname from Snowflake Connector for Microsoft Power Platform: [Optional] Validate Entra authorization setup.
• snowflake-role from Snowflake Connector for Microsoft Power Platform: Create a security integration.
• token-value from the output from cURL in step Snowflake Connector for Microsoft Power Platform: [Optional] Validate Entra authorization setup.