Redshift Endpoint Outdated

0

I noticed that the endpoint associated with my redshift cluster is outdated. Currently it ends with the name of the database that I first created the cluster with, but I have since renamed that database and now the endpoint doesn't work anymore unless I manually change it. Is there any way to permanently refresh it to make sure it doesn't become outdated again?

preguntada hace 2 años252 visualizaciones
1 Respuesta
0

In this case, you need to specify the new database by yourself.

I assume you want to change the "dbName" in the "Endpoint" displayed in Redshift console's "General information". Endpoint example:

# provisioned
my-cluster.xxx.<region>.redshift.amazonaws.com:<port>/<dbName>
# serverless
my-workgroup.<accountid>.<region>.redshift-serverless.amazonaws.com:<port>/<dbName>

The <dbName> is displaying the name of initial database when you create a cluster or a namespace and it cannot be changed after creation for both provisoned and serverless. Description for dbName is in following document and AFAIK there are no apis to update this.

DBName -> (string)

The name of the initial database that was created when the cluster was created. This same name is returned for the life of the cluster. > If an initial database was not specified, a database named dev dev was created by default.

dbName -> (string)

The name of the first database created in the namespace.

Therefore, as you mentioned, the database name in the endpoint will be outdated if you alter or drop the initial database.

AWS
Yota_H
respondido hace 2 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas