Create Database on Amazon Redshift with Query Editor

Question

I've created a Redshift cluster using the AWS management console. The cool thing that AWS setup was this query editor to be able to write queries directly on your cluster without having to install a SQL client on your computer.

However, I was trying to create a new database on the instance but it doesn't seem to be possible using AWS query editor. Am I right or did I miss something?

What did you try to run? What were the results? Were there errors? Your question needs to include more information — Ngenator
– Ngenator, Commented Dec 20, 2019 at 15:31

Antoine Krajnc · Accepted Answer · 2019-12-20 15:32:21Z

2

I indeed missed something, you simply need to go into your query editor and write

CREATE DATABASE db_name OWNER=db_owner;

answered Dec 20, 2019 at 15:32

Antoine Krajnc

1,33315 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

liquidpele Over a year ago

For anyone else that got here... the default database name to auth to is "dev", it's hidden in the extra settings when creating the cluster.

Collectives™ on Stack Overflow

Create Database on Amazon Redshift with Query Editor

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related