Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

149
Views
Snowflake NodeJS `snowflake-sdk` response when `fail-open` warning occurs

Snowflake nodejs snowflake-sdk execute function has a complete property which value is a callback function with the following parameters err, stmt, rows

By default the connection is fail-open.

What is the shape of the response specifically for rows property when a user gets the fail-open connection warning as follows:

""message":"[8:08:42.842 AM]: WARNING!!! using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificated Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details:","level":"INFO"}

My execute function integration code looks like this:

connection.execute({
  sqlText: `${sqlQuery}`,
  complete: function(err, stmt, rows) {
    if (err) {
      console.error(`Failed to execute statement due to the following error: ${err.message}`);
    } else {
      rows.forEach((row) => {
        for(let key in row) {
          if(isDate(row[key])) {
            row[key] = row[key] + "";
          }
        }
        //out the data to the console
        console.log(JSON.stringify(row)); <<--- row has to be an array of objects with column names as keys and their valuse
      });
    }
  }
});

Because a third party tool I'm integrating with, require row to be an array of objects (see the code snippet above) when there is no fail-open warning, the shape of the response is send as expected, but when the warning occurs, the response is being malformed.

Unfortunately I'm unable to replicate the issue as I don't have access to the system that returns the mentioned above warning.

Does the rows response property contain more properties than just an array of objects with query results when there is fail-open warning?

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!