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

+2 votes
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 )
Aug 14, 2020 in AWS by Anjani Kumar
• 140 points

recategorized Aug 18, 2020 by MD 360 views

1 answer to this question.

0 votes


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 } }
answered Aug 18, 2020 by MD
• 95,320 points

Related Questions In AWS

0 votes
0 answers
0 votes
1 answer

How can I just increase the size of my root disk on AWS EC2 for use with Elastic Beanstalk?

This can be done using the following ...READ MORE

answered Nov 12, 2018 in AWS by Archana
• 5,640 points
0 votes
1 answer

How can I create tables in Athena?

Creating tables in Athena is very easy. ...READ MORE

answered Jan 17, 2019 in AWS by Edureka
• 4,220 points
0 votes
1 answer