Create databases and collections via API thorough Terraform
Create databases (DB) and collections via API thorough Terraform after the cluster has been created in Atlas. This would provide the ease of writing and running it in a single script before any data is loaded.
Vijay
shared this idea
-
Joel
commented
Seems like there's some questions here surrounding what this might look like from the Mongo team. As an example you could look at this Postgres provider (not a recommendation as I've never used it):
- https://registry.terraform.io/providers/cyrilgdn/postgresql/latest/docs/resources/postgresql_schema
- https://registry.terraform.io/providers/cyrilgdn/postgresql/latest/docs/resources/postgresql_databaseI know Mongo isn't a relational database but there are some schema-related tasks (creation of collections, addition of indexes, etc.) that would be great to manage via Terraform. It becomes even more important to add this for Mongo as there are many tools for schema versioning/migration for relational databases but an absolute absence in the Mongo space. Adding this capability would bring the familiar Infrastructure as Code (IaC) and migration tools from the relational world to the flexible world of Mongo.
-
Srikaanth
commented
This feature would help my team a lot as well. Is this work in progress
-
Vineet
commented
would be helpful
-
Mostefa
commented
My team needs this feature aswell. Is it a wip?
-
Anton
commented
At the moment we generate a lot of new DB and collections for our clients. Right now we use TF for create user and set privileges but have no possibilities to create DB and fill collections necessary data. for these purposes we use some executing scripts. Meanwhile Microsoft provide this option. You can find more details here https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/cosmosdb_mongo_collection
-
Hi Ravindra and other here, Currently the Atlas API focuses on administration functions and the authentication to that is via a programmatic key that does not have access to the data layer, since our Terraform provider covers this API it is providing functions inline with the capabilities of the API. However, it would be great to know more around use cases that are driving this request. If you'd like to share/discuss it would be great to talk. Feel free to reply here or reach out to me directly, melissa.plunkett@mongodb.com. -Melissa
-
Ravindra
commented
Is there any updates on this one?
-
Siddharth
commented
Allow creation of collections and indexes via terraform atlas plugin. The use case is that, when an atlas cluster is being set up, we want to enable the indexes on the collections from the start.
-
Hi Anton,
Can you elaborate on what you're asking here?
Thanks
-Andrew -
Anton
commented
Please create functionality for operating data in collections of MongoDB
-
David
commented
This would be great feature !
-
David
commented
I would be great if the MongoDB Atlas provider would support the creation of databases. At the moment you still have to create custom scripts to provision databases inside a cluster.
