Updating generative SQL settings as an administrator - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Updating generative SQL settings as an administrator

A user with the right IAM permissions can view and change Generative SQL settings for other users in the same Amazon Web Services account. This administrator must have permission sqlworkbench:UpdateAccountQSqlSettings in their IAM policy, in addition to other permissions specified in the Amazon managed policy for query editor v2. For more information about managed policies, see Permissions required to use the query editor v2 .

For an administrator to turn on generative SQL chat for all users in the account

  1. Choose the Settings Settings icon to show a menu of the different settings screens.

  2. Then choose the Generative SQL settings Generative SQL settings icon to show the Q generative SQL settings page.

  3. Select Q generative SQL settings to turn on the generative SQL capability for users in the account.

    After you turn on Amazon Q generative SQL, you can view the number of prompts left in your allocation. The query editor v2 administrator can enable users in the account to use Amazon Q Developer Pro tier. To use the Pro tier, set up your users with IAM Identity Center and subscribe each user to Amazon Q Developer Pro tier. For information about setting up IAM Identity Center with Amazon Redshift, see Connect Redshift with Amazon IAM Identity Center for a single sign-on experience. For information about Amazon Q Developer pricing, see Amazon Q Developer pricing.

    When using Amazon Q Developer Free tier, the total number of prompts of all users of an Amazon Web Services account is limited to 1,000 in a month. When using Amazon Q Developer Pro tier, the total number of prompts that any individual user can submit is limited to 1,000 in a month. You can view the number of prompts available on the Settings page. For information about Amazon Q Developer pricing, see Amazon Q Developer pricing.