How to create a redshift table from existing cluster using typescript?

Question

I have a ec2 instance from which I'm trying to connect to redshift cluster. With the below code I'm able to create a new redshift cluster but I am looking for examples as to how I can connect to an existing redshift cluster.

const cluster = new Cluster(this, YYYY, {
      clusterName: 'XXXXXX',
      clusterType: ClusterType.SINGLE_NODE,
      defaultDatabaseName: databaseName,
      masterUser: {
        masterUsername: 'admin_user',
      },

John Rotenstein · Answer

You can connect to Amazon Redshift by using a JDBC connection (drivers), or anything that would connect to a PostgreSQL database.

Alternatively, you can Use the Amazon Redshift Data API - Amazon Redshift, which accesses the database via an AWS API call.

How to create a redshift table from existing cluster using typescript?

1 Answers