- Le plus récent
- Le plus de votes
- La plupart des commentaires
Hi Sarbajit,
This is what I found as per AWS Whitepaper. https://docs.aws.amazon.com/cli/latest/reference/redshift/restore-table-from-cluster-snapshot.html **--source-schema-name (string)
The name of the source schema that contains the table to restore from. If you do not specify a SourceSchemaName value, the default is public .**
As well you can view the of all schemas on available on Redshift, via querying the PG_NAMESPACE. I'm assuming its must be postgres. So PostgreSQL queries must work here. select *from pg_namespace. https://docs.aws.amazon.com/redshift/latest/dg/r_Schemas_and_tables.html
Conclusion: As per the above docs, it seems you need to backup your existing schema(may be snapshot) but while restoring you have to target the schema only.
Contenus pertinents
- demandé il y a 6 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 9 mois
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 4 mois