How Can I Configure an HVR Hub Repository with a Non-Public Schema in Aurora PostgreSQL?

Question

How can I configure the HVR Hub Repository to use a non-public schema in Aurora PostgreSQL?

Environment

• HVR 6
• Database: Aurora PostgreSQL
• Database user with ALTER USER permissions

Answer

To configure an HVR Hub Repository with a non-public schema in Aurora PostgreSQL, set the database user's search path by running the following command. Replace <username> and <schema_name> with the actual database username and non-public schema name:

ALTER USER <username> SET search_path TO <schema_name>;

You can't configure a non-public schema for an Aurora PostgreSQL hub repository in the Fivetran HVR UI.

For more information, see Repository Database in Aurora PostgreSQL.