Could somebody provide an example of how a Snowfla...
# troubleshooting
c
Could somebody provide an example of how a Snowflake account number should be formatted in a database connection? Would this format work?
<account_number>.us-west-2.aws
?
b
It should do yes
ie you leave off .snowflakecomputing.com
c
Thanks @bright-smartphone-11251, it looks like the account number is properly formatted but Im hitting this error when I try to test the connection
Unable to connect: Network error. Could not reach Snowflake.
Its an issue on my end, but any chance youve seen this before and can provide some guidance?
b
Are you able to access your snowflake database from any other app or SQL IDE?
(from your machine)
c
Yep Im able to use the database via the snowflake-connector python library
Im using a local instance of evidence and see this in the logs. Could this be related somehow?
Copy code
local:   <http://localhost:3000>
  network: not exposed
  network: not exposed
  network: not exposed
  network: not exposed
b
No I think that shouldn't be an issue. That's saying that the evidence server is not exposed to the outside network (ie other people on your network cannot access your evidence pages)
c
Okay gotcha, I'll bug some of my coworkers when they come in to see if I flubbed my creds
b
is your python script running on a local notebook, (rather than eg via a hosted notebook on google colab etc) My thought here is that perhaps your organisation has some IP filtering set up for access to snowflake?
okay I think I have some Snowflake documentation that might help: https://docs.snowflake.com/en/user-guide/admin-account-identifier
so i would try also: •
<account_number>
<account_number>.us-west-2
(if you haven't already)
c
oh!
<account_number>
worked
b
excellent - okay this is not at all obvious, so I'm going to open an issue for this
c
Thanks Archie!!
b