What are the correct username and account name to connect to Snowflake in Azure?

Question

What are the correct username and account name to connect to Snowflake in Azure?

I am trying to create a connection to my Snowflake in Azure, but I am receiving the following error:

ERROR [HY000] [Microsoft][Snowflake] (4)

REST request for URL https://wh59974.snowflakecomputing.com:443/session/v1/login-request?requestId=08388d8b-30d5-4661-8f4d-1de3a54077e0&request_guid=eb798f50-866b-4d2a-ba85-c365fec3cf69&databaseName=Snowflake&warehouse=ACCOUNT_USAGE failed: HTTP error (http error) - code=403.

What is the correct account name and username I should use to connect to Snowflake in Azure?

Answer 1

Hello L.A W and ZLG Alan,

Welcome to the Microsoft Q&A platform.

Please follow the below Microsoft document for these details.
Account name: The full account name of your Snowflake account (including additional segments that identify the region and cloud platform), e.g. xy12345.east-us-2.azure.

User name: The login name of the user for the connection.

https://learn.microsoft.com/en-us/azure/data-factory/connector-snowflake?tabs=data-factory#basic-authentication

Regarding the error message:
Per the error message, login URL failed with a HTTP error code 403, which means that the request was forbidden. This could be due to incorrect account name or username.

I hope this helps. Please let me know if you have any further questions.