Federated user configuration

With Amazon Redshift federated permissions, users authenticated with IAM or IAM Identity Center (IdC) credentials can get a consistent experience across all their Amazon Redshift warehouses.

When a user connects to any Redshift cluster, their configuration parameters—such as date format, search path, and time zone preferences—are automatically applied to their session. This ensures that the same user experience is maintained across all clusters, without requiring manual reconfiguration, providing a seamless and personalized experience.

Example

Consider Alex, a data analyst who has configured their preferred date format and time zone in their primary Redshift database. When Alex runs queries there, all date values appear in the preferred format.

Now, when Alex connects to a shared or auto-mounted database on another Redshift warehouse, those same preferences are consistently applied. Alex sees results in the same date format and time zone, ensuring a consistent experience across environments.

User Configs that are consistent across Amazon Redshift Warehouses

The following user-level configurations are automatically synchronized across Redshift clusters for users authenticated with IAM or AWS IAM Identity Center (IdC) credentials:

Connection and Configuration Management