{"record":{"id":"3b1e96dcd090ba85","repo":"googleapis/mcp-toolbox","slug":"unable-to-connect-successfully-w-3b1e96","errorCode":null,"errorMessage":"unable to connect successfully: %w","messagePattern":"unable to connect successfully: %w","errorType":"exception","errorClass":null,"httpStatus":null,"severity":"error","filePath":"internal/sources/snowflake/snowflake.go","lineNumber":72,"sourceCode":"\tSchema    string `yaml:\"schema\" validate:\"required\"`\n\tWarehouse string `yaml:\"warehouse\"`\n\tRole      string `yaml:\"role\"`\n}\n\nfunc (r Config) SourceConfigType() string {\n\treturn SourceType\n}\n\nfunc (r Config) Initialize(ctx context.Context, tracer trace.Tracer) (sources.Source, error) {\n\tdb, err := initSnowflakeConnection(ctx, tracer, r.Name, r.Account, r.User, r.Password, r.Database, r.Schema, r.Warehouse, r.Role)\n\tif err != nil {\n\t\treturn nil, fmt.Errorf(\"unable to create connection: %w\", err)\n\t}\n\n\terr = db.PingContext(ctx)\n\tif err != nil {\n\t\tdb.Close()\n\t\treturn nil, fmt.Errorf(\"unable to connect successfully: %w\", err)\n\t}\n\n\ts := &Source{\n\t\tConfig: r,\n\t\tDB:     db,\n\t}\n\treturn s, nil\n}\n\nvar _ sources.Source = &Source{}\n\ntype Source struct {\n\tConfig\n\tDB *sqlx.DB\n}\n\nfunc (s *Source) IsReadOnly() bool {\n\treturn false","sourceCodeStart":54,"sourceCodeEnd":90,"githubUrl":"https://github.com/googleapis/mcp-toolbox/blob/8cc6e09de2ad7b8bffc77751799585a1401a48eb/internal/sources/snowflake/snowflake.go#L54-L90","documentation":"PingContext failed on the newly opened Snowflake connection during Initialize; the driver connected enough to open a handle but the round-trip verification failed, so db is closed and the source is rejected.","triggerScenarios":"Thrown at internal/sources/snowflake/snowflake.go:72 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Verify account identifier, user, password, database and schema values","Check warehouse/role assignments for the user","Confirm network access and Snowflake service status"],"exampleFix":null,"handlingStrategy":"retry","validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"8cc6e09de2ad7b8bffc77751799585a1401a48eb","analyzedAt":"2026-09-05T01:10:36.887Z","contentChangedAt":"2026-09-05T01:10:36.887Z","schemaVersion":2},"datasetVersion":"2026-09-08T10:18:20.063Z"}