I created an azure Snowflake trial account and an odbc dsn, it works. Then I had to create a Snowflake trial in AWS to use the Snowflake training. When creating a DSN it fails with this error; Incorrect username or password was specified. For Azure, I use ..snowflakecomputing.com, this works. For AWS I use .snowflakecomputing.com, I get the user error. I tried other combinations but hten I always get a host unresolved error. ..snowflakecomputing.com .sg..aws.snowflakecomputing.com Thanks for hints
As per https://docs.snowflake.com/en/user-guide/organizations-connect.html your Snowflake URL / servername is in this format
https://<account_locator>.<region>.<cloud>.snowflakecomputing.com
The cloud is not needed if using AWS, but is if using Azure or GCP. The region is not needed if us-east1 but otherwise must be specified.
Now, it doesn't matter where you are trying to connect to Snowflake from - it only matters where your Snowflake instance is.
So, if you made your Snowflake instances in AWS it is the exact same URL / server name whether you connect to it via the web console, a command-line tool, ODBC from an AWS application, JDBC from an Azure application, or anything else.
Thus, if you made the Snowflake account in AWS you will use something like
https://FV23210.ap-southeast2.snowflakecomputing.com
no matter where you call it from; if you made the Snowflake account in Azure you will use something like
https://FV23210.ap-southeast2.azure.snowflakecomputing.com
no matter where you call it from.