SNOW-2135301: Connection fails when Host is provided but Account is not

[frbvianna]

1. What version of GO driver are you using?
   1.14.1

2. What operating system and processor architecture are you using?
   macOS 15.3.1, ARM64

3. What version of GO are you using?
   1.24.1

4. Server version:
   9.14.2

5. What did you do?

Try to connect by initializing a Connector using Config instead of DSN:

	ctor := gosnowflake.NewConnector(gosnowflake.SnowflakeDriver{}, gosnowflake.Config{
		Host:     "<account>.snowflakecomputing.com",
		Port:     443,
		User:     "<user>",
		Password: "<pwd>",
		Database: "<db>",
	})

	_, err := ctor.Connect(ctx)
	if err != nil {
		return fmt.Errorf("failed to connect to Snowflake: %w", err)
	}

6. What did you expect to see?

Expected to be able to connect since the account identifier can be implied from the Host, but received the following error instead:
failed to connect to Snowflake: 260000: account is empty

Can't the driver parse the account from the host similarly to how it's done in ParseDSN?

gosnowflake/dsn.go

Lines 427 to 430 in a1a961d

	posDot := strings.Index(cfg.Host, ".")
	if posDot > 0 {
	cfg.Account = cfg.Host[:posDot]
	}

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

   N/A

[sfc-gh-dszmolka]

hello - this looks to be kind of a duplicate for #1054. Can you please take a look at the explanation provided ?

edit: of course if you're open to submit a PR with this enhancement you have in mind, that contribution would be welcome!

[frbvianna]

Hi @sfc-gh-dszmolka, thanks for the quick response.
It looks to be similar to #1054 but different in that I'm not trying to get a connection string, just use the Config directly. Should I not be able to connect if I have just the host and port, and the account can be inferred from the host?
Currently, we have an application where only the host and port are provided by the user, so I'm having to parse the account name similarly to how it's done in ParseDSN and it looks like something that the driver could be doing instead.

[sfc-gh-dszmolka]

i can agree with you; that the driver could just parse the account out of Host; current implementation (in all Snowflake drivers) is account being mandatory almost everywhere. It can be improved though; hence I asked if it's within your possibilities. If not, that is not an issue at all; the team will look at it eventually.