Is it advisable to use vertex AI datastore as backend database?

[gdsgcp]

We are in our proof-of-concept phase, and we need to upload an application directory in csv format. I can generate an appropriate response from datastore but design wise, is it the best resource to use?

[jaia]

Hello,

Thank you for contacting the Google Cloud Community.

• Using Datastore as a resource for your application directory CSV is a viable option, but for very large datasets or frequent updates, the performance might be slower compared to other storage options, especially if you need to perform complex queries.
• Ensure that your application directory data fits well within Datastore's hierarchical data model. If you have a more relational data structure, other options like BigQuery might be more suitable.
• If you have a relational data structure or need to perform complex analytics, BigQuery might be a better choice. It offers high performance and scalability for large datasets.
• If you simply need to store files without requiring complex querying or data manipulation, Cloud Storage is a cost-effective option.

I am attaching some useful links:  

[1] What is the purpose of Datastore in Google Cloud Platform?

[2] Datastore | Google Cloud

Regards,
Jai Ade

[jaia]

Hello,

Thank you for your engagement regarding this issue. We haven’t heard back from you regarding this issue for sometime now. Hence, I'm going to close this issue which will no longer be monitored. However, if you have any new issues, Please don’t hesitate to create a new issue. We will be happy to assist you on the same.

Regards,
Jai Ade