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 1,113 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 18, 2020 by MD
• 95,460 points

Related Questions In AWS

0 votes
0 answers
0 votes
1 answer
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
3,239 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP