SNOW-2265499: toml connection method unable to connect. User is empty error

[erickdcohen]

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of GO driver are you using?

v1.15.0

2. What operating system and processor architecture are you using?

MacOS Sequoia 15.6 | Apple M4 Pro (ARM)

3. What version of GO are you using?
   run go version in your console

go version go1.24.5 darwin/arm64

4.Server version:* E.g. 1.90.1
You may get the server version by running a query:

SELECT CURRENT_VERSION();

9.23.1

5. What did you do? If possible, provide a recipe for reproducing the error.
   A complete runnable program is good.

I am attempting to follow the documentation for connecting via .toml, which directs me to this example, which is what I am trying to run. I set up my connections.toml and config.toml files but keep running into the same error message:

failed to connect. 260001: user is empty,
exit status 1

Steps I took:

1. ensured proper file path
2. ensured proper TOML file structure, fields, and values.
3. tried just directing to config.toml and just connections.toml
4. ensured proper read/write access for owner (same as when running the program)
5. ensured values work if I use a regular connection string

---

6. What did you expect to see?
   What should have happened and what happened instead?

I expected the success message from fmt.Printf("Congrats! You have successfully run %v with Snowflake DB!\n", query)

But instead I see

failed to connect. 260001: user is empty,
exit status 1

7. Can you set logging to DEBUG and collect the logs?

   https://community.snowflake.com/s/article/How-to-generate-log-file-on-Snowflake-connectors

   Before sharing any information, please be sure to review the log and remove any sensitive
   information.

I can't specify the logs since it doesn't pick-up my config.toml file

[sfc-gh-dszmolka]

hello @erickdcohen - thank you for drawing our attention to this gap.

i don't think this ever worked; we never get to the part in the tomlfileconnection.go where the function parsing the TOML config would be called.

I was able to get around the issue by

1. exporting the function loading the connection config both in driver.go and connection_configuration.go

diff --git a/connection_configuration.go b/connection_configuration.go
index 842d0ba..a4e710a 100644
--- a/connection_configuration.go
+++ b/connection_configuration.go
@@ -27,7 +27,7 @@ const (
 // LoadConnectionConfig returns connection configs loaded from the toml file.
 // By default, SNOWFLAKE_HOME(toml file path) is os.snowflakeHome/.snowflake
 // and SNOWFLAKE_DEFAULT_CONNECTION_NAME(DSN) is 'default'
-func loadConnectionConfig() (*Config, error) {
+func LoadConnectionConfig() (*Config, error) {
 	cfg := &Config{
 		Params:        make(map[string]*string),
 		Authenticator: AuthTypeSnowflake, // Default to snowflake
diff --git a/driver.go b/driver.go
index d205a7e..68be19b 100644
--- a/driver.go
+++ b/driver.go
@@ -22,7 +22,7 @@ func (d SnowflakeDriver) Open(dsn string) (driver.Conn, error) {
 	logger.Info("Open")
 	ctx := context.Background()
 	if dsn == "autoConfig" {
-		cfg, err = loadConnectionConfig()
+		cfg, err = LoadConnectionConfig()
 	} else {
 		cfg, err = ParseDSN(dsn)
 	}

2. and modifying the TOML example cmd

--- a/cmd/tomlfileconnection/tomlfileconnection.go
+++ b/cmd/tomlfileconnection/tomlfileconnection.go
@@ -8,7 +8,7 @@ import (
 	"fmt"
 	"log"
 
-	_ "github.com/snowflakedb/gosnowflake"
+	sf "github.com/snowflakedb/gosnowflake"
 )
 
 func main() {
@@ -19,7 +19,9 @@ func main() {
 	// os.Setenv("SNOWFLAKE_HOME", "<The directory path where the toml file exists>")
 	// os.Setenv("SNOWFLAKE_DEFAULT_CONNECTION_NAME", "<DSN Name>")
 
-	db, err := sql.Open("snowflake", "autoConfig")
+	cfg, _ := sf.LoadConnectionConfig()
+	dsn, _ := sf.DSN(cfg)
+	db, err := sql.Open("snowflake", dsn)
 	if err != nil {
 		log.Fatalf("failed to connect. %v,", err)
 	}

3. and using a very simple connections.toml

# cat $HOME/.snowflake/connections.toml 
[default]
account = "myorg-myaccount"
user = "admin"
password = "password"

This seems to have worked:

root@38aa7a6c5577:/go/gosnowflake# go run cmd/tomlfileconnection/tomlfileconnection.go 
Congrats! You have successfully run SELECT 1 with Snowflake DB!

but this is more like a stopgap, rather than a proper solution.

Also the whole thing is not documented at all, besides not working :) We have some work to do here.

[sfc-gh-dszmolka]

possibly fixed with #1530