Posted On: Jun 7, 2023
HAQM Redshift Serverless now allows you to schedule your SQL queries for staging in recurring schedules. You can now automate time sensitive or long running queries, loading or unloading your data using HAQM Redshift Query Editor V2 or HAQM Redshift Data API with flexible scheduling expressions, including cron expressions, for optimal control over query execution timing. The query scheduling is secured as you can either leverage your IAM credentials or secrets stored in AWS Secrets Manager.
HAQM Redshift Serverless now supports Single sign-on with Identity Provider(IdP). You can now pass a list of database roles granted to a user based on his/her IdP group membership. As an administrator, you need to configure your Identity Provider(IdP) to pass in database roles by adding specific principal tags as SAML attributes. You can use single sign-on support with HAQM Redshift Query Editor V2, JDBC/ODBC clients, and Data API.
The features are available in all regions that support HAQM Redshift Serverless. For a list of AWS Regions where the HAQM Redshift Serverless is available, see the endpoints listed for Redshift Serverless API in the HAQM Web Services General Reference.
To get started, see the following list of resources:
- Scheduling HAQM Redshift Data API
- Documentation for scheduling a query with query editor v2
- Demo Video: Scheduling a query with query editor v2
- Federate HAQM Redshift Serverless with Okta using Query Editor V2 and SQL client
- Defining database roles to grant to federated users in HAQM Redshift Serverless