SNOW-1230605: Easy logging garbage in std out make it unusable

[velocityzen]

1. What version of NodeJS driver are you using?
   1.10.0

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

3. What version of NodeJS are you using?
   (node --version and npm --version)
   20.11.1

4. What are the component versions in the environment (npm list)?
   what component?

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

SELECT CURRENT_VERSION();

6. What did you do?

Every time I start my application I have this output:

(node:46590) [DEP0040] DeprecationWarning: The `punycode` module is deprecated. Please use a userland alternative instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
{"level":"INFO","message":"[9:48:23.841 AM]: Trying to initialize Easy Logging"}
{"level":"INFO","message":"[9:48:23.846 AM]: No client config file found in default directories"}
{"level":"INFO","message":"[9:48:23.846 AM]: Easy Logging is disabled as no config has been found"}

it makes stdOut completely unusable.

7. What did you expect to see?

nothing

[sfc-gh-dszmolka]

hi, would setting snowflake.configure({ logLevel: "WARN" }); help you perhaps ?
to completely eliminating logs from the driver, you can set it to OFF too.

edit: the new INFO level messages you're seeing are associated with the new Easy Logging feature where we wanted to give some feedback to the users about initialization, etc. If you don't need those messages, perhaps setting th log level a bit lower could help reduce the number of messages, while still keeping those which are more important like warnings, errors, etc.

[velocityzen]

The "OFF" setting would be very nice, but typescript type don't have that right now. I'll force use "OFF" for now. Thank you!

[sfc-gh-dszmolka]

glad to hear it could help you ! on a separate note we're also working on having the types for the snowflake-sdk as part of the library (#309) so hopefully it'll be easier in the future.

marking this one as closed for now as issue has been resolved, but if you need further help, please do comment and i can reopen

[cleve-fauna]

Its pretty annoying. Could we get that default information about easy logging out of there?

[sfc-gh-dszmolka]

thanks folks for all this feedback. will try to address it in #886

[sfc-gh-dszmolka]

TIL from #886 (comment) that logging EasyLogging messages on INFO level is a request from Snowflake Security team for compliance, and it's not allowed to change it to DEBUG. So it stays on INFO apparently, apologies everyone.

If it's disturbing, please set a higher general loglevel or turn it OFF , see #794 (comment)

[markddrake]

OFF fixed it thanks

FWIW my product supports copying data to and from Oracle, Microsoft, MySQL, Postgres, MariaDB, MongoDB, Yugabyte, Cockroach DB, Amazon AWS S3 BLOB, Microsoft Azure-BLOB, IBM-DB2, Vertica and none of their SDKs dump spurious log messages by default.

[bcardiff]

I'm facing this issue, but even if I do

snowflake.configure({
  logLevel: "OFF",
  additionalLogToConsole: false
})

I still see one log entry in the stdout.

{"level":"INFO","message":"[5:29:46.973 PM]: Configuring logger with level: -1, filePath: undefined, additionalLogToConsole: false"}

Is there a way to turn off all the logging? The process I'm working on needs to be in total control of what it is sent to stdout.

[sfc-gh-dszmolka]

@bcardiff you're experiencing #957

[bcardiff]

Yes! 🎯 Thank you @sfc-gh-dszmolka . The workaround shown there is enough for me.