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

paradigmshift 0 Reputation points
2024-11-01T16:28:46.5533333+00:00

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).

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,659 questions
Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. hossein jalilian 8,080 Reputation points
    2024-11-01T16:43:37.67+00:00

    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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.