Can I create new fact tables in Redshift after the data is imported or I can just import data and run queries but can t change my schema in Redshift

Question

I know that we can import data for a already existing schema in Redshit but my doubt is can we import some data to redshift and change the schema in Redshift(for eg creataing a new fact table )

Answer 1

Hi@Anjani,

You can change the definition of an existing schema. Use this below command to rename a schema or change the owner of a schema.

ALTER SCHEMA schema_name { RENAME TO new_name | OWNER TO new_owner | QUOTA { quota [MB | GB | TB] | UNLIMITED } }