From the course: Text to SQL: Amazon Redshift Serverless for Generative SQL in Amazon Q

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Launching query editor

Launching query editor

From the course: Text to SQL: Amazon Redshift Serverless for Generative SQL in Amazon Q

Start my 1-month free trial Buy for my team

Launching query editor

“

- [Instructor] Now that we've created our second work group, let's navigate to demo-namespace-team1, and we'll click into Query data, which will allow us to access Amazon redshift query editor v2, which is our web-based client, to allow us to generate SQL queries. So we'll expand this column and we can see if we just expand Serverless demo-insights-team1, we can see that we have a native database, which includes two databases. So we've got dev database, and this includes a public schema and we don't have any existing tables. And in the shortcut over here, we can create tables and we can also load data. So we'll click into Create and we'll select Table. And we just want to ensure that we have the correct work group. So don't want to select the default and I want to create a table under Serverless demo-insights-team, and it's under the dev database. And I also want to select the right schema, so it's a public schema and I'll give it a quick name, as well. So I'll just call my table…

Contents