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 in AWS by Anjani Kumar
• 140 points

recategorized Aug 17 by MD 97 views

1 answer to this question.

0 votes

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 } }
answered Aug 17 by MD
• 56,480 points

Related Questions In AWS

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,600 points
801 views
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,200 points
309 views
0 votes
1 answer