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,400 courses taught by industry experts.

Accessing query history

Accessing query history

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

Accessing query history

“

- [Instructor] Oftentimes, data teams are really busy. They receive a lot of requests regarding access to different tables and ad hoc requests, but sometimes we receive different requests from different project teams to have access to their tables and also databases. So as we know, Amazon Q Generative SQL is personalized to our schema. And as a database administrator, we have the ability, we have full access to grant restricted access to data analysts, data scientists, and data engineers, certain access to our database for a specified period. So let's navigate to Amazon Redshift, and let's create a role. So as we know, we will click into the editor. But before we do that, let's navigate to our settings. And as a database administrator, we have full administrative rights, and we know that Amazon Q has already been enabled, and we have the ability to grant access or remove access as administrator and based on different roles and permissions. So we'll click into the plus sign to open up…

Contents