provider-sql
provider-sql copied to clipboard
Support Azure Username Format
What problem are you facing?
Azure Postgres instance connection string use a username formatted as <role_name>@<database_name>. This make it impossible to use the connection string directly since username returned is only the role name
How could Crossplane help solve your problem?
The role.postgresql.sql.crossplane.io resource could add an optional field for a user suffix and be use to template the correct connection string username
The Azure docs suggest to escape the @ with %40: https://docs.microsoft.com/en-us/azure/postgresql/single-server/tutorial-design-database-using-azure-portal#connect-to-postgresql-database-using-psql
Does that work on your end?