Does Redshift Serverless Support Load from Remote Host via SSH?

Question

Redshift Provisioned has this capability as documented here: https://docs.aws.amazon.com/redshift/latest/dg/loading-data-from-remote-hosts.html
I can't find a way to make that Step 1 work with serverless. I need to add a public key to my host in order to make this work. Where do I get the key with serverless?
Thanks!

Answer

To retrieve the cluster public key and cluster node IP addresses for your cluster using the Amazon Redshift CLI, run the describe-clusters command
```
aws redshift describe-clusters --cluster-identifier  
```

And then you securely store the SSH public key in AWS KMS. This ensures that the key is encrypted at rest and can only be accessed by authorized entities. Then implement AWS Lambda functions to handle authentication tasks, retrieving the public key from KMS when needed.

Answer

Hello Poliakov.

According to the documentation, you can connect to Redshift Serverless via JDBC and DATA API (CLI commands). Maybe you can adapt what you're doing to use the Data API.
Hope this helps.

RS Connection Types:
[Connecting to Amazon Redshift Serverless](https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-connecting.html)

Data API:
[getting-started-with-amazon-redshift-data-api](https://github.com/aws-samples/getting-started-with-amazon-redshift-data-api#readme)

Hope this helps.

Does Redshift Serverless Support Load from Remote Host via SSH?

Relevant content