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.

Viewing the schema

Viewing the schema

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

Viewing the schema

“

- [Instructor] Now that we've created our database in Amazon Redshift Serverless, created our table and also loaded data into our table, let's explore our database schema. One option to view our database schema is to launch Amazon Redshift Query Editor V2, and on the left hand side, we may view more details. If we open up the dropdown menu, we may view firstly the dev database and then the public schema. We may also view a table called Sydney House Prices. If we double click on the table, we'll be able to view the column names and the corresponding data types. If we are a super user or own the schema, we may alternatively write an SQL statement to show the schema. In the simple example below, In Query Editor V2, we may write show schemas from, and then provide two details, which includes our database name, called "SAP_HR," followed by our table name called "employees."

Contents