I want to get permission to create schema in COSMOS DB for postgresql

Question

I am currently working on migrating data from AWS Aurora database to Azure Cosmos db for postgresql.

I tried to use airbyte as a tool for that, but when I connect cosmos db as target database in airbyte, I get an error saying that I don't have permission to create schema and can't proceed.

Is there any way to get the schema creation permission?

Or is there any easy way to migrate a database in AWS to cosmos db for postgresql (azure database migration service doesn't support it at all).

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

Cosmos DB for PostgreSQL follows a role-based access control model. To create schemas, you typically need elevated permissions.

GRANT CREATE ON DATABASE your_database_name TO your_username;

GRANT CREATE ON SCHEMA schema_name TO your_username;

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful