How to connect Redshift database using Node JS

Question

I am not able to connect to the redshift database using Node. I am using Node JS version 14.15.1. Is there any issue related to this version?

The following code, I have tried in my local machine, redshift.js file

var Redshift = require('node-redshift');
 
var client = {
    user: 'user',
    database: 'db',
    password: 'password',
    port: port,
    host: 'hostname',
};

var redshiftClient = new Redshift(client, {rawConnection:true});
 
module.exports = redshiftClient;

The following is the code to get the values from database, index.js file

var redshiftClient = require('./redshift.js');

console.log('Before Connection');
redshiftClient.connect(function(err){
console.log('After Connection');
    if(err) throw err;
    else{
      redshiftClient.query('SELECT * FROM "customer"', {raw: true}, function(err, data){
        if(err) throw err;
        else{
          console.log(data);
          redshiftClient.close();
        }
      });
    }
  });

If I run this code not getting the error and even this line is also not executed console.log('After Connection');

I have used the node version 12.13.1 and issue is solved for me. — Sriguru Velusamy
– Sriguru Velusamy, Commented Jun 17, 2021 at 12:08
The same code I have used in AWS Lambda function but getting empty response. Why? — Sriguru Velusamy
– Sriguru Velusamy, Commented Jun 18, 2021 at 5:33
Please follow the link, this code works for me. stackoverflow.com/questions/68080267/… — Sriguru Velusamy
– Sriguru Velusamy, Commented Jun 23, 2021 at 12:07
Instead of Raw Connection use Connection Pooling <github.com/dmanjunath/node-redshift#connection-pooling> — krishnakumar Balasubramaniam
– krishnakumar Balasubramaniam, Commented Aug 5, 2021 at 11:12

Pavel Slepiankou · Accepted Answer · 2021-06-17 12:10:09Z

3

The package seems a bit abandoned as here's an open issue with exact issue

To solve that you need to apply this solution manually

go to node_modules/node-redshift and replace

  "dependencies": {
    "commander": "^2.9.0",
    "migrate": "^0.2.2",
    "pg": "^6.1.2",
    "sql-bricks": "^1.2.3"
  },

in package.json to

  "dependencies": {
    "commander": "^2.9.0",
    "migrate": "^0.2.2",
    "pg": "^8.1.5",
    "sql-bricks": "^1.2.3"
  },

run npm install in this directory in order to update this package. After that your code will work

answered Jun 17, 2021 at 12:10

Pavel Slepiankou

3,5752 gold badges27 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sriguru Velusamy Over a year ago

In node_modules/node-redshift folder you have mentioned "pg": "^6.1.2", but in the package.json file the version for the pg is different ``` "pg": "^8.1.5",```. Is it the same?

Collectives™ on Stack Overflow

How to connect Redshift database using Node JS

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related