How to create role in citus DB using bicep + pipeline

Question

Hello,

I have created a Citus database via pipeline + bicep file. At this point I would like to automate the creation of roles in this database. Maybe with an inLinescript of sorts.
So far, all the lead I found points to this link https://learn.microsoft.com/en-us/azure/postgresql/hyperscale/howto-create-users
Where the only role creation method is to use the azure portal GUI.

Please let me know if this is possible, thanks in advance much appreciated.

Answer 1

Hi @Yan Xue Thank you for posting your question on Microsoft Q&A and for using Azure services.

My understanding is that you are asking if you can use bicep script to automate user role creation in Azure PostgreSQL Citus.

The answer is that we don’t have Bicep and ARM templates documented at this time. The pre-requisite for finalizing Bicep/ARM is release (GA) of our REST APIs. We expect to GA the APIs in the coming months. You can create user role manually using the Azure Portal or CLI.

Please let me know if you need more assistance on this. We will be more than happy to help here.

Regards,
Oury