Does Redshift Serverless Support Load from Remote Host via SSH?

0

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!

demandé il y a 3 mois116 vues
2 réponses
1

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 <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.

profile picture
EXPERT
répondu il y a 3 mois
  • But "describe-clusters" and "cluster-identifier" applies to the provisioned redshift, not serverless? The question is about serverless. There are no "cluster" - but "namespaces" and "workgroups". I spent a lot of time looking for the key for those things. Could not find it.

0

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

Data API: getting-started-with-amazon-redshift-data-api

Hope this helps.

profile picture
répondu il y a 3 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions